Re: Problems monitoring DB activity

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Doug Y 2004-10-08 14:46:56 Re: Problems monitoring DB activity
Previous Message Doug Y 2004-10-08 13:54:08 Problems monitoring DB activity