Re: idea: log_statement_sample_rate - bottom limit for sampling

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: idea: log_statement_sample_rate - bottom limit for sampling
Дата
Msg-id CAFj8pRAVCaB601vRLOrjPc-MukiG1EdLuB2P4MUxqP-ZSFVjDg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: idea: log_statement_sample_rate - bottom limit for sampling  (Gilles Darold <gilles@darold.net>)
Ответы Re: idea: log_statement_sample_rate - bottom limit for sampling  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Hi

čt 6. 6. 2019 v 10:48 odesílatel Gilles Darold <gilles@darold.net> napsal:
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.

Here is a patch

Regards

Pavel



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

Вложения

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

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: SQL/JSON path issues/questions
Следующее
От: Chapman Flack
Дата:
Сообщение: Re: SQL/JSON path issues/questions