auto_explain.log_min_duration is limit for nested statement

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: turon(dot)david(at)seznam(dot)cz
Subject: auto_explain.log_min_duration is limit for nested statement
Date: 2019-11-04 07:11:48
Message-ID: 157285150885.14272.17400824163768264403@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/auto-explain.html
Description:

Hello,

I had problem with setup auto_explain.log_min_duration for COPY command on
table with triggers. I set minimum duration to '2s' but no plan logged
(duration of COPY command was above this limit). I thought that this
extension not working with COPY command. After some testing I investigate
that extension is working becouse duration limit is for nested statement
(query in trigger) not for base statement (COPY) - it will be fine write
somewere in documentation.

Thanks

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2019-11-05 02:52:34 Re: wal_sender_timeout / wal_receiver_timeout - seconds or milliseconds?
Previous Message Nikolay Samokhvalov 2019-11-03 23:35:51 Re: effective_cache_size