pg_stat_reset not resetting all stats
Started by Brad Nicholsonover 17 years ago2 messagesgeneral
Is there a reason that pg_stat_reset doesn't reset the stats in
pg_stat_bgwriter and pg_stat_database? PG 8.3 (obviously).
The call to pg_stat_reset works, as my other stats tables are clear.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
Re: pg_stat_reset not resetting all stats
Brad Nicholson <bnichols@ca.afilias.info> writes:
Is there a reason that pg_stat_reset doesn't reset the stats in
pg_stat_bgwriter and pg_stat_database? PG 8.3 (obviously).
It is only supposed to reset counters associated with the current
database. Those counts are cluster-wide.
regards, tom lane