Re: EXPLAIN and FK references?

[Christophe Pettus]

> On Jan 11, 2023, at 22:07, Tom Lane <t...@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 guide to ones that are consuming an 
unusually large amount of resources.