Re: Query Performance / Planner estimate off

Mats Olsen <mats@xxxxxxxxxxxxxxxxx> · Tue, 20 Oct 2020 19:40:40 +0200



    On 10/20/20 3:22 PM, Victor Yegorov
      wrote:

    
        вт, 20 окт. 2020 г. в 11:38, Mats Julian Olsen
          <mats@xxxxxxxxxxxxxxxxx>:

        
              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