Home > mailing lists

Query to monitor index bloat - Mailing list pgsql-general

From	Alessandro Aste
Subject	Query to monitor index bloat
Date	July 16, 2018 18:16:11
Msg-id	CAM9F+O1jAPSPTqWeOj18NFjkOyy4DOaM3NS51ARE_rxB3fLMOQ@mail.gmail.com Whole thread Raw
Responses	Re: Query to monitor index bloat Re: Query to monitor index bloat
List	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.

From: Tim Clarke
Date: 16 July 2018, 17:04:55
Subject: Re: Do we need yet another IDE (SQL development assistant) forPostgreSQL?

From: Adrien NAYRAT
Date: 16 July 2018, 18:44:48
Subject: Re: Query to monitor index bloat