Re: Seeing execution plan of foreign key constraint check? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Seeing execution plan of foreign key constraint check?
Date
Msg-id 11766.1468959038@sss.pgh.pa.us
Whole thread Raw
In response to Re: Seeing execution plan of foreign key constraint check?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Seeing execution plan of foreign key constraint check?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-performance
Jim Nasby <Jim.Nasby@BlueTreble.com> writes:
> On 7/5/16 7:14 AM, Robert Klemme wrote:
>> I was wondering whether there are any plans to include the plan of the
>> FK check in EXPLAIN output. Or is there a different way to get to see
>> all the plans of triggers as well as of the main SQL?

> Unfortunately, this isn't the type of thing that would excite most of
> the core hackers, so it's unlikely any of them will pick this up.

It's not so much that people don't care, as that it's not apparent how to
improve this without breaking desirable system properties --- in this
case, that functions are black boxes so far as callers are concerned.

            regards, tom lane


pgsql-performance by date:

Previous
From: trafdev
Date:
Subject: Re: less than 2 sec for response - possible?
Next
From: Jim Nasby
Date:
Subject: Poor choice of backward scan