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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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