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.