Question about pg_stat_activity - Mailing list pgsql-general

From Tony Caduto
Subject Question about pg_stat_activity
Date
Msg-id 41E60DBE.1030008@amsoftwaredesign.com
Whole thread Raw
Responses Re: Question about pg_stat_activity  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Hi,
When I run the following on my server:
SELECT * FROM pg_stat_activity

I get back <command string not enabled> for the field current_query.

I have stats enabled in my config file, is there some other setting that
I missed so I can see the current query?

I also thought that in 7.x it would say idle if the connection was just
sitting there.

Thanks,

Tony


pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: pgEdit 1.0b6
Next
From: Tony Caduto
Date:
Subject: Working on a new Postgres Admin tool and was wondering...