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

Ron <ronljohnsonjr@gmail.com> writes:
> On 1/12/23 00:07, Tom Lane wrote:
>> No, not directly, but you could look at EXPLAIN ANALYZE to see which
>> of the RI triggers is eating the time.

> Good to know, but even deleting one day of data (90,000 rows using an index 
> scan on the date field) takes forever.

So delete a relatively small number of rows, and do it with
EXPLAIN *ANALYZE*.  Without ANALYZE, you aren't getting any
relevant data.

            regards, tom lane