Re: Seeing execution plan of foreign key constraint check?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Seeing execution plan of foreign key constraint check?
Дата
Msg-id 11766.1468959038@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Seeing execution plan of foreign key constraint check?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Ответы Re: Seeing execution plan of foreign key constraint check?
Список pgsql-performance
Jim Nasby <Jim.Nasby@BlueTreble.com> 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.

            regards, tom lane


В списке pgsql-performance по дате отправления:

Предыдущее
От: trafdev
Дата:
Сообщение: Re: less than 2 sec for response - possible?
Следующее
От: Jim Nasby
Дата:
Сообщение: Poor choice of backward scan