Re: Incomplete Explain for delete

From: David Gould <daveg(at)sonic(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Incomplete Explain for delete
Date: 2015-06-22 22:32:56
Message-ID: 20150622153256.4ba1c6ce@engels
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, 22 Jun 2015 12:41:28 -0400
"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> ​Except that the query inside the trigger is known to system - the fact it
> is wrapped in a trigger is an implementation detail that could, in theory,
> be bypassed in order to facilitate a more meaningful explain output.

Unless triggers are prohibited from using dynamic sql, the query really
cannot be known to the system.

-dg

--
David Gould 510 282 0869 daveg(at)sonic(dot)net
If simplicity worked, the world would be overrun with insects.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-06-22 23:08:28 Re: BUG #13462: Impossible to use COPY FORMAT BINARY in chunks through libpq
Previous Message Tom Lane 2015-06-22 22:25:03 Re: BUG #13459: Replaying WAL logs can hang on startup