[GENERAL] Question about pg_stat_activity
Hi, When I run the following on my server: SELECT * FROM pg_stat_activity I get back command string not enabled for the field current_query. I have stats enabled in my config file, is there some other setting that I missed so I can see the current query? I also thought that in 7.x it would say idle if the connection was just sitting there. Thanks, Tony ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] Question about pg_stat_activity
On Wed, Jan 12, 2005 at 11:57:18PM -0600, Tony Caduto wrote: When I run the following on my server: SELECT * FROM pg_stat_activity I get back command string not enabled for the field current_query. I have stats enabled in my config file, is there some other setting that I missed so I can see the current query? Is stats_command_string set to true? Did you restart the backend after changing postgresql.conf? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] Question about pg_stat_activity
Hi, I have it working now, I must have missed the stats_command_string setting in the conf file. Thanks, Tony Michael Fuhr wrote: On Wed, Jan 12, 2005 at 11:57:18PM -0600, Tony Caduto wrote: When I run the following on my server: SELECT * FROM pg_stat_activity I get back command string not enabled for the field current_query. I have stats enabled in my config file, is there some other setting that I missed so I can see the current query? Is stats_command_string set to true? Did you restart the backend after changing postgresql.conf? ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings