Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> 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 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. Note that log_statements alone isn't much help. You'll want to add at least %p to log_line_prefix so that you can relate entries in the log to currently active transactions. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
