Re: pg_stat - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: pg_stat
Date
Msg-id 3FAB0456.8010708@familyhealth.com.au
Whole thread Raw
In response to Re: pg_stat  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-hackers
>> Just wondering how often the stats collector resets it self. Is this a
>> parameter i can change?
> 
> 
> At my knowledge each time that you do an analyze on
> your db your statistics are changed ( are not incremental
> I mean), anyway you can set to reset statistics at the
> start of postgres.

I think you're mixed up there.  Stats collector is totally different thing.

The stats collector is never reset.  You can reset it manually by going:

select pg_stat_reset();

And you can specify in the postgresql.conf that it should be reset on 
server restart if you like.

Chris




pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: OpenServer 5.0.7: setsockopt(TCP_NODELAY)?
Next
From: Robert Treat
Date:
Subject: Re: [pgsql-www] Changes to Contributor List