| Database Stat | - Database performance statistics: transactions, read and write operations, row activities, write conflicts, and deadlocks.
- Database-wide report, which can be viewed in cluster or node mode.
|
| Load Profile | - Database performance statistics: CPU time, DB time, logical or physical read, I/O performance, login and logout, load strength, and load performance.
- Database-wide report, which can be viewed in cluster or node mode.
|
| Instance Efficiency Percentages | - Database-level or node-level cache hit ratio.
- Database/Node-wide report, which can be viewed in cluster or node mode.
|
| Top 10 Events by Total Wait Time | - Most time-consuming event.
- Node-wide report, which can be viewed in node mode.
|
| Wait Classes by Total Wait Time | - Category of the wait time that is most time-consuming.
- Node-wide report, which can be viewed in node mode.
|
| Host CPU | - CPU usage of the host.
- Node-wide report, which can be viewed in node mode.
|
| IO Profile | - I/O usage in the database or node dimension.
- Database/Node-wide report, which can be viewed in cluster or node mode.
|
| Memory Statistics | - Kernel memory usage distribution.
- Node-wide report, which can be viewed in node mode.
|
| Time Model | - Time model data generated by running SQL statements on a node range.
- Node-wide report, which can be viewed in node mode.
|
| SQL Statistics | - SQL statement performance statistics are displayed in the following dimensions: total time, average time, CPU duration, number of returned rows, number of scanned rows, number of execution times, logical read, and physical read.
- Database/Node-wide report, which can be viewed in cluster or node mode.
|
| Wait Events | - Statistics on wait events at the node level.
- Node-wide report, which can be viewed in node mode.
For details, see the waiting status list, list of wait events corresponding to lightweight locks, list of wait events corresponding to I/Os, and list of wait events corresponding to transaction locks in PG_THREAD_WAIT_STATUS. |
| Cache IO Stats | - I/O statistics on user tables and indexes.
- Database/Node-wide report, which can be viewed in cluster or node mode.
|
| Utility status | - Status information about the replication slot and background checkpoint.
- Node-wide report, which can be viewed in node mode.
|
| Object stats | - Performance statistics in the index and table dimensions.
- Database/Node-wide report, which can be viewed in cluster or node mode.
|
| Configuration settings | - Node configuration.
- Node-wide report, which can be viewed in node mode.
|
| SQL Detail | - SQL statement text details.
- Database/Node-wide report, which can be viewed in cluster or node mode.
|
