Updated on 2025-09-22 GMT+08:00

WDR Information

Table 1 Contents of WDR

Item

Description

Database Stat

  • Database performance statistics: transactions, read and write operations, row activities, write conflicts, and deadlocks.
  • Database range report. This report can be queried in both cluster and node modes.

PDB Info

  • Displays PDB information in the current database.
  • The information includes the PDB logical ID, PDB name, PDB enabling status, PDB resource pool ID, and PDB access permission.

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 range report. This report can be queried in both cluster and node modes.
  • This report can be viewed only in non-database-level WDR reports.

Instance Efficiency Percentages

  • Database-level or node-level cache hit ratio.
  • Database/Node-wide report, which can be viewed in cluster or node mode.
  • This report can be viewed only in non-database-level WDR reports.

Top 10 Events by Total Wait Time

  • Most time-consuming event.
  • Node-wide report, which can be viewed in node mode.
  • This report can be viewed only in non-database-level WDR reports.

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.
  • This report can be viewed only in non-database-level WDR reports.

Host CPU

  • CPU usage of the host.
  • Node-wide report, which can be viewed in node mode.
  • This report can be viewed only in non-database-level WDR reports.

IO Profile

  • I/O usage in the database or node dimension.
  • Database/Node-wide report, which can be viewed in cluster or node mode.
  • This report can be viewed only in non-database-level WDR reports.

Memory Statistics

  • Kernel memory usage distribution.
  • Node-wide report, which can be viewed in node mode.
  • This report can be viewed only in non-database-level WDR reports.

Time Model

  • Time model data generated by running SQL statements on a node range.
  • Node-wide report, which can be viewed in node mode.
  • This report can be viewed only in non-database-level WDR reports.

SQL Statistics

  • SQL statement performance statistics are displayed in the following dimensions: total time, average time, lock waiting 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.
  • This report can be viewed only in non-database-level WDR reports.

For details, see "Waiting state 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 "System Catalogs and System Views > System Views > Other System Views > PG_THREAD_WAIT_STATUS" in the Developer Guide.

Cache IO Stats

  • I/O statistics on user tables and indexes.
  • Database/Node-wide report, which can be viewed in cluster or node mode.
  • This report can be viewed only in non-database-level WDR reports.

Utility status

  • Status information about the replication slot and background checkpoint.
  • Node-wide report, which can be viewed in node mode.
  • This report can be viewed only in non-database-level WDR reports.

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.
  • This report can be viewed only in non-database-level WDR reports.

SQL Detail

  • SQL statement text details.
  • Database/Node-wide report, which can be viewed in cluster or node mode.