From: Mario Splivalo <mario.splivalo@megafon.hr>
To: pgsql-admin@postgresql.org
Subject: Re: Reseting statistics, cluster wide
Date: Thu, 21 Apr 2011 09:51:12 +0200
Message-ID: <4DAFE1F0.6030508@megafon.hr> (raw)
In-Reply-To: <BANLkTin5W3T8eO6xHoxXaRFF8dJ6R_OSxg@mail.gmail.com>
References: <4DAF3492.1000205@megafon.hr>
<BANLkTin5W3T8eO6xHoxXaRFF8dJ6R_OSxg@mail.gmail.com>
On 04/20/2011 10:49 PM, raghu ram wrote:
> On Thu, Apr 21, 2011 at 1:01 AM, Mario Splivalo
> <mario.splivalo@megafon.hr <mailto:mario.splivalo@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.
>
Heh, I've neglected to mention that i'm using postgres 8.4.5 on Debian
Stable. Is there a way to reset statistics on pg8.4? I've tested it on
9.0 and it works there.
Mario
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mario.splivalo@megafon.hr
Subject: Re: Reseting statistics, cluster wide
In-Reply-To: <4DAFE1F0.6030508@megafon.hr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox