Check-Manual von postgres_stat_database
PostgreSQL: Statistics | |
---|---|
Distribution | offizieller Teil von Check_MK |
Lizenz | GPLv2 |
Unterstützte Agenten | Linux |
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
Item
Name of the category and the name of the database
Discovery
One service is created for each database.