Michael Fuhr wrote:
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?
Thanks, setting that did the trick.... whats the performance hit for
having it enabled?
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
