Problems monitoring DB activity

From: Doug Y <dylists(at)ptd(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problems monitoring DB activity
Date: 2004-10-08 13:54:08
Message-ID: 41669C00.2030209@ptd.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

When I do the following:

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.

I'm guessing there's a setting or something that needs updated, I just
need a point in the right direction. DB is 7.4.2

Thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Fuhr 2004-10-08 14:11:29 Re: Problems monitoring DB activity
Previous Message Michael Long 2004-10-08 05:39:51 Altering column type causes unstable server and data loss.