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
