how can i bugfix "idle in transaction" lockups ? - Mailing list pgsql-general

From Jonathan Vanasco
Subject how can i bugfix "idle in transaction" lockups ?
Date
Msg-id 58CCACB8-A38A-4434-8865-EF19FDCBDEE3@2xlp.com
Whole thread Raw
Responses Re: how can i bugfix "idle in transaction" lockups ?
Re: how can i bugfix "idle in transaction" lockups ?
Re: how can i bugfix "idle in transaction" lockups ?
List pgsql-general
on a project, i find myself continually finding the database locked up with "idle in transaction" connections

are there any commands that will allow me to check exactly what was going on in that transaction ?

i couldn't find anything in the docs, and the project has decent traffic, so its going to be an issue to log all
statementsso I can sift through the data by PID 


pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: advise on performance issues please
Next
From: Ben Chobot
Date:
Subject: Re: how can i bugfix "idle in transaction" lockups ?