Seeing execution plan of foreign key constraint check?

Поиск
Список
Период
Сортировка
От Robert Klemme
Тема Seeing execution plan of foreign key constraint check?
Дата
Msg-id CAM9pMnPs3Jtw9nT7m9E7eH2E3xiExSR6mjmFQrZzoL__hwWxQQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Seeing execution plan of foreign key constraint check?
Список 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 по дате отправления:

Предыдущее
От: Torsten Zuehlsdorff
Дата:
Сообщение: Re: less than 2 sec for response - possible?
Следующее
От: Kaixi Luo
Дата:
Сообщение: Tuning guidelines for server with 256GB of RAM and SSDs?