Re: log_statement vs log_min_duration_statement - Mailing list pgsql-general

From Maciek Sakrejda
Subject Re: log_statement vs log_min_duration_statement
Date
Msg-id CAOtHd0AnQPeQAdJ0WSv3D2evcsGCEd8WtyeUf+OKrn-AzDepBQ@mail.gmail.com
Whole thread Raw
In response to log_statement vs log_min_duration_statement  (Atul Kumar <akumar14871@gmail.com>)
List 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 by date:

Previous
From: Philip Carlsen
Date:
Subject: valid casts to anyarray
Next
From: Adrian Klaver
Date:
Subject: Re: Ad hoc SETOF type definition?