Postgres Pro
Downloads
Home   >   mailing lists

Re: statements of an unfinished transaction - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: statements of an unfinished transaction
Date
Msg-id 20070918111252.GA9046@svana.org
Whole thread Raw
In response to statements of an unfinished transaction  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List pgsql-general
Tree view 
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@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
Attachment

pgsql-general by date:

Previous
From: "Sabin Coanda"
Date:
Subject: statements of an unfinished transaction
Next
From: "Phoenix Kiula"
Date:
Subject: Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER