> 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 ms
> duration: 0.150 ms
> duration: 0.440 ms
> duration: 0.338 ms
> duration: 0.156 ms
> tion: 0.396 ms
> duration: 0.221 ms
> duration: 0.161 ms
> *************
>The above would not happen to be autovacuum statements?
>
> 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 ms
> duration: 0.150 ms
> duration: 0.440 ms
> duration: 0.338 ms
> duration: 0.156 ms
> tion: 0.396 ms
> duration: 0.221 ms
> duration: 0.161 ms
> *************
>The above would not happen to be autovacuum statements?
Nope, those are not autovaccum related logs , they are related to queries only.
You have log_autovacuum_min_duration = 0 below.
You have log_autovacuum_min_duration = 0 below.
On Thu, 24 Jan 2019 at 20:53, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
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
> duration: 0.451 ms
> duration: 0.136 ms
> duration: 0.340 ms
> duration: 0.150 ms
> duration: 0.440 ms
> duration: 0.338 ms
> duration: 0.156 ms
> tion: 0.396 ms
> duration: 0.221 ms
> duration: 0.161 ms
> *************
The above would not happen to be autovacuum statements?
You have log_autovacuum_min_duration = 0 below.
> these are my logsettings
>
> name | setting
> ---------------------------------+---------------------------------------------------
> log_autovacuum_min_duration | 0
> log_checkpoints | on
> log_connections | on
> log_destination | syslog
> log_directory | log
> log_disconnections | on
> log_duration | off
> log_error_verbosity | default
> log_executor_stats | off
> log_file_mode | 0600
> log_filename | postgresql-%Y-%m-%d_%H%M%S.log
> log_hostname | off
> log_line_prefix |
> appname=%a,user=%u,db=%d,pid=%p,txid=%x,vtxid=%v
> log_lock_waits | on
> log_min_duration_statement | 1000
> log_min_error_statement | error
> log_min_messages | error
> log_parser_stats | off
> log_planner_stats | off
> log_replication_commands | off
> log_rotation_age | 1440
> log_rotation_size | 10240
> log_statement | all
> log_statement_stats | off
> log_temp_files | 0
> log_timezone | Navajo
> log_truncate_on_rotation | off
> logging_collector | on
> max_logical_replication_workers | 4
> syslog_facility | local4
> syslog_ident | postgres
> syslog_sequence_numbers | on
> syslog_split_messages | on
> wal_log_hints | off
>
> Regards,
> Bhargav K
>
>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
