Re: EXPLAIN and FK references?
От
Julien Rouhaud
Тема
Re: EXPLAIN and FK references?
Дата
Msg-id
20230112064259.4rrky3x54o72cefa@jrouhaud
Ответ на
Re: EXPLAIN and FK references? (Christophe Pettus)
Список
Дерево обсуждения
EXPLAIN and FK references? Ron <ronljohnsonjr@gmail.com>
Re: EXPLAIN and FK references? Tom Lane <tgl@sss.pgh.pa.us>
Re: EXPLAIN and FK references? Ron <ronljohnsonjr@gmail.com>
Re: EXPLAIN and FK references? Tom Lane <tgl@sss.pgh.pa.us>
Re: EXPLAIN and FK references? Ron <ronljohnsonjr@gmail.com>
Re: EXPLAIN and FK references? Julien Rouhaud <rjuju123@gmail.com>
Re: EXPLAIN and FK references? Christophe Pettus <xof@thebuild.com>
Re: EXPLAIN and FK references? Julien Rouhaud <rjuju123@gmail.com>
On Wed, Jan 11, 2023 at 10:13:11PM -0800, Christophe Pettus wrote: > > Also, IIRC, the SELECTs generated to do foreign key checks do appear in > pg_stat_statements, so that might provide a guide to ones that are consuming > an unusually large amount of resources. Yes, but you need to have pg_stat_statements.track = all configured for that, which isn't the default value (and requires superuser privileges to change).
В списке pgsql-general по дате отправления
