PostgreSQL supported metrics
Hardware metrics:
Metrics | Description |
---|---|
Type of OS | Type of OS on which DB is running (Linux/Windows etc.) |
Architecture | The OS architecture. |
Host name | Configured host name on which DB is present |
Availability | Active/Inactive [The database availability] |
Average CPU usage | Average CPU usage of the machine |
Average memory usage | Average memory usage of the machine |
Disk usage | Disk usage on the configured host |
CPU usage | CPU usage on the configured host |
Memory usage | Memory usage on the configured host |
Network I/O | I/O megabytes per second |
Connections & sessions | Number of connections per minute |
Query Performance:
Metrics | Description |
---|---|
Query | List of slow queries performed/available |
Total Execution | Count of executions of each slow queries performed/available |
Execution Time | Total execution time of each collected query |
Timestamp | Last timestamp of each collected query |
Connections:
Metrics | Description |
---|---|
Number of connections | Number of connections made for the database |
Number of sessions | Number of session established for the database |
Session details | User/Query list for established session |
Metrics:
Metrics | Description |
---|---|
Bulk operations | Number of bulk operations per minute |
Confis operations | Number of confis operations per minute |
Tup operations | Number of Tup operations per minute |
Xact operations | Number of Xact operations per minute |
note
Disk usage shows in GB and other metrics will be available in MB.