After calling pg_stat_reset, some of the database stats fields are not
actually reset, the value is preserved. I've found the bug is actually in
pgstat_recv_resetcounter function, where only some of the
PgStat_StatDBEntry fields are reset to 0.
This is true for those 6 fields:
The docs for "pg_stat_reset()" say "Reset all statistics counters for the
current database to zero (requiret superuser privileges)" and I don't see
any reason why these fields should not be reset, so I guess it's a bug.
See the patch attached (against current dev version).
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2010-12-11 17:31:31|
|Subject: Re: not all pg_stat_database fields reset after pg_stat_reset() |
|Previous:||From: Tom Lane||Date: 2010-12-11 15:44:33|
|Subject: Re: BUG #5788: I can drop table , with other user's table |