Thread: pg_stat

Just wondering how often the stats collector resets it self. Is this a
parameter i can change?

Nailah Ogeer wrote:
> 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.


Regards
Gaetano Mendola

>> 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