Re: Slow query on V12.

nikhil raj <[email protected]> Tue, 24 Sep 2019 00:13:12 +0530

Newsgroups	gmane.comp.db.postgresql.performance
Message-ID	<CAG1ps1zzAeB9Z3PEhQt5zVLjGocgvWWZMkhVq-NhPF7VKrn+3g@mail.gmail.com>

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, <
[email protected]> 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.
>
>
>