POSTGRESQL

Presentation

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

Service Templates

BOX mode

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

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...). The performance data is only reported for the thresholds that have been defined. Configuration: Name of the database & TCP port to connect to, user and password to connect to the database, alert threshold, critical threshold for each group of locks (total, pending, lock types...).

Available from version
3.13

PostgreSQL-pgsql-longestQuery

Controls the execution times of requests. Sends an alert if the slowest active query exceeds a certain execution time. 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 it takes for a specific request to execute by running the EXPLAIN ANALYZE command on it. Alerts when the execution time exceeds the alert threshold. The query executed must be a function or view previously created in the database. Configuration: Name of the database, TCP port to connect to, user and password to connect to the database, alert threshold, critical threshold in seconds, name of the function or view.

Available from version
3.13

PostgreSQL-pgsql-settings

Checks that the database settings have not been changed. Is based on the calculation of a checksum from the parameters, which is compared with 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 a checksum parameter the first time this service is launched.

Available from version
3.13

PostgreSQL-pgsql-status

Checks database connectivity. 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 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-version

Verifies that the version of PostgreSQL currently running is the one specified. Sends an alert if the version is different from the expected one. This checkpoint can be useful for inventorying 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 transactions that are released (commit) as opposed to those that are reversed (rollback). This rate expresses the percentage of committed transactions in relation to the total number of transactions 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, percentage critical threshold.

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 a value of type "integer" or "string" (the column name must be result) and the second column is used to display the performance value of type "integer" only for the types integer, time and size. 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. Attention the text is sensitive to the box. time: Compares dates of type hours, minutes or seconds or days. If no unit is specified the second is used by default. The first column must be an integer and represent the number of seconds to be checked. size: Compares sizes such as bytes, kilobytes, megabytes, gigabytes, terabytes, or exabytes. An abbreviation is possible on the 1st character. If no unit is specified then the unit bytes is used. Configuration: Name of the database, 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 byte size 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 day.

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

Available from version
3.13
en_US
fr_FR en_US

Welcome to ServiceNav!

Need help? More information about our products? Write to us!
You have taken note of our privacy policy.

[COVID - 19 ] - TELEWORKING, TARGET AVAILABILITY 100% !

While the epidemic lasts, ensure the availability and performance of your IT services for teleworking, with ServiceNav!

Following the government's call to mobilize to help businesses overcome the current health and economic context, we help you, free of charge, to ensure the complete monitoring of your teleworking environments: VPN, VDI, Teams, Skype Enterprise, Citrix... Objectives: collection, availability and usage indicators, dashboards to support your communication.
We use cookies to ensure that you have the best possible experience on our site, and 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.