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

Поиск
Список
Период
Сортировка
От Mladen Gogala
Тема Re: [EXT] Re: Troubleshooting a long running delete statement
Дата
Msg-id 0ac28d5c-43f4-0766-cd65-d6b1583ef7fa@gmail.com
обсуждение исходный текст
Ответ на RE: [EXT] Re: Troubleshooting a long running delete statement  ("Dirschel, Steve" <steve.dirschel@thomsonreuters.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Mladen Gogala
Дата:
Сообщение: Re: [EXT] Re: Troubleshooting a long running delete statement
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: Troubleshooting a long running delete statement