log_statement vs log_min_duration_statement

Поиск
Список
Период
Сортировка
От Atul Kumar
Тема log_statement vs log_min_duration_statement
Дата
Msg-id CA+ONtZ7dOdN4hdqcgrNeVAe1U2BDGyYDA53aG2FydbM5s1qJ1g@mail.gmail.com
обсуждение исходный текст
Ответы Re: log_statement vs log_min_duration_statement  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: log_statement vs log_min_duration_statement  (Maciek Sakrejda <m.sakrejda@gmail.com>)
Re: log_statement vs log_min_duration_statement  (Jeff Janes <jeff.janes@gmail.com>)
Re: log_statement vs log_min_duration_statement  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Hi,

I have a query about parameters  and log_statement

my postgres version is 12 and running on centos 7

my log_statement is set to "DDL".

and log_min_duration_statement is set to "1ms"

so technically it should log "ONLY DDLs" that take more than 1ms.

but to my surprise, postgres is logging DML as well which is taking more than 1ms.

What am I missing here to understand, because as per my understanding log_statement and log_min_duration_statement are correlated, postgres should log according to log_statement parameter.

Please advise me on this behavior.



Regards,
Atul

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Ad hoc SETOF type definition?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: log_statement vs log_min_duration_statement