EXPLAIN and FK references?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: EXPLAIN and FK references?
Date: 2023-01-12 05:42:04
Message-ID: 269a6794-aa20-283d-bbc4-8cddaa2038de@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pg 12.11

Deletes are slow in one table with many indices and FK references. That's
not surprising, but it's *VERY* slow, and I'm trying to figure out why.

Is there any EXPLAIN option which shows what "query plans" Pg is using when
checking FK references (index scan, seq scan, etc) during deletes (and
inserts and updates)?

--
Born in Arizona, moved to Babylonia.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-01-12 06:07:26 Re: EXPLAIN and FK references?
Previous Message Ron 2023-01-12 05:25:55 Re: Changing displayed time zone in RAISE NOTICE output?