Re: Problems monitoring DB activity

From: Doug Y <dylists(at)ptd(dot)net>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problems monitoring DB activity
Date: 2004-10-08 14:46:56
Message-ID: 4166A860.4080607@ptd.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Fuhr 2004-10-08 15:14:42 Re: Problems monitoring DB activity
Previous Message Michael Fuhr 2004-10-08 14:11:29 Re: Problems monitoring DB activity