Re: [GENERAL] pg_stat_activity versus ps

2004-08-24 Thread Jeff Amiel
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 <[EMAIL PROTECTED]> writes: however, if I checked pg_stat_activity during the same time period, I saw nothing

Re: [GENERAL] pg_stat_activity versus ps

2004-08-24 Thread Tom Lane
Jeff Amiel <[EMAIL PROTECTED]> 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?