On Thu, Apr 21, 2011 at 1:01 AM, Mario Splivalo
<mario.spliv...@megafon.hr>wrote:
> I have set up munin monitoring that plots nice graphs using
> pg_stat_bgwriter and pg_stat_database views. It has been on for quite some
> time now, and the numbers those views return are too big for munin to
> handle. I would like to reset those statistics. As explained by manual,
> pg_stat_reset() resets only db-related statistics, not the ones used
> cluster-wide. Is there a way to reset those? I don't mind stopping the
> server if I need to, but I'd realy like to have those started all over
> again.
>
Currently we don't have such feature to reset statistics on cluster level.
You have to use two PostgreSQL functions like pg_stat_reset_shared(text),
pg_stat_reset ().
There are a few statistics that are only kept on a per-cluster basis, such
as those reported in pg_stat_database and pg_stat_bgwriter. Since
pg_stat_reset only resets per-database statistics.
psql=# select pg_stat_reset();
psql=# select pg_stat_reset_shared('bgwritter'); -- It will reset the
statistics shown by pg_stat_bgwritter.
--Raghu Ram
>
> Mario
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
