Postgres Pro
Downloads
Home   >   mailing lists

statements of an unfinished transaction - Mailing list pgsql-general

From Sabin Coanda
Subject statements of an unfinished transaction
Date
Msg-id fcobbn$15eh$1@news.hub.org
Whole thread Raw
Responses Re: statements of an unfinished transaction
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Geoffrey
Date:
Subject: Re: Recall: August Monthly techdata split fi
Next
From: Martijn van Oosterhout
Date:
Subject: Re: statements of an unfinished transaction