Re: Log a sample of transactions - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Log a sample of transactions
Date
Msg-id 8d7efd46-fdc6-06a8-b98b-ef0543047583@2ndquadrant.com
Whole thread Raw
In response to Re: Log a sample of transactions  (Adrien NAYRAT <adrien.nayrat@anayrat.info>)
Responses Re: Log a sample of transactions  (Adrien NAYRAT <adrien.nayrat@anayrat.info>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: proposal - plpgsql unique statement id
Next
From: "Iwata, Aya"
Date:
Subject: RE: libpq debug log