Postgres Pro
Downloads
Home   >   mailing lists

Re: Way to tell what SQL is currently running? - Mailing list pgsql-novice

From Stephan Szabo
Subject Re: Way to tell what SQL is currently running?
Date
Msg-id 20030825104721.I93434-100000@megazone.bigpanda.com
Whole thread Raw
In response to Re: Way to tell what SQL is currently running?  ("Patrick Hatcher" <PHatcher@macys.com>)
Responses Using RECORD returning functions with JDBC
List pgsql-novice
Tree view 
On Mon, 25 Aug 2003, Patrick Hatcher wrote:

> Pg_stat_activity only shows the User, PID, etc, but the Query string field
> just shows empty text

You need to turn on an option IIRC to get the query string field to be
populated (because it's extra overhead) so I don't think that'll help for
a currently running situation.  Do you have any of the query logging
options turned on?

pgsql-novice by date:

Previous
From: "Patrick Hatcher"
Date:
Subject: Re: Way to tell what SQL is currently running?
Next
From: Stephan Szabo
Date:
Subject: Re: Returning SETOF RECORD