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 <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
