PostgreSQL Database
- Version: 2.4
- Compatibility: v 7.7.903
- Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Database Name (Mandatory), Timout (Mandatory), Enable Time Monitoring (Mandatory), Metric Collector Time (Mandatory)
- Operation: Monitors the port service of PostgreSQL Database.
- Version: 2.3
- Compatibility: v 7.5.3
- Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Database Name (Mandatory), Timout (Mandatory), Enable Time Monitoring (Mandatory), Metric Collector Time (Mandatory)
- Operation: Monitors the port service of PostgreSQL Database.
- Plugin-Metrics:
| Metric | Data Type |
|---|---|
| Connection Time (MS) | Numeric |
| Database Name | String |
| Database Size (Bytes) | Numeric |
| Database Table | Numeric |
Instance Columns:
Table
| Metric | Data Type |
|---|---|
| Table | String |
| Table Sequential Scans | Numeric |
| Table Sequential Live Rows Read | Numeric |
| Table Index Scans | Numeric |
| Table Index Rows Fetch | Numeric |
| Table Inserted Rows | Numeric |
| Table Updated Rows | Numeric |
| Table Deleted Rows | Numeric |
| Table Live Rows | Numeric |
| Table Dead Rows | Numeric |
| Table Last Auto Vacuum | String |
| Table Hot Rows Updated | Numeric |
| Table Last Auto Analyze | String |
| Table Auto Vacuum | Numeric |
| Table Auto Analyze | Numeric |
| Table Rows | Numeric |
| Table Size (KB) | Numeric |
| Table Index Size (Bytes) | Numeric |
| Table Sequential Scans/sec | Numeric |
| Table Sequential Live Rows Read/sec | Numeric |
| Table Index Scans/sec | Numeric |
| Table Index Rows Fetch/sec | Numeric |
| Table Inserted Rows/sec | Numeric |
| Table Updated Rows/sec | Numeric |
| Table Deleted Rows/sec | Numeric |