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

From Robert Klemme
Subject Seeing execution plan of foreign key constraint check?
Date
Msg-id CAM9pMnPs3Jtw9nT7m9E7eH2E3xiExSR6mjmFQrZzoL__hwWxQQ@mail.gmail.com
Whole thread Raw
Responses Re: Seeing execution plan of foreign key constraint check?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-performance
Hi,

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

Kind regards

robert

--
[guy, jim, charlie].each {|him| remember.him do |as, often| as.you_can
- without end}
http://blog.rubybestpractices.com/


pgsql-performance by date:

Previous
From: Torsten Zuehlsdorff
Date:
Subject: Re: less than 2 sec for response - possible?
Next
From: Kaixi Luo
Date:
Subject: Tuning guidelines for server with 256GB of RAM and SSDs?