| 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: | Whole Thread | Raw Message | 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 |