Skip site navigation (1) Skip section navigation (2)

Re: pg_stat_activity versus ps

From: Jeff Amiel <jamiel(at)istreamimaging(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_stat_activity versus ps
Date: 2004-08-24 17:08:03
Message-ID: 412B75F3.5040101@istreamimaging.com (view raw or flat)
Thread:
Lists: pgsql-general
That was it. (not having it turned on.  duh).
Guess I should have read  section 23.2 of the docs..."The Statistics 
Collector"
Thanks for the heads up.

Jeff


Tom Lane wrote:

>Jeff Amiel <jamiel(at)istreamimaging(dot)com> writes:
>  
>
>>however, if I checked pg_stat_activity during the same time period, I 
>>saw nothing populated in the current_query column...ever.
>>    
>>
>
>Did you have it turned on?  (stats_command_string config parameter)
>
>Were you checking as superuser?
>
>			regards, tom lane
>
>
>  
>


In response to

Responses

pgsql-general by date

Next:From: Mário GamitoDate: 2004-08-24 17:08:26
Subject: SELECT to an external file
Previous:From: Tom LaneDate: 2004-08-24 16:55:53
Subject: Re: WG: Re: Re: select ... where <column>='' does a seqscan [auf Viren geprueft]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group