From: Luís Roberto Weck <luisroberto@siscobra.com.br>
To: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
Subject: Slow query on V12.
Date: Mon, 23 Sep 2019 15:42:05 -0300
Message-ID: <eaf7b5fa-d832-ca49-2811-2d3ab21a5444@siscobra.com.br> (raw)
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.
****
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: luisroberto@siscobra.com.br, pgsql-performance@lists.postgresql.org
Subject: Re: Slow query on V12.
In-Reply-To: <eaf7b5fa-d832-ca49-2811-2d3ab21a5444@siscobra.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox