Re: EXPLAIN and FK references?

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: EXPLAIN and FK references?
Дата
Msg-id B82BDD68-899B-4BB6-BD9F-43DEBF09BAE6@thebuild.com
обсуждение исходный текст
Ответ на Re: EXPLAIN and FK references?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: EXPLAIN and FK references?  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-general

> On Jan 11, 2023, at 22:07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> No, not directly, but you could look at EXPLAIN ANALYZE to see which
> of the RI triggers is eating the time.  It's not going to be hard to
> figure out which one(s) are using indexed plans and which are not.

Also, IIRC, the SELECTs generated to do foreign key checks do appear in pg_stat_statements, so that might provide a
guideto ones that are consuming an unusually large amount of resources. 


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: EXPLAIN and FK references?
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: EXPLAIN and FK references?