--_183482ae-cadf-4c55-a743-c4861609c49a_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks everyone for the responses.
It seems like the problem is actually that the check_postgres_bloat does no=
t check for index bloat=2C just table bloat=2C even though it says it check=
s for both.
Below is my proof. Notice how this first check finds the indexes with idx =
in their name=2C 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=3Dthing=
-w 50 --include=3D~idx -c 100
POSTGRES_INDEX_SIZE CRITICAL: service=3Dthing largest index is "thing1_idx"=
: 288 kB | time=3D1.00
/usr/local/nagios/libexec # ./check_postgres_bloat --dbservice=3Dthing -w 5=
0 --include=3D~idx -c 100 POSTGRES_BLOAT UNKNOWN: service=3Dthing No matchi=
ng relations found due to exclusion/inclusion options | time=3D0.18
____________________________________________________________ _____
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with H=
otmail.
http://www.windowslive.com/campaign/thenewbusy?tile=3Dmultic alendar&ocid=3D=
PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5=
--_183482ae-cadf-4c55-a743-c4861609c49a_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<style><!--
..hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
--></style>
</head>
<body class=3D'hmmessage'>
Thanks everyone for the responses.<BR>
=3B<BR>
It seems like the problem is actually that the check_postgres_bloat does no=
t check for index bloat=2C just table bloat=2C even though it says it check=
s for both.<BR>
=3B<BR>
Below is my proof. =3B <FONT face=3DConsolas>Notice how this first chec=
k finds the indexes with idx in their name=2C but the second one doesn't.<S=
PAN style=3D"mso-spacerun: yes"> =3B </SPAN><o:p><FONT size=3D3></FONT>=
</o:p></FONT><BR>
=3B<BR>
check_postgres.pl version 2.14.3<BR>postgresq version is 8.3.9<BR>
=3B<BR>
<P style=3D"MARGIN: 0in 0in 0pt" class=3DMsoPlainText><FONT size=3D3 face=
=3DConsolas><SPAN style=3D"mso-spacerun: yes"> =3B =3B</SPAN></FONT=
><?xml:namespace prefix =3D o ns =3D "urn:schemas-microsoft-com:office:offi=
ce" /><o:p><FONT size=3D3 face=3DConsolas> =3B</FONT></o:p></P>
<P style=3D"MARGIN: 0in 0in 0pt" class=3DMsoPlainText><FONT size=3D3 face=
=3DConsolas>/usr/local/nagios/libexec # ./check_postgres_index_size --dbser=
vice=3Dthing -w 50 --include=3D~idx -c 100 </FONT></P>
<P style=3D"MARGIN: 0in 0in 0pt" class=3DMsoPlainText><FONT size=3D3 face=
=3DConsolas></FONT> =3B</P>
<P style=3D"MARGIN: 0in 0in 0pt" class=3DMsoPlainText><FONT size=3D3 face=
=3DConsolas>POSTGRES_INDEX_SIZE CRITICAL: service=3Dthing largest index is =
"thing1_idx": 288 kB | time=3D1.00<SPAN style=3D"mso-spacerun: yes"> =
=3B =3B</SPAN></FONT><o:p><FONT size=3D3 face=3DConsolas> =3B</FONT=
></o:p></P>
<P style=3D"MARGIN: 0in 0in 0pt" class=3DMsoPlainText><o:p><FONT size=3D3 f=
ace=3DConsolas> =3B</FONT></o:p></P>
<P style=3D"MARGIN: 0in 0in 0pt" class=3DMsoPlainText><FONT size=3D3 face=
=3DConsolas>/usr/local/nagios/libexec # ./check_postgres_bloat --dbservice=
=3Dthing -w 50 --include=3D~idx -c 100 POSTGRES_BLOAT UNKNOWN: service=3Dth=
ing No matching relations found due to exclusion/inclusion options | time=
=3D0.18 </FONT></P>
<P><BR> =3B<BR></P>
<hr />The New Busy think 9 to 5 is=
a cute idea. Combine multiple calendars with Hotmail. <a href=3D'http://w=
ww.windowslive.com/campaign/thenewbusy?tile=3Dmulticalendar& ocid=3DPID28326=
::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5' target=3D'_new'>Get busy.</a></bod=
y>
</html>=
--_183482ae-cadf-4c55-a743-c4861609c49a_--
