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&quo
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 "1
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. O
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
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
run as a superuser?:
select * from pg_settings where name= 'log_min_duration_statement';
More info:
https://www.postgresql.org/docs/11/view-pg-settings.html
--
Adrian Klaver
adrian.kla...@aklaver.com
> 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
> du
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
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 ms
duration: 0.340
