Updated on 2023-10-23 GMT+08:00

WDRs

The following table describes the main contents of WDR reports.

Table 1 Content of WDRs

Item

Description

Database Stat

  • Database performance statistics: transactions, read and write operations, row activities, write conflicts, and deadlocks
  • Cluster-wide report, which can be viewed only in cluster mode

Load Profile

  • Cluster performance statistics: CPU time, DB time, logical or physical read operation, I/O performance, login and logout, load strength, and load performance
  • Cluster-wide report, which can be viewed only in cluster mode

Instance Efficiency Percentages

  • Cluster-level or node-level cache hit ratio
  • Cluster- or 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 cluster or node dimension.
  • Cluster- or 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 distribution information about the statements on 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
  • Cluster- or 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
  • Cluster- or 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
  • Cluster- or 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
  • Cluster- or node-wide report, which can be viewed in cluster or node mode