EXPLAIN and FK references?

Поиск
Список
Период
Сортировка
От Ron
Тема EXPLAIN and FK references?
Дата
Msg-id 269a6794-aa20-283d-bbc4-8cddaa2038de@gmail.com
обсуждение исходный текст
Ответы Re: EXPLAIN and FK references?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Pg 12.11

Deletes are slow in one table with many indices and FK references.  That's not surprising, but it's VERY slow, and I'm trying to figure out why.

Is there any EXPLAIN option which shows what "query plans" Pg is using when checking FK references (index scan, seq scan, etc) during deletes (and inserts and updates)?

--
Born in Arizona, moved to Babylonia.

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

Предыдущее
От: Ron
Дата:
Сообщение: Re: Changing displayed time zone in RAISE NOTICE output?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: EXPLAIN and FK references?