There are two types of information you can monitor from the database. The main statistics are stored into counters. These counters start at 0 when you create a new database cluster, increasing with all activity related to that statistic. Counters in this category include
pg_stat_bgwriter, and all of the other views whose names start with
The exact way that you reset these counters back to 0 again varies quite a bit based on your PostgreSQL version:
pg_stat_reset()resets all statistics. Enabling
postgresql.conffile will reset everything each time the server is started.
pg_stat_reset()resets just block and row level statistics. Enabling ...