Re: idea: log_statement_sample_rate - bottom limit for sampling - Mailing list pgsql-hackers

From Gilles Darold
Subject Re: idea: log_statement_sample_rate - bottom limit for sampling
Date
Msg-id 98149a08-4aa9-466d-672b-62a378715efb@darold.net
Whole thread Raw
In response to idea: log_statement_sample_rate - bottom limit for sampling  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: idea: log_statement_sample_rate - bottom limit for sampling
List pgsql-hackers
Le 06/06/2019 à 10:38, Pavel Stehule a écrit :
> Hi
>
> I like the idea of sampling slow statements via 
> log_statement_sample_rate. But I miss some parameter that can ensure
> so every query executed over this limit is logged.
>
> Can we introduce new option
>
> log_statement_sampling_limit
>
> The query with execution time over this limit is logged every time.
>
> What do you think about this?
>
> Regards
>
> Pavel


+1, log_min_duration_statement is modulated by log_statement_sample_rate
that mean that there is no more way to log all statements over a certain
duration limit. log_statement_sampling_limit might probably always be
upper than log_min_duration_statement.


-- 
Gilles Darold
http://www.darold.net/




pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: idea: log_statement_sample_rate - bottom limit for sampling
Next
From: Etsuro Fujita
Date:
Subject: Re: postgres_fdw: oddity in costing presorted foreign scans withlocal stats