Re: display previous query string of idle-in-transaction

Поиск
Список
Период
Сортировка
От Guillaume Smet
Тема Re: display previous query string of idle-in-transaction
Дата
Msg-id 1d4e0c10903251007v500e762bqd3514a0c440b928c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: display previous query string of idle-in-transaction  (hubert depesz lubaczewski <depesz@depesz.com>)
Ответы Re: display previous query string of idle-in-transaction
Список 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 по дате отправления:

Предыдущее
От: Kenneth Marshall
Дата:
Сообщение: Re: improving concurrent transactin commit rate
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: cached plan issue in trigger func