Slow query on V12.

Luís Roberto Weck <[email protected]> Mon, 23 Sep 2019 15:42:05 -0300

Newsgroups	gmane.comp.db.postgresql.performance
Message-ID	<[email protected]>

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.


****