Description
It monitors Postgres DB agent metrics like database connections, tables rows count, maximum connections, user table count.
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.
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.database.connections
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of active connections to postgres database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud PostgreSQL Database Connection Statistics Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| 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.settings.connection
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The number of connections to this database as a fraction of the maximum number of allowed connections. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud PostgreSQL Database Connection Statistics Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| 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.user_tables.rows_count
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Number of rows scans |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud PostgreSQL Database Connection Statistics Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| 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.max_connections
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | The maximum number of client connections allowed to this database shown as connection |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud PostgreSQL Database Connection Statistics Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| 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.user.table.count
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | It monitors the number of user tables in current database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud PostgreSQL Database Connection Statistics Monitor |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| 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