Re: pg_stat_activity versus ps

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@istreamimaging.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
>
>
>
>