Re: Execution time from >1s -> 80m+ when extra columns added inSELECT for sub-query

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Execution time from >1s -> 80m+ when extra columns added inSELECT for sub-query
Дата
Msg-id CAFj8pRCEXjXoxDVXAqNE2qqkEHWM+=ZWHg9qo=soJf0vbK9Y3w@mail.gmail.com
обсуждение исходный текст
Ответ на Execution time from >1s -> 80m+ when extra columns added in SELECTfor sub-query  (A Guy Named Ryan <aguynamedryan@gmail.com>)
Ответы Re: Execution time from >1s -> 80m+ when extra columns added inSELECT for sub-query  (A Guy Named Ryan <aguynamedryan@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Hi

It looks so in slow plan is some strange relations between subselects - the slow plan looks like plan for correlated subquery, and it should be slow.

Minimally you miss a index on column 
jtemp1c37l3b_baseline_windows_after_inclusion.uuid


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

Предыдущее
От: A Guy Named Ryan
Дата:
Сообщение: Execution time from >1s -> 80m+ when extra columns added in SELECTfor sub-query
Следующее
От: A Guy Named Ryan
Дата:
Сообщение: Re: Execution time from >1s -> 80m+ when extra columns added inSELECT for sub-query