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.

Check manual page of postgres_stat_database

Checkmk Manual

Search in the manual

Database statistics for PostgreSQL

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

This check handles the metrics returned from PostgreSQL's statistics functions pg_stat_database and pg_database_size. It allows monitoring of disk blocks read, but PostgreSQL seems to not have a simple "written bytes" or "write IOs" counter, meaning this information cannot be directly monitored.

Instead, the check allows more fine-grained monitoring of database activity by tracking what the queries really do. You can monitor both "read statements" like fetches, as well as "write statements as update/delete/insert. Finally it allows monitoring of commits, which PostgreSQL tracks down to the sub-transaction level.

You can then define levels on the per-second amount of the statements.

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

Discovery

One item is generated per database.