On Fri, Oct 08, 2004 at 09:54:08AM -0400, Doug Y wrote: > > SELECT * FROM pg_catalog.pg_stat_activity; > > The current_query and query_start columns are always empty. Obviously > this makes it hard to monitor problems with the various admin tools, etc.
Does postgresql.conf have stats_command_string = true? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
