Werk #2057: New checks for postgreSQL monitoring

Component Checks & agents
Title New checks for postgreSQL monitoring
Date Mar 12, 2015
Level Prominent Change
Class New Feature
Compatibility Compatible - no manual interaction needed
Checkmk versions & editions
1.2.7i1
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i1
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i1
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i1
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i1
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i1
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i1
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i1
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i1 Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)

With this update the agent plugin mk_postgres now reports additional information, which will be processed by these new checks:

CheckDescriptionLimits configurable
postgres_bloatSize of wasted table- and indexspaceX
postgres_connectionsNumber of connections to databaseX
postgres_locksNumber of SharedAccess and ExclusiveLocksX
postgres_statsTime of last VACUUM and ANALYZEX
postgres_query_durationDisplays longest running query
postgres_versionDisplays PostgreSQL version
postgres_conn_timeTime to connect to database

Note: You have to update the agent plugin mk_postgres on the target host.

To the list of all Werks