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

From Jim Nasby
Subject Re: Seeing execution plan of foreign key constraint check?
Date
Msg-id 4b2f737a-ea37-35cd-012b-307ee1c9a584@BlueTreble.com
Whole thread Raw
In response to Seeing execution plan of foreign key constraint check?  (Robert Klemme <shortcutter@googlemail.com>)
Responses Re: Seeing execution plan of foreign key constraint check?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
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?
>
> When researching I found this thread from 2011 and the output format
> does not seem to have changed since then:
>
> https://www.postgresql.org/message-id/flat/3798971.mRNc5JcYXj%40moltowork#3798971.mRNc5JcYXj@moltowork

No one has discussed it recently.

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. The
best bet for getting this done is to decide you want to work on it
yourself and email -hackers (please email before creating the patch!),
pay one of the consulting companies to do it, or create a bounty and see
if others will chip in to pay someone to do it.
--
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


pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: less than 2 sec for response - possible?
Next
From: Jim Nasby
Date:
Subject: Re: Random slow queries