Re: EXPLAIN and FK references?

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Christophe Pettus <xof(at)thebuild(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: EXPLAIN and FK references?
Date: 2023-01-12 06:42:59
Message-ID: 20230112064259.4rrky3x54o72cefa@jrouhaud
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-01-12 07:03:10 Re: EXPLAIN and FK references?
Previous Message Christophe Pettus 2023-01-12 06:13:11 Re: EXPLAIN and FK references?