Re: Slow query on V12.

From: nikhil raj <nikhilraj474(at)gmail(dot)com>
To: Luís Roberto Weck <luisroberto(at)siscobra(dot)com(dot)br>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Slow query on V12.
Date: 2019-09-23 18:43:12
Message-ID: CAG1ps1zzAeB9Z3PEhQt5zVLjGocgvWWZMkhVq-NhPF7VKrn+3g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)siscobra(dot)com(dot)br> 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.
>
>
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Luís Roberto Weck 2019-09-23 19:03:54 Re: Slow query on V12.
Previous Message Luís Roberto Weck 2019-09-23 18:42:05 Slow query on V12.