Re: log_statement vs log_min_duration_statement - Mailing list pgsql-general

From Jeff Janes
Subject Re: log_statement vs log_min_duration_statement
Date
Msg-id CAMkU=1xX6Gq_zBr3fjsceqqgKKf0UPLci4SKaqsUd=OFsddWNA@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 at 5:33 PM Atul Kumar <akumar14871@gmail.com> wrote:
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.

That doesn't surprise me, it is just what I expected.

 

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.

If something in the docs led you to this misunderstanding, we should identify it and fix it.  Otherwise, there isn't much we can do, except point out that that is simply not how it works.
 
Cheers,

Jeff

pgsql-general by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: Early binding of CURRENT_SCHEMA (Was: CREATE FUNCTION ... SEARCH {, DEFAULT | SYSTEM | SESSION })
Next
From: Ron
Date:
Subject: Re: Ad hoc SETOF type definition?