Slow query on V12.

From: Luís Roberto Weck <luisroberto(at)siscobra(dot)com(dot)br>
To: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Slow query on V12.
Date: 2019-09-23 18:42:05
Message-ID: eaf7b5fa-d832-ca49-2811-2d3ab21a5444@siscobra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

****

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message nikhil raj 2019-09-23 18:43:12 Re: Slow query on V12.
Previous Message Mariel Cherkassky 2019-09-23 11:02:10 Re: pg12 partitions question