I have an Idle in transaction that's really long. I suspect there is a
problem in my application, but I can't figure out where. If I new which
queries that transaction did in the past, it would really help me find the
problem. I know the transaction id, the process id, everything there is to
know,
I see that every once in a while I get an Idle in Transaction that never
ends. This eventually becames a problem, as this Idle in Transaction holds
AccessShareLocks. Even if it didn't, if I reach the maximum number of
transactions my application dies. Is there any way to know what the
transaction
