Re: Query Performance / Planner estimate off

On 10/20/20 3:22 PM, Victor Yegorov wrote:
> вт, 20 окт. 2020 г. в 11:38, Mats Julian Olsen <mats(at)duneanalytics(dot)com
> <mailto:mats(at)duneanalytics(dot)com>>:
>
> I'm looking for some help to manage queries against two large tables.
>
>
> Also, can you enable `track_io_timing` (no restart required) and
> provide output of `EXPLAIN (analyze, buffers, settings)` for all 3
> variants, please?
> (I assume you're on 12+.)

Thanks! Yes on 12.2. Here's the output:

vanilla: https://explain.depesz.com/s/Ktrd

set enable_nestloop=off: https://explain.depesz.com/s/mvSD

set enable_nestloop=off; set enable_seqscan=off:
https://explain.depesz.com/s/XIDo

Are these helpful?

>
> --
> Victor Yegorov