statements of an unfinished transaction
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 ?
TIA,
Sabin
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/
Show quoted text
From each according to his ability. To each according to his ability to litigate.