Ron <ronljohnso...@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
