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

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

pgsql-admin by date:

Previous
From: Doug Y
Date:
Subject: Problems monitoring DB activity
Next
From: Doug Y
Date:
Subject: Re: Problems monitoring DB activity