From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | turon(dot)david(at)seznam(dot)cz, pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: auto_explain.log_min_duration is limit for nested statement |
Date: | 2019-11-07 03:42:30 |
Message-ID: | 20191107034230.GC12478@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Mon, Nov 4, 2019 at 07:11:48AM +0000, PG Doc comments form wrote:
> 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.
COPY doesn't go through the optimizer, so there is nothing to explain,
e.g.,
test=> EXPLAIN COPY test FROM STDIN;
ERROR: syntax error at or near "COPY"
LINE 1: EXPLAIN COPY test FROM STDIN;
^
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
From | Date | Subject | |
---|---|---|---|
Next Message | Eugen Konkov | 2019-11-07 09:20:32 | Re: Does 'instead of delete' trigger support modification of OLD |
Previous Message | Michael Paquier | 2019-11-07 02:15:41 | Re: Small typo in func.sgml |