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
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 |