check_postgres_bloat

From: dx k9 <bitsandbytes88(at)hotmail(dot)com>
To: posgres support <pgsql-admin(at)postgresql(dot)org>
Subject: check_postgres_bloat
Date: 2010-06-11 17:26:30
Message-ID: SNT123-W511D0C40E200A7B43775B1D1D90@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Thanks everyone for the responses.

It seems like the problem is actually that the check_postgres_bloat does not check for index bloat, just table bloat, even though it says it checks for both.

Below is my proof. Notice how this first check finds the indexes with idx in their name, but the second one doesn't.

check_postgres.pl version 2.14.3
postgresq version is 8.3.9


/usr/local/nagios/libexec # ./check_postgres_index_size --dbservice=thing -w 50 --include=~idx -c 100

POSTGRES_INDEX_SIZE CRITICAL: service=thing largest index is "thing1_idx": 288 kB | time=1.00

/usr/local/nagios/libexec # ./check_postgres_bloat --dbservice=thing -w 50 --include=~idx -c 100 POSTGRES_BLOAT UNKNOWN: service=thing No matching relations found due to exclusion/inclusion options | time=0.18



_________________________________________________________________
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5

Browse pgsql-admin by date

  From Date Subject
Next Message Prasad DVN 2010-06-14 08:42:16 Re: nmsbdmgr doesnt start
Previous Message Greg Smith 2010-06-11 15:41:18 Re: check_postgres_bloat