On 10/20/20 3:22 PM, Victor Yegorov wrote:
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?