Cumulative and live views
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_database
, pg_stat_bgwriter
, and all of the other views whose names start with pg_stat
.
The exact way that you reset these counters back to 0 again varies quite a bit based on your PostgreSQL version:
- Version 8.1:
pg_stat_reset()
resets all statistics. Enablingstats_reset_on_server_start
in thepostgresql.conf
file will reset everything each time the server is started. - Version 8.2:
pg_stat_reset()
resets just block and row level statistics. Enabling ...
Get PostgreSQL 9.0 High Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.