Re: pg_stat_reset() not resetting all statistics counters - Mailing list pgsql-general

From Rafael Martinez
Subject Re: pg_stat_reset() not resetting all statistics counters
Date
Msg-id 4A5DCAB3.6020808@usit.uio.no
Whole thread Raw
In response to pg_stat_reset() not resetting all statistics counters  (Rafael Martinez <r.m.guerrero@usit.uio.no>)
List 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.m.guerrero@usit.uio.no>
 Center for Information Technology Services
 University of Oslo, Norway

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

pgsql-general by date:

Previous
From: Rafael Martinez
Date:
Subject: pg_stat_reset() not resetting all statistics counters
Next
From: Rafael Martinez
Date:
Subject: Re: pg_stat_reset() not resetting all statistics counters