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, everything there is to > know, except the queries it did in the past. Is there any way to check this?
Turn on log_statements and check the log. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general