If you monitor using nagios (or if you want to make a wrapper around it): https://bucardo.org/check_postgres/check_postgres.pl.html#bloat works like a charm. regards, fabio pardi On 07/16/2018 05:16 PM, Alessandro Aste wrote: > 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.
