On Tue, Sep 18, 2007 at 02:04:32PM +0300, Sabin Coanda wrote: > Hi there, > > I'd like to find the sessions that provide unclosed transactions (i.e. > marked as <IDLE> in transaction). > > Is any way to find the SQL statements that belong to such a transaction, or > the transaction time start, or any other helpful data ?
pg_stat_activity has that, surely... Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
