Re: statements of an unfinished transaction

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: statements of an unfinished transaction
Date: 2007-09-18 11:12:52
Message-ID: 20070918111252.GA9046@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2007-09-18 12:15:22 Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
Previous Message Sabin Coanda 2007-09-18 11:04:32 statements of an unfinished transaction