PostgreSQL
- Version: 2.3
- Compatibility: v 7.7.903
- Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Database Name (Mandatory), Timout (Mandatory), Metric Collector Time (Mandatory)
- Operation: Monitors the port service of PostgreSQL.
- Version: 2.2
- Compatibility: v 7.5.3
- Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Database Name (Mandatory), Timout (Mandatory), Metric Collector Time (Mandatory)
- Operation: Monitors the port service of PostgreSQL.
- Plugin-Metrics:
PostgreSQL
| Metric | Data Type |
|---|---|
| Connection Time (MS) | Numeric |
| Active Connections | Numeric |
| Total Users | Numeric |
| Held Locks | Numeric |
| Wait Locks | Numeric |
| Block Hits | Numeric |
| Block Reads | Numeric |
| Cache Hit Ratio (%) | Numeric |
| Commits | Numeric |
| Rollbacks | Numeric |
| Inserted Rows | Numeric |
| Updated Rows | Numeric |
| Deleted Rows | Numeric |
| Data Directory | String |
| Kerberos Service | String |
| Version | String |
| Maintenance Work Memory (MB) | Numeric |
| Shared Buffers (MB) | Numeric |
| Effective Cache Size (MB) | Numeric |
| Auto Vacuum | String |
| Work Memory (MB) | Numeric |
| Maximum Connections | Numeric |
| Wal Buffer (MB) | Numeric |
| Sequential Scans | Numeric |
| Sequential Rows Reads | Numeric |
| Index Scans | Numeric |
| Fetched Index Rows | Numeric |
| Index Rows Reads | Numeric |
| Procedures | Numeric |
| Triggers | Numeric |
| Tables | Numeric |
| Index Size (Bytes) | Numeric |
| Data Size (MB) | Numeric |
| Active Connections/sec | Numeric |
| Block Hits/sec | Numeric |
| Block Reads/sec | Numeric |
| Commits/sec | Numeric |
| Rollbacks/sec | Numeric |
| Inserted Rows/sec | Numeric |
| Updated Rows/sec | Numeric |
| Deleted Rows/sec | Numeric |
| Sequential Scans/sec | Numeric |
| Sequential Rows Reads/sec | Numeric |
| Index Scans/sec | Numeric |
| Fetched Index Rows/sec | Numeric |
| Index Rows Reads/sec | Numeric |