From: | Luís Roberto Weck <luisroberto(at)siscobra(dot)com(dot)br> |
---|---|
To: | nikhil raj <nikhilraj474(at)gmail(dot)com> |
Cc: | "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Slow query on V12. |
Date: | 2019-09-23 19:03:54 |
Message-ID: | 13d5836f-27c0-d8c3-0106-6ba0160fcd2b@siscobra.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)siscobra(dot)com(dot)br <mailto: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.
>
>
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Luís Roberto Weck | 2019-09-23 19:12:02 | Re: Slow query on V12. |
Previous Message | nikhil raj | 2019-09-23 18:43:12 | Re: Slow query on V12. |