]> granicus.if.org Git - postgresql/commit
Show shared object statistics in pg_stat_database
authorMagnus Hagander <magnus@hagander.net>
Fri, 12 Apr 2019 12:04:50 +0000 (14:04 +0200)
committerMagnus Hagander <magnus@hagander.net>
Fri, 12 Apr 2019 12:04:50 +0000 (14:04 +0200)
commit77bd49adba4711b4497e7e39a5ec3a9812cbd52a
treed3c6d62589617760429da962e80f30efa9fc52d2
parentef6f30fe77af69a8c775cca82bf993b10c9889ee
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>
doc/src/sgml/monitoring.sgml
doc/src/sgml/ref/initdb.sgml
doc/src/sgml/ref/pg_basebackup.sgml
src/backend/catalog/system_views.sql
src/backend/postmaster/pgstat.c
src/backend/replication/basebackup.c
src/backend/utils/adt/pgstatfuncs.c
src/include/catalog/pg_proc.dat
src/include/pgstat.h
src/test/regress/expected/rules.out