Re: Tips on troubleshooting slow DELETE (suspect cascades)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Tips on troubleshooting slow DELETE (suspect cascades)
Дата
Msg-id 2279939.1705597280@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Tips on troubleshooting slow DELETE (suspect cascades)  (Jim Vanns <jvanns@ilm.com>)
Список pgsql-general
Jim Vanns <jvanns@ilm.com> writes:
> I should have already stated I did begin with EXPLAIN but given they
> don't easily work with (the internals) stored/procedures, it wasn't
> useful in this case.

auto_explain with nested statements enabled might help?

            regards, tom lane



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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Tips on troubleshooting slow DELETE (suspect cascades)
Следующее
От: Jim Vanns
Дата:
Сообщение: Re: Tips on troubleshooting slow DELETE (suspect cascades)