statements of an unfinished transaction

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: statements of an unfinished transaction
Date: 2007-09-18 11:04:32
Message-ID: fcobbn$15eh$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-09-18 11:12:52 Re: statements of an unfinished transaction
Previous Message Geoffrey 2007-09-18 11:02:08 Re: Recall: August Monthly techdata split fi