Re: Slow query and wrong row estimates for CTE

From: Dane Foster <studdugie(at)gmail(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: psql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow query and wrong row estimates for CTE
Date: 2021-02-16 15:19:26
Message-ID: CA+WxinKr8-xyHQ_bwbk3N5GRj-ayeFdoba=gOAiU-EX2YU9B+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Feb 15, 2021 at 5:32 PM Justin Pryzby <pryzby(at)telsasoft(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Dane Foster 2021-02-16 15:25:09 Re: Slow query and wrong row estimates for CTE
Previous Message Michael Lewis 2021-02-16 15:12:55 Re: Slow query and wrong row estimates for CTE