daveg <daveg(at)sonic(dot)net> wrote:
> On Thu, Jun 04, 2009 at 10:22:41PM -0400, Robert Haas wrote:
>> maybe make a separate column called "idle" that's a boolean,
>> or something, and let the query column contain the most recent
>> query (whether or not it's still executing).
> I like this idea a lot. Possibly it would be useful to have the end
> time of the last query too, then one could find idle sessions that
> were old and truly idle rather than just waiting for a busy client
> to send the next query.
> select ... from pg_stat_activity
> where idle
> and last_statement_endtime < now() - interval '1 minute';
Of course, you might be more interested in those which are idle in a
transaction, but that's easily done with these changes -- just throw
in xact_start IS NULL.
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2009-07-24 14:58:15|
|Subject: Re: display previous query string of idle-in-transaction|
|Previous:||From: Andrew Dunstan||Date: 2009-07-24 14:27:54|
|Subject: Re: join regression failure on cygwin|