Re: Log a sample of transactions

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

To: Adrien Nayrat <adrien.nayrat@anayrat.info>, PostgreSQL mailing lists <pgsql-hackers@postgresql.org>

Cc: Nikolay Samokhvalov <samokhvalov@gmail.com>

Date: 2019-01-04T12:20:09Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Tweak docs for log_statement_sample_rate
- d1f04b96b99d 12.0 landed

On 12/12/2018 22:32, Adrien Nayrat wrote:
> Per idea of Nikolay Samokhvalov[1] I propose this patch to add the possibility
> to log all statements from a fraction of transactions.
> 
> I have several questions:
>   * Do we want this feature?

It's not clear to me what the use is.  The per-statement sampling allows
you to capture slow queries without overwhelming the logs.  We don't
have any logging of slow transactions or any other transaction scope
logging, so what will this sample?

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