We use cookies to ensure that we give you the best experience on our website.  Visit our Privacy Policy to learn more. If you continue to use this site, we will assume that you are okay with it.

Your choices regarding cookies on this site.
Your preferences have been updated.
In order for the changes to take effect completely please clear your browser cookies and cache. Then reload the page.

Checkmk 1.6 has arrived! Learn more about it here!

Check manual page of postgres_stats

Checkmk Manual

Search in the manual

PostgreSQL Database Last Vacuum and Analyze

Distribution: official part of Check_MK
License: GPL
Supported Agents: Linux

This check allows you to monitor the last VACUUM and ANALYZE time for tables in a PostgreSQL database. You can configure limits specifiying the maximum age of the last operation. Without additional limits configuration this check is always OK.

This check relies on data reported by the agent-side plugin mk_postgres.

Check status:

For every table the time since it has last been analyzed or vacuumed is checked according to the WATO rule "PostgresSQL VACUUM and ANALYZE: Time since the last VACUUM" and "Time since the last ANALYZE" respectively. For tables that were never analyzed or vacuumed the time period for which they exist is checked according to the WATO rule "PostgresSQL VACUUM and ANALYZE: Age of never analyzed/vacuumed tables".


Two services for each database. One for VACUUM and one for ANALYZE.