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.