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

Поиск
Список
Период
Сортировка
От Maciek Sakrejda
Тема Re: [EXT] Re: Troubleshooting a long running delete statement
Дата
Msg-id CAOtHd0AF2eDCf8PmEOa=FE+w5=hxpw2uOf4ZdjH5JxU6q6X4CA@mail.gmail.com
обсуждение исходный текст
Ответ на RE: [EXT] Re: Troubleshooting a long running delete statement  ("Dirschel, Steve" <steve.dirschel@thomsonreuters.com>)
Ответы Re: [EXT] Re: Troubleshooting a long running delete statement  (Corey Huinker <corey.huinker@gmail.com>)
Список pgsql-performance
Дерево обсуждения
On Wed, Oct 6, 2021 at 1:32 PM Dirschel, Steve <steve.dirschel@thomsonreuters.com> wrote:
Thanks for the reply and the info above.  My question was more directed at how can you troubleshoot the active session running the query.  In the examples above you are actually executing the query.  If an application is executing the query I can't go in an re-execute it. 

This won't be immediately useful, but there's been a patch proposed for Postgres 15 to allow logging the plan of a running query [1]. Progress seems to have stalled a bit, but it seems like there was a fair amount of interest, so I wouldn't count it out yet. If you have thoughts on the proposed functionality, I'm sure thoughtful feedback would be appreciated.

Thanks,
Maciek

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

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