WDR Information

Table 1 lists the contents of a WDR.

**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 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. 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. 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. 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.