Re: pg_stat_reset() not resetting all statistics counters

From: Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_stat_reset() not resetting all statistics counters
Date: 2009-07-15 12:25:23
Message-ID: 4A5DCAB3.6020808@usit.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rafael Martinez wrote:

> But when we execute pg_stat_reset() in our databases, not all values
> reported by pg_stat_database get updated. tup_returned, tup_fetched,
> tup_inserted, tup_updated and tup_deleted still have the old values
> after running pg_stat_reset().
>
> Am I missing anything?
>

I suppose that
http://archives.postgresql.org/pgsql-hackers/2009-04/msg00520.php

explains why this happens :(

--
Rafael Martinez, <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
Center for Information Technology Services
University of Oslo, Norway

PGP Public Key: http://folk.uio.no/rafael/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rafael Martinez 2009-07-15 12:39:38 Re: pg_stat_reset() not resetting all statistics counters
Previous Message Brad Nicholson 2009-07-15 12:25:12 Re: pg_stat_reset() not resetting all statistics counters