Re: Log a sample of transactions

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Log a sample of transactions
Дата
Msg-id 8d7efd46-fdc6-06a8-b98b-ef0543047583@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Log a sample of transactions  (Adrien NAYRAT <adrien.nayrat@anayrat.info>)
Ответы Re: Log a sample of transactions  (Adrien NAYRAT <adrien.nayrat@anayrat.info>)
Список pgsql-hackers
On 15/01/2019 18:03, Adrien NAYRAT wrote:
> The goal is not to find slow queries in a transaction, but troubleshoot 
> applicative issue when you have short queries.
> 
> Sometimes you want to understand what happens in a transaction, either 
> you perfectly know your application, either you have to log all queries 
> and find ones with the same transaction ID (%x). It could be problematic 
> if you have a huge traffic with fast queries.

But if you have trouble with a specific transaction, how will a setting
help that randomly logs transactions, not necessarily the one you are
concerned about?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: proposal - plpgsql unique statement id
Следующее
От: "Iwata, Aya"
Дата:
Сообщение: RE: libpq debug log