POSTGRESQL

Checks connectivity to the database. Sends a critical alert if the database is inaccessible. Configuration: Database name, TCP port to connect to, user and password to connect to the database.

Checks the total number of current connections to a PostgreSQL server. Sends an alert if this number exceeds a threshold. This threshold can be expressed as an absolute value or a percentage of the maximum number of connections. Configuration: Database name & TCP port to connect to, user and password to connect to the database, alert threshold, critical threshold.

Checks that the running PostgreSQL version is the one specified. Sends an alert if the version is different from the expected one. This checkpoint can be useful to inventory databases that need to be upgraded. Configuration: Database name, TCP port to connect to, user and password to connect to the database, expected version, alert type (warning/critical).

Controls the execution times of requests. Sends an alert if the slowest active request exceeds a certain runtime. Provides information about the slowest query in the performance data.
Configuration: Database name, TCP port to connect to, user and password to connect to the database, alert threshold, critical threshold in seconds.

Checks how long a specific query takes to execute by running the EXPLAIN ANALYZE command on it. Alerts when the execution time exceeds the alert threshold. The query to be executed must be a function or a view previously created in the database. Configuration: Database name, TCP port to connect to, user and password to connect to the database, alert threshold, critical threshold in seconds, function or view name.

Checks that the database parameters have not been changed. Based on the calculation of a checksum from the parameters, which is compared to the previously calculated checksum. Sends an alert if the configuration has changed. Configuration: Database name, TCP port to connect to, user and password to connect to the database, checksum, alert type. Use 0 as checksum parameter when starting this service for the first time.

Collects the date of last execution of the "analyze" command and alerts according to the defined thresholds.
Configuration: database name, TCP port to connect to, user and password to connect to the database, alert threshold, critical threshold in seconds, minutes, hours or days.

Collects the date of last execution of the "vacuum" command and alerts according to the defined thresholds.
Configuration: Database name, TCP port to connect to, user and password to connect to the database, alert threshold, critical threshold in seconds, minutes, hours or days.

Checks the number of locks present on the specified database. Can alert when the number of locks exceeds a threshold. Thresholds can be set on the total number of locks, the number of pending locks or the number of locks of a particular type (exclusive, shared...). Performance data is only returned for the thresholds that have been set. Configuration: Database name & TCP port to connect to, user and password to connect to the database, alert threshold, critical threshold for each lock group (total, pending, lock types...)

Executes a SQL query of your choice on a database. The value returned by your query can contain 1 or 2 columns. The first column must return an integer or string value (column name must be result) and the second column is used to display the performance value of integer type only for integer, time and size types. The plugin can use 4 types for the thresholds. integer: Compares an integer. The first column must be integer and named "result", the thresholds must be integer and identical for warning and critical. string: Compares a string. Changes state according to the returned string. Be careful the text is case sensitive. time: Compares dates of type hours, minutes or seconds or days. If no unit is specified the second is used by default. The 1st column must be an integer and represent the number of seconds to be checked. size: Compares sizes of bytes, kilobytes, megabytes, gigabytes, terabytes, or exabytes. An abbreviation is possible on the first character. If no unit is specified then bytes is used. The first column must be an integer and represent the size in bytes to be checked. Configuration: Database name, TCP port to connect to, user and password to connect to the database, query, alert threshold, critical threshold.

Checks the number of current connections to the specified database. Sends an alert if this number exceeds a threshold. This threshold can be expressed as an absolute value or as a percentage of the maximum number of connections. Configuration : Database name & TCP port to connect to, user and password to connect to the database, alert threshold, critical threshold.

Checks the size in bytes of the specified database. Sends an alert if it is too large. Configuration : Database name, TCP port to connect to, user and password to connect to the database, alert threshold, critical threshold

Checks the cache usage ratio. Sends an alert if it falls below a threshold. Configuration : Database name, TCP port to connect to, user and password to connect to the database, alert threshold, critical threshold in percentage.

Checks the rate of committed transactions as opposed to rollbacks. This rate expresses the percentage of committed transactions compared to the total number of transactions performed on the specified database. An alert is generated when this rate falls below a threshold. Configuration: Database name, TCP port, user and password to connect to the database, alert threshold, critical threshold in percentage.