POSTGRESQL

Presentation

Find all the service models dedicated to the supervision of your POSTGRESQL Application.

Service Models

BOX mode

PostgreSQL-pgsql-longestQuery

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.

Available from version 3.13

PostgreSQL-pgsql-QueryRuntime

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.

Available from version 3.13

PostgreSQL-pgsql-settings

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.

Available from version 3.13

PostgreSQL-pgsql-status

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.

Available from version 3.13

PostgreSQL-pgsql-TotalCnx

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.

Available from version 3.13

PostgreSQL-pgsql-version

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).

Available from version 3.13

PostgreSQL-pgsql-CommitRatio

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.

Available from version 3.13

PostgreSQL-pgsql-custom-query

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.

Available from version 3.13

PostgreSQL-pgsql-dbCnx

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.

Available from version 3.13

PostgreSQL-pgsql-dbsize

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

Available from version 3.13

PostgreSQL-pgsql-Lastanalyze

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.

Available from version 3.13

PostgreSQL-pgsql-Lastvacuum

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.

Available from version 3.13

PostgreSQL-pgsql-locks

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...)

Available from version 3.13

PostgreSQL-pgsql-CacheHitRatio

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.

Available from version 3.13
en_GB

Welcome to ServiceNav!

Do you need some help? More information about our products? Write to us!
You have taken note of our privacy policy.
We use cookies to ensure the best experience on our site. If you continue to use this site, we will assume that you are satisfied with it.

Reserve your place

You have taken note of our privacy policy.