Description
It monitors Postgres DB agent related metrics like database temp bytes, rows fetched, rows returned.
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.temp_bytes
Metric Details
| Applicable for | Device |
| Description | Total amount of data written to temporary files by queries in this database. All temporary files are counted, regardless of why the temporary file was created, and regardless of the log_temp_files setting. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Performance 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.rows_fetched
Metric Details
| Applicable for | Device |
| Description | Number of rows fetched by queries in this database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Performance 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.rows_returned
Metric Details
| Applicable for | Device |
| Description | Number of rows returned by queries in this database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Performance 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.rows_updated
Metric Details
| Applicable for | Device |
| Description | Number of rows updated by queries in this database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Performance 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.rows_deleted
Metric Details
| Applicable for | Device |
| Description | Number of rows deleted by queries in this database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Performance 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.rows_inserted
Metric Details
| Applicable for | Device |
| Description | Number of rows inserted by queries in this database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Performance 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.stat_tables.seq_tup_read
Metric Details
| Applicable for | Device |
| Description | Number of live rows fetched by sequential scans. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Performance 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.bgwriter.buffers_checkpoint
Metric Details
| Applicable for | Device |
| Description | Number of buffers written during checkpoints. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Performance 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.bgwriter.buffers_clean
Metric Details
| Applicable for | Device |
| Description | Number of buffers written by the background writer. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Performance 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.bgwriter.buffers_backend
Metric Details
| Applicable for | Device |
| Description | Number of buffers written directly by a backend. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Performance 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.bgwriter.checkpoints_timed
Metric Details
| Applicable for | Device |
| Description | Number of scheduled checkpoints that have been performed. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Performance 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.bgwriter.checkpoints_req
Metric Details
| Applicable for | Device |
| Description | Number of requested checkpoints that have been performed. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 PostgreSQL Database Performance 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