Show shared object statistics in pg_stat_database
Magnus Hagander <magnus@hagander.net>
Show shared object statistics in pg_stat_database This adds a row to the pg_stat_database view with datoid 0 and datname NULL for those objects that are not in a database. This was added particularly for checksums, but we were already tracking more satistics for these objects, just not returning it. Also add a checksum_last_failure column that holds the timestamptz of the last checksum failure that occurred in a database (or in a non-dataabase file), if any. Author: Julien Rouhaud <rjuju123@gmail.com>
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/monitoring.sgml | modified | +18 −8 |
| doc/src/sgml/ref/initdb.sgml | modified | +3 −1 |
| doc/src/sgml/ref/pg_basebackup.sgml | modified | +2 −1 |
| src/backend/catalog/system_views.sql | modified | +10 −2 |
| src/backend/postmaster/pgstat.c | modified | +5 −1 |
| src/backend/replication/basebackup.c | modified | +2 −2 |
| src/backend/utils/adt/pgstatfuncs.c | modified | +18 −0 |
| src/include/catalog/pg_proc.dat | modified | +5 −0 |
| src/include/pgstat.h | modified | +2 −0 |
| src/test/regress/expected/rules.out | modified | +11 −2 |