Re: EXPLAIN and FK references? - Mailing list pgsql-general

From Christophe Pettus
Subject Re: EXPLAIN and FK references?
Date
Msg-id B82BDD68-899B-4BB6-BD9F-43DEBF09BAE6@thebuild.com
Whole thread Raw
In response to Re: EXPLAIN and FK references?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: EXPLAIN and FK references?
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: EXPLAIN and FK references?
Next
From: Julien Rouhaud
Date:
Subject: Re: EXPLAIN and FK references?