public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jim Nasby <[email protected]>
To: Tom Lane <[email protected]>
Cc: Robert Klemme <[email protected]>
Cc: pgsql-performance <[email protected]>
Subject: Re: Seeing execution plan of foreign key constraint check?
Date: Thu, 21 Jul 2016 16:42:04 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CAM9pMnPs3Jtw9nT7m9E7eH2E3xiExSR6mjmFQrZzoL__hwWxQQ@mail.gmail.com>
	<[email protected]>
	<[email protected]>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

On 7/19/16 3:10 PM, Tom Lane wrote:
> Jim Nasby <[email protected]> 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.

I thought we already broke out time spent in triggers as part of 
EXPLAIN, and that the FK "triggers" were specifically ignored? (Granted, 
that doesn't give you plan info, just timing...)

As for function plans, ISTM that could be added to the PL handlers if we 
wanted to (allow a function invocation to return an array of explain 
outputs).
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461


-- 
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Seeing execution plan of foreign key constraint check?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox