Query to monitor index bloat

From: Alessandro Aste <alessandro(dot)aste(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Query to monitor index bloat
Date: 2018-07-16 15:16:11
Message-ID: CAM9F+O1jAPSPTqWeOj18NFjkOyy4DOaM3NS51ARE_rxB3fLMOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, I am trying to put togheter a query to monitor the index bloat for
a database I maintain.
Is there a "SQL" way to obtain bloated index ? I googled around but I
found nothing working.

I'm currently running 9.6 but I'm looking for something compatible with
version 10 too.

Thank you very much in advance,

Alessandro.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrien NAYRAT 2018-07-16 15:44:48 Re: Query to monitor index bloat
Previous Message Tim Clarke 2018-07-16 14:04:55 Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?