Re: Slow query and wrong row estimates for CTE

Поиск
Список
Период
Сортировка
От Dane Foster
Тема Re: Slow query and wrong row estimates for CTE
Дата
Msg-id CA+WxinKr8-xyHQ_bwbk3N5GRj-ayeFdoba=gOAiU-EX2YU9B+w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slow query and wrong row estimates for CTE  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-performance
Дерево обсуждения
On Mon, Feb 15, 2021 at 5:32 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
...

Without looking closely, an index might help: student_id,assignment_id
That'd avoid the sort, and maybe change the shape of the whole plan.
I tried that prior to posting on the forum and it didn't make a difference. 🙁

I'll try your other suggestions later today or tomorrow. I will keep you posted.

--
Justin

Thanks,

Dane

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

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: Slow query and wrong row estimates for CTE
Следующее
От: Dane Foster
Дата:
Сообщение: Re: Slow query and wrong row estimates for CTE