Re: pg_stat_activity versus ps - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_stat_activity versus ps
Date
Msg-id 4964.1093365824@sss.pgh.pa.us
Whole thread Raw
In response to pg_stat_activity versus ps  (Jeff Amiel <jamiel@istreamimaging.com>)
Responses Re: pg_stat_activity versus ps  (Jeff Amiel <jamiel@istreamimaging.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Eduardo S. Fontanetti"
Date:
Subject: Re: Dump and Restore
Next
From: Tom Lane
Date:
Subject: Re: select ... where ='' does a seqscan [auf Viren