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
