Alexander Staubo <alex@xxxxxxxxxxxxxxx> writes: > See below. Seems 18204 is waiting for a process that is "idle in > transaction"; makes me wish that PostgreSQL could export more > information about the age of in-progress transactions. I am turning > on logging so I can determine what a future hanging process is doing. Yeah, it looks like PIDs 18202 and 18207 are the bottlenecks, and they are not waiting on locks. regards, tom lane
