Re: Problems monitoring DB activity - Mailing list pgsql-admin

From Doug Y
Subject Re: Problems monitoring DB activity
Date
Msg-id 4166A860.4080607@ptd.net
Whole thread Raw
In response to Re: Problems monitoring DB activity  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Problems monitoring DB activity
List pgsql-admin
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?

pgsql-admin by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Problems monitoring DB activity
Next
From: Michael Fuhr
Date:
Subject: Re: Problems monitoring DB activity