Reseting statistics, cluster wide

From: Mario Splivalo <mario(dot)splivalo(at)megafon(dot)hr>
To: pgsql-admin(at)postgresql(dot)org
Subject: Reseting statistics, cluster wide
Date: 2011-04-20 19:31:30
Message-ID: 4DAF3492.1000205@megafon.hr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Mario

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message raghu ram 2011-04-20 20:49:46 Re: Reseting statistics, cluster wide
Previous Message Simon Riggs 2011-04-20 15:57:35 Re: database system identifier differs between the primary and standby