Description
It monitors Postgres DB agent metrics like statiotables toastblks hit, idxblks hit, database blks hit, statioindexes buffer hits.
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.statiotables.toastblkshit
Metric Details
| Applicable for | Device |
| Description | Number of buffer hits in this table's TOAST table (if any). |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database BlockHits 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.statiotables.idxblkshit
Metric Details
| Applicable for | Device |
| Description | Number of buffer hits in all indexes on this table. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database BlockHits 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.database.blkshit
Metric Details
| Applicable for | Device |
| Description | Number of times disk blocks were found already in the buffer cache, so that a read was not necessary (this only includes hits in the PostgreSQL buffer cache, not the operating system's file system cache). |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database BlockHits 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.statioindexes.bufferhits
Metric Details
| Applicable for | Device |
| Description | Number of buffer hits in this index. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database BlockHits 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