Postgres Pro
Downloads
Home   >   mailing lists

Re: Explain out put - Mailing list pgsql-admin

From Vijaykumar Jain
Subject Re: Explain out put
Date
Msg-id CAM+6J94YJvBGquRJkTX53j8=mZKkS8jjSv=wUXj1_tGS1nKZwg@mail.gmail.com
Whole thread Raw
In response to Explain out put  (Yambu <hyambu@gmail.com>)
List pgsql-admin
Tree view
On Wed, 21 Jul 2021 at 00:16, Yambu <hyambu@gmail.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


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

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Explain out put
Next
From: "David G. Johnston"
Date:
Subject: Re: Explain out put