Re: Troubleshooting a long running delete statement

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Troubleshooting a long running delete statement
Дата
Msg-id c73a8eb00330ce5aa0d35e36d99e73fa5f1b6fc9.camel@cybertec.at
обсуждение исходный текст
Ответ на Troubleshooting a long running delete statement  ("Dirschel, Steve" <steve.dirschel@thomsonreuters.com>)
Список pgsql-performance
Дерево обсуждения 
On Wed, 2021-10-06 at 18:00 +0000, Dirschel, Steve wrote:
> Are there other statistics in Postgres I may have looked at to methodically come to the conclusion that the problem
wasthe missing index on the parent FK column?
 

You could use the query from my article to find the missing indexes:
https://www.cybertec-postgresql.com/en/index-your-foreign-key/

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Troubleshooting a long running delete statement
Следующее
От: "Dirschel, Steve"
Дата:
Сообщение: RE: [EXT] Re: Troubleshooting a long running delete statement