Postgres Pro
Downloads
Home   >   mailing lists

EXPLAIN and FK references? - Mailing list pgsql-general

From Ron
Subject EXPLAIN and FK references?
Date
Msg-id 269a6794-aa20-283d-bbc4-8cddaa2038de@gmail.com
Whole thread Raw
Responses Re: EXPLAIN and FK references?
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Changing displayed time zone in RAISE NOTICE output?
Next
From: Tom Lane
Date:
Subject: Re: EXPLAIN and FK references?