Re: display previous query string of idle-in-transaction - Mailing list pgsql-hackers

From Guillaume Smet
Subject Re: display previous query string of idle-in-transaction
Date
Msg-id 1d4e0c10903251007v500e762bqd3514a0c440b928c@mail.gmail.com
Whole thread Raw
In response to Re: display previous query string of idle-in-transaction  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: display previous query string of idle-in-transaction
List pgsql-hackers
On Wed, Mar 25, 2009 at 5:48 PM, hubert depesz lubaczewski
<depesz@depesz.com> wrote:
> I would love to get it, but when I suggested it some time in the past
> Tom shot it down as bad idea.
>
> http://archives.postgresql.org/message-id/20071016132131.GA4438@depesz.com

I agree with Tom here. I tracked a lot of idle in transaction problems
and you need the whole sequence of queries of all the backends to
really understand what happens.
The last query executed is mostly useless to solve this sort of
problem. At least, it was for me in every case I had to deal with.

-- 
Guillaume


pgsql-hackers by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: improving concurrent transactin commit rate
Next
From: Andrew Dunstan
Date:
Subject: Re: cached plan issue in trigger func