Re: idea: log_statement_sample_rate - bottom limit for sampling

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: idea: log_statement_sample_rate - bottom limit for sampling
Дата
Msg-id CAFj8pRAzzjmwpzzs0qg+9whUErt3-fbyy-n7gnK+-fP_Vxje9g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: idea: log_statement_sample_rate - bottom limit for sampling  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: idea: log_statement_sample_rate - bottom limit for sampling  (Adrien Nayrat <adrien.nayrat@anayrat.info>)
Список pgsql-hackers
Hi

po 17. 6. 2019 v 22:40 odesílatel Pavel Stehule <pavel.stehule@gmail.com> napsal:
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

I did error in logic - fixed



Regards

Pavel



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

Вложения

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

Предыдущее
От: Steve Singer
Дата:
Сообщение: Re: PG 12 beta 1 segfault during analyze
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PG 12 beta 1 segfault during analyze