[check_postgres] Issue with check_postgres bloat check.

[Shaik, Baji]

Thanks Jehan,

>
> In check_pgactivity, the ratio express the size of the bloat in the table
> (heap+toast). A table with a bloat ratio of 50% means that half of its
> size is
> bloat.
>

I understand that. What surprises me that, it's comparing ration of actual
size to expected size, but it should not be. It should compare bloat size
to expected size, that actually gives you how much percentage of bloat a
table/index has.

However I am still confused on if I am missing something.

>
> >
> > On Tue, Oct 27, 2015 at 5:23 AM, Jehan-Guillaume de Rorthais <
> > jgdr at dalibo.com> wrote:
> >
> > > On Fri, 16 Oct 2015 20:11:24 +0530
> > > "Shaik, Baji" <baji.shaik at openscg.com> wrote:
> > >
> > > > Hi Team,
> > >
> > > Hi,
> > >
> > > > I have configured bloat_check for 50% of the table as WARNING,
> however
> > > even
> > > > if tables is bloated less than the percentage configured, it is
> throwing
> > > an
> > > > alert. If you see below example, ONLY 30% of the table is bloated,
> > > however
> > > > still I can see the table in the bloated list with 50% as critical
> > > > threshold.
> > > >
> > > > Kindly let me know if I am missing anything.
> > > >
> > > > bloat_test=# \dt+ t
> > > >                      List of relations
> > > >  Schema | Name | Type  |    Owner     | Size  | Description
> > > > --------+------+-------+--------------+-------+-------------
> > > >  public | t    | table | enterprisedb | 69 MB |
> > > > (1 row)
> > > >
> > > > bloat_test=# \q
> > > > root at ubuntu:/home/bajishaik/check_postgres-2.22.0#
> > > ./check_postgres_bloat
> > > > --port=5445 --critical='500%' --db='bloat_test'
> --dbuser='enterprisedb'
> > > > POSTGRES_BLOAT OK: DB "bloat_test" (port=5445) (db bloat_test) table
> > > > public.t rows:1500001 pages:8850 shouldbe:6608 (1.3X) wasted
> > > size:18366464
> > > > (17 MB) | public.t=18366464B
> > > > root at ubuntu:/home/bajishaik/check_postgres-2.22.0#
> > > > root at ubuntu:/home/bajishaik/check_postgres-2.22.0#
> > > > root at ubuntu:/home/bajishaik/check_postgres-2.22.0#
> > > ./check_postgres_bloat
> > > > --port=5445 --critical='50%' --db='bloat_test'
> --dbuser='enterprisedb'
> > > > POSTGRES_BLOAT CRITICAL: DB "bloat_test" (port=5445) (db bloat_test)
> > > table
> > > > public.t rows:1500001 pages:8850 shouldbe:6608 (1.3X) wasted
> > > size:18366464
> > > > (17 MB) | public.t=18366464B
> > >
> > > I see you are using entreprisedb ? Could you have a look at
> > > check_pgactivity by
> > > any chance and tell me if it is compatible ? :-)
> > >
> > > See:
> > >
> > >
> https://exchange.nagios.org/directory/Plugins/Databases/PostgresQL/check_pgactivity/details
>
> --
> Jehan-Guillaume de Rorthais
> Dalibo
> http://www.dalibo.com
>



-- 
Regards,
Baji Shaik,
Database Consultant | *OpenSCG*
Phone: 9922995922 | Email: baji.shaik at openscg.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20151103/2d1269fc/attachment-0001.html>