[check_postgres] Issue with check_postgres bloat check.
Jehan-Guillaume de Rorthais
jgdr at dalibo.com
Tue Oct 27 09:23:10 UTC 2015
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
More information about the Check_postgres
mailing list