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: (view raw or whole 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 
Thanks for the heads up.


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


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-2015 The PostgreSQL Global Development Group