check_postgres_bloat

Поиск
Список
Период
Сортировка
От dx k9
Тема check_postgres_bloat
Дата
Msg-id SNT123-W511D0C40E200A7B43775B1D1D90@phx.gbl
обсуждение исходный текст
Список 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. Get busy.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: check_postgres_bloat
Следующее
От: Robert Voinea
Дата:
Сообщение: Re: Server crash when using dblink_build_sql_* after alter table