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

From Julien Rouhaud
Subject Re: EXPLAIN and FK references?
Date
Msg-id 20230112064259.4rrky3x54o72cefa@jrouhaud
Whole thread Raw
In response to Re: EXPLAIN and FK references?  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
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 by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: EXPLAIN and FK references?
Next
From: Ron
Date:
Subject: Re: EXPLAIN and FK references?