Re: log_statement vs log_min_duration_statement

2023-09-27 Thread Laurenz Albe
On Wed, 2023-09-27 at 00:01 +0530, Atul Kumar wrote: > 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,

Re: log_statement vs log_min_duration_statement

2023-09-26 Thread Jeff Janes
On Tue, Sep 26, 2023 at 5:33 PM Atul Kumar 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

Re: log_statement vs log_min_duration_statement

2023-09-26 Thread Maciek Sakrejda
On Tue, Sep 26, 2023, 12:34 Atul Kumar 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*

Re: log_statement vs log_min_duration_statement

2023-09-26 Thread Adrian Klaver
On 9/26/23 11:31 AM, Atul Kumar 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.

log_statement vs log_min_duration_statement

2023-09-26 Thread Atul Kumar
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