[checkmk-commits] Check_MK Git: check_mk: Man page for PostgreSQL database statistics

Module: check_mk Branch: master Commit: a54ae8260eb08da7e4a34eb9e368edf1f9b43687 URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=a54ae8260eb08d… Author: Florian Heigl <fh(a)mathias-kettner.de> Date: Tue Jun 5 12:59:46 2012 +0200 Man page for PostgreSQL database statistics --- checkman/postgres_stat_database | 29 +++++++++++++++++++++++++++++ 1 files changed, 29 insertions(+), 0 deletions(-) diff --git a/checkman/postgres_stat_database b/checkman/postgres_stat_database new file mode 100644 index 0000000..a2c3b87 --- /dev/null +++ b/checkman/postgres_stat_database @@ -0,0 +1,29 @@ +title: Database statistics for PostgreSQL +agents: linux +author: Mathias Kettner <mk(a)mathias-kettner.de> +license: GPL +distribution: check_mk +description: + 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. + +inventory: + One item is generated per database. + + +[configuration] + +perfdata: + The numbers for disk blocks read, and the number of transactions per + transaction type.