diff options
| author | Magnus Hagander <magnus@hagander.net> | 2019-03-09 10:45:17 -0800 |
|---|---|---|
| committer | Magnus Hagander <magnus@hagander.net> | 2019-03-09 10:47:30 -0800 |
| commit | 6b9e875f7286d8535bff7955e5aa3602e188e436 (patch) | |
| tree | bedeb8b9ba38b7aa151c329830589dc14bed292c /doc/src | |
| parent | 3c5926301aea476025f118159688a6a88b2738bc (diff) | |
| download | postgresql-6b9e875f7286d8535bff7955e5aa3602e188e436.tar.gz postgresql-6b9e875f7286d8535bff7955e5aa3602e188e436.zip | |
Track block level checksum failures in pg_stat_database
This adds a column that counts how many checksum failures have occurred
on files belonging to a specific database. Both checksum failures
during normal backend processing and those created when a base backup
detects a checksum failure are counted.
Author: Magnus Hagander
Reviewed by: Julien Rouhaud
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 0e73cdcddab..e2630fd3682 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -2509,6 +2509,11 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i <entry>Number of deadlocks detected in this database</entry> </row> <row> + <entry><structfield>checksum_failures</structfield></entry> + <entry><type>bigint</type></entry> + <entry>Number of data page checksum failures detected in this database</entry> + </row> + <row> <entry><structfield>blk_read_time</structfield></entry> <entry><type>double precision</type></entry> <entry>Time spent reading data file blocks by backends in this database, |