pg_stat_activity
Hi all,
in the pg_stat_activity catalog there is a field called current_query but it
is in blank when i modify the
show statement stat in postgresql.conf i win nothing. what am i doing wrong?
thanks in advance,
Jaime Casanova (el_vigia)
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
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