Re: Slow query on V12.

Luís Roberto Weck <luisroberto@xxxxxxxxxxxxxxx> · Mon, 23 Sep 2019 16:03:54 -0300



    Em 23/09/2019 15:43, nikhil raj escreveu:

    
      Hi,
        

        Can you check by vacuum analyze  the database.
          And run the query.
        

        **Remember don't  use Vacuum full.
      
      
        On Tue, 24 Sep 2019, 12:07 am
          Luís Roberto Weck, <luisroberto@xxxxxxxxxxxxxxx>
          wrote:

        
           Hi!

            
            Recently I've been looking for bloat in my databases and
            found a query to show which tables are more bloated and by
            how much.

            
            This is the explain plan on v12.3: https://explain.depesz.com/s/8dW8C

            And this is with v11: https://explain.depesz.com/s/diXY

            
            Both databases have approx. the same size and have the same
            schema, but on v12 I the query takes much longer to run.

            
    Hi!

    
    Thanks for the reply!

    
    Here's the plan after running vacuum analyze: https://explain.depesz.com/s/lhcl

    
    There was no difference in execution time.