Re: pg_stat_reset() not resetting all statistics counters

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_stat_reset() not resetting all statistics counters
Date: 2009-07-15 12:25:12
Message-ID: 1247660712.5546.2.camel@bnicholson-desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2009-07-15 at 14:13 +0200, Rafael Martinez wrote:
> Hello
>
> Should not the execution of pg_stat_reset() reset *all* statistics
> counters everywhere in the database?

It only resets the stats for the current database, not the cluster wide
stats - pg_database is cluster wide.

--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rafael Martinez 2009-07-15 12:25:23 Re: pg_stat_reset() not resetting all statistics counters
Previous Message Rafael Martinez 2009-07-15 12:13:34 pg_stat_reset() not resetting all statistics counters