Contents
pg_stat_reset_shared()
A system function for resetting cluster-wide statistics
pg_stat_reset_shared() is a system function for resetting counter for various cluster-wide statistics.
pg_stat_reset_shared() was added in PostgreSQL 9.0.
Usage
pg_stat_reset_shared ( text ) → void
pg_stat_reset_shared() can be executed with one of the three following options:
archiver: resets counters shown in thepg_stat_archiverview (PostgreSQL 9.4 and later)bgwriter: resets counters shown in thepg_stat_bgwriterview (PostgreSQL 9.0 and later)wal: resets counters shown in thepg_stat_walview (PostgreSQL 14 and later)
Change history
- PostgreSQL 14
- option
waladded (commit 8d9a9359)
- option
- PostgreSQL 9.4
- option
archiveradded (commit 9132b189)
- option
- PostgreSQL 9.0
- added (commit 7e40cdc0)
Examples
Resetting pg_stat_archiver statistics:
postgres=# SELECT * FROM pg_stat_archiver\gx
-[ RECORD 1 ]------+------------------------------
archived_count | 0
last_archived_wal |
last_archived_time |
failed_count | 3
last_failed_wal | 000000010000000000000001
last_failed_time | 2021-02-19 09:33:31.498568+01
stats_reset | 2021-02-19 09:33:08.578549+01
postgres=# SELECT pg_stat_reset_shared('archiver');
pg_stat_reset_shared
----------------------
(1 row)
postgres=# SELECT * FROM pg_stat_archiver\gx
-[ RECORD 1 ]------+------------------------------
archived_count | 0
last_archived_wal |
last_archived_time |
failed_count | 0
last_failed_wal |
last_failed_time |
stats_reset | 2021-02-19 09:33:41.615664+01
Attempting to reset an invalid statistic type:
postgres=# SELECT pg_stat_reset_shared('foo');
ERROR: unrecognized reset target: "foo"
HINT: Target must be "archiver", "bgwriter" or "wal".
References
- PostgreSQL documentation: Additional Statistics Functions