WDRs
The following table describes the WDR content of the openGauss database.
Table 1 Content of the WDR
Metric | Description |
---|
Database Stat | - Database performance statistics: transactions, read and write, row activities, write conflicts, and deadlocks
- Database-wide report, which can be viewed only in cluster mode.
|
Load Profile | - Datebase 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 only in cluster 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.
- Node-wide report, which can be viewed in node mode.
|
Time Model | - Time distribution information about the statements in a node.
- Node-wide report, which can be viewed in node mode.
|
SQL Statistics | - SQL statement performance statistics: end-to-end time, row activities, cache hit, CPU consumption, and time consumption.
- 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.
|
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 on 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.
|
openGauss 2025-04-28 22:42:47