Re: [EXT] Re: Troubleshooting a long running delete statement

From: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: [EXT] Re: Troubleshooting a long running delete statement
Date: 2021-10-07 01:30:59
Message-ID: 0ac28d5c-43f4-0766-cd65-d6b1583ef7fa@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Lewis 2021-10-07 04:44:17 Re: Troubleshooting a long running delete statement
Previous Message Mladen Gogala 2021-10-07 01:25:55 Re: [EXT] Re: Troubleshooting a long running delete statement