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.