Re: log_statement vs log_min_duration_statement

Поиск
Список
Период
Сортировка
От Maciek Sakrejda
Тема Re: log_statement vs log_min_duration_statement
Дата
Msg-id CAOtHd0AnQPeQAdJ0WSv3D2evcsGCEd8WtyeUf+OKrn-AzDepBQ@mail.gmail.com
обсуждение исходный текст
Ответ на log_statement vs log_min_duration_statement  (Atul Kumar <akumar14871@gmail.com>)
Список pgsql-general
On Tue, Sep 26, 2023, 12:34 Atul Kumar <akumar14871@gmail.com> wrote:
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.

The two settings are independent. One logs *all* statements in the specified category, and the other *all* statements that execute longer than the specified threshold. I don't believe there is a built-in way of getting the behavior you're looking for.

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

Предыдущее
От: Philip Carlsen
Дата:
Сообщение: valid casts to anyarray
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Ad hoc SETOF type definition?