From: | Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com> |
---|---|
To: | Yambu <hyambu(at)gmail(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Explain out put |
Date: | 2021-07-20 19:31:01 |
Message-ID: | CAM+6J94YJvBGquRJkTX53j8=mZKkS8jjSv=wUXj1_tGS1nKZwg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wed, 21 Jul 2021 at 00:16, Yambu <hyambu(at)gmail(dot)com> wrote:
> Hello
>
> I suspect that the partial index is not correct.
>
> It should include both column play_positionand elapsed. may you please
> help me figure out what's wrong here
>
> https://explain.depesz.com/s/tfho
>
I am not great at query tuning, but the estimates for playback_telemetry_2021_*
partitions in bitmap scans look way off.
Can you run a *vacuum (verbose,analyze) **playback_telemetry* and check if
the new plan is any better?
--
Thanks,
Vijay
Mumbai, India
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2021-07-20 19:39:13 | Re: Explain out put |
Previous Message | Bruce Momjian | 2021-07-20 19:09:54 | Re: Explain out put |