Re: [GENERAL] Check what a transaction did in the past

2010-02-16 Thread Tom Lane
Alvaro Herrera writes: > manugarciac wrote: >> 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 tran

Re: [GENERAL] Check what a transaction did in the past

2010-02-16 Thread Alvaro Herrera
manugarciac wrote: > > 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,