Postgres Pro
Downloads
Home   >   mailing lists

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

From Brad Nicholson
Subject Re: pg_stat_reset() not resetting all statistics counters
Date
Msg-id 1247660712.5546.2.camel@bnicholson-desktop
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
Tree view 
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.

pgsql-general by date:

Previous
From: Rafael Martinez
Date:
Subject: Re: pg_stat_reset() not resetting all statistics counters
Next
From: "Abraham, Danny"
Date:
Subject: initdb --locale=LATIN1 fails on Windows