daveg <da...@sonic.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). +1 > 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'; +1 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. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
