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


Thu, 06 Nov 2003 23:02:27 +0000
"Jaime Casanova" <el_vigia_ec@hotmail.com>
pg_stat_activity
Just wondering how often the stats collector resets it self. Is this a
parameter i can change?



Thu, 6 Nov 2003 18:17:48 -0500 (EST)
Nailah Ogeer <ogeer@cs.queensu.ca>
pg_stat
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


Fri, 07 Nov 2003 00:28:21 +0100
Gaetano Mendola <mendola@bigfoot.com>
Re: pg_stat
>> 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



Fri, 07 Nov 2003 10:32:54 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: pg_stat