Ron <ronljohnsonjr@xxxxxxxxx> 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
