[Check_mk (english)] Postgres warns about (temporary) tables not vacuumed

Hi everybody

We are monitoring our oVirt environment amongst other things with check_mk, and were quite annoyed due to a warning by the checks "postgresql vacuum" and "analyze" of the central engine databse. As my colleague found out, the plugin handles temporary tables as it does "normal" ones...vacuuming temporary tables obviously makes no sense to neither oVirt nor us, though. Therefore my colleague modified the plugin as a "quick fix".

Simply add (line 102):

AND NOT pg_is_other_temp_schema(n.oid)

We would appreciate the fix to be implemented into the official check_mk plugin, if you guys think as we do. If not, at least here's the documentation of how to get rid of it. :wink:

Best regards,
Maik

1 Like