On Tue, 17 Jul 2018 10:11:50 +0200 Fabio Pardi <f.pardi@xxxxxxxxxxxx> wrote: > 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 ...and check this one: https://github.com/OPMDG/check_pgactivity/ It uses bloat queries for tables and btree indexes Adrien Nayrat was pointing earlier in this thread. In fact, both queries in check_pgactivity were written because the bloat check in check_postgres was considering **all** fields were in **all*** indexes...Which is quite a large approximation...I don't know if this is still the case though. > 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,
