Re: Query Performance / Planner estimate off - Mailing list pgsql-performance

вт, 20 окт. 2020 г. в 11:38, Mats Julian Olsen <mats@duneanalytics.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