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 |