Re: Query to monitor index bloat

On Tue, 17 Jul 2018 10:11:50 +0200
Fabio Pardi <f(dot)pardi(at)portavita(dot)eu> 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,