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,
<luisrobe...@siscobra.com.br <mailto:luisrobe...@siscobra.com.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.
