Alexander Staubo <alex@purefiction.net> 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