Re: log_min_duration_statement

2019-01-24 Thread Adrian Klaver
On 1/24/19 7:52 AM, bhargav kamineni wrote: Hi Team,, >The above would not happen to be autovacuum statements? Nope, those are not autovaccum related logs , they are related to queries only. On the chance that this setting is being overridden somewhere what does the below show when run

Re: log_min_duration_statement

2019-01-24 Thread bhargav kamineni
> Hi Team,, > > I have set log_min_duration_statement=1000 as my configuration but when > i observe log file i could see queries that ran below 1000ms are also > getting logged , for instance > duration: 0.089 ms > duration: 0.175 ms > duration: 0.139 ms > duration: 0.451 ms > duration: 0.136

Re: log_min_duration_statement

2019-01-24 Thread Adrian Klaver
On 1/24/19 6:23 AM, bhargav kamineni wrote: Hi Team,, I have set log_min_duration_statement=1000 as my configuration but when i observe log file i could see queries that ran below 1000ms are also getting logged , for instance duration: 0.089 ms  duration: 0.175 ms  duration: 0.139 ms  dura