Description
It monitors Postgres DB agent metrics like user table rowsdead, database deadlocks, locks granted.
Prerequisites
The database you want to monitor should connect from the Gateway. Gateway Management profile should be added to the device. Database type credentials should be added against the device in the portal. While applying the template, the database port, Database Name, connection timeout need to be specified.
Metric Parameters
| Parameter | Description |
|---|---|
| Frequency | Warning Threshold | If the metric value satisfies the condition defined along with Warning Threshold value, then a notification is sent to the user. |
| Critical Threshold | If the metric value satisfies the condition defined along with Critical Threshold value, then a notification is sent to the user. |
| Alert | The alert value can be set to either Yes or No. If it is Yes, then an alert message is sent to the user. |
Metrics
postgresql.usertable.rowsdead
Metric Details
| Applicable for | Device |
| Description | This query gives the number of dead rows (tuples) in the table. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Locks Monitor |
| Unit | NULL |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | Manual |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
postgresql.database.deadlocks
Metric Details
| Applicable for | Device |
| Description | Number of deadlocks detected in this database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Locks Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | Manual |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
postgresql.locks.granted
Metric Details
| Applicable for | Device |
| Description | True if lock is held, false if lock is awaited. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Locks Monitor |
| Unit | NULL |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | Manual |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph