Re: Slow query on V12.

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