Seeing execution plan of foreign key constraint check?

From: Robert Klemme <shortcutter(at)googlemail(dot)com>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Seeing execution plan of foreign key constraint check?
Date: 2016-07-05 12:14:39
Message-ID: CAM9pMnPs3Jtw9nT7m9E7eH2E3xiExSR6mjmFQrZzoL__hwWxQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)mRNc5JcYXj%40moltowork#3798971(dot)mRNc5JcYXj(at)moltowork

Kind regards

robert

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kaixi Luo 2016-07-05 14:50:46 Tuning guidelines for server with 256GB of RAM and SSDs?
Previous Message Torsten Zuehlsdorff 2016-07-05 11:39:40 Re: less than 2 sec for response - possible?