Postgres Pro
Downloads
Home   >   mailing lists

Slow query on V12. - Mailing list pgsql-performance

From Luís Roberto Weck
Subject Slow query on V12.
Date
Msg-id eaf7b5fa-d832-ca49-2811-2d3ab21a5444@siscobra.com.br
Whole thread Raw
Responses Re: Slow query on V12.
List pgsql-performance
Tree view
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.


pgsql-performance by date:

Previous
From: Mariel Cherkassky
Date:
Subject: Re: pg12 partitions question
Next
From: nikhil raj
Date:
Subject: Re: Slow query on V12.