Re: Explain out put

[Vijaykumar Jain <vijaykumarjain.github@xxxxxxxxx>]

On Wed, 21 Jul 2021 at 00:16, Yambu <hyambu@xxxxxxxxx> 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