[check_postgres] Issue with check_postgres bloat check.

[Shaik, Baji]

Hi Jehan,

Thanks for the update.

I will try to test this with enterprisedb database, however could you
please confirm if my understanding is correct on bloat percentage. We still
see alerts, though tables are not bloated to 50%.


Specifying the threshold as a percentage results in comparing the ratio of
actual size to expected size rather than the ratio of bloat to expected
size. Is that correct?

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
>



-- 
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/ef8bd7de/attachment.html>