Re: pg_stat_reset not resetting all stats

Поиск
Список
Период
Сортировка
Искать

Re: pg_stat_reset not resetting all stats

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Brad Nicholson  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

pg_stat_reset not resetting all stats

От:
Brad Nicholson <bnichols@ca.afilias.info>
Дата:
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.
FAQ