On 10/6/21 16:32, Dirschel, Steve wrote:
postgres=# explain (analyze) delete from t; Delete on t
I would try explain (analyze, timing, buffers). That would also give you the timing of each step so you can figure which one takes the longes.
Regards -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com
