Postgres Pro
Downloads
Home   >   mailing lists

Re: [EXT] Re: Troubleshooting a long running delete statement - Mailing list pgsql-performance

From Mladen Gogala
Subject Re: [EXT] Re: Troubleshooting a long running delete statement
Date
Msg-id 0ac28d5c-43f4-0766-cd65-d6b1583ef7fa@gmail.com
Whole thread Raw
In response to RE: [EXT] Re: Troubleshooting a long running delete statement  ("Dirschel, Steve" <steve.dirschel@thomsonreuters.com>)
List pgsql-performance
Tree view


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

pgsql-performance by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: [EXT] Re: Troubleshooting a long running delete statement
Next
From: Michael Lewis
Date:
Subject: Re: Troubleshooting a long running delete statement