Help Center/ Data Warehouse Service/ Developer Guide/ Developer Guide (9.1.1.x)/ DWS GUC Parameters/ Statistics During the Database Running/ Performance Statistics
Updated on 2026-07-02 GMT+08:00
View PDF
Share

Performance Statistics

During database operations, issues such as lock contention and disk I/O overload can lead to performance bottlenecks. You can use the performance statistics parameters provided by DWS to quickly locate the performance issues. These parameters are used only to assist database administrators in rough analysis. They are similar to getrusage() in Linux.

log_parser_stats

Parameter description: Controls whether to record performance statistics about a parser in server logs.

Type: SUSET

Value range: Boolean

  • on indicates the function of recording performance statistics is enabled.
  • off indicates the function of recording performance statistics is disabled.

Default value: off

log_planner_stats

Parameter description: Controls whether to record performance statistics about a query optimizer in server logs.

Type: SUSET

Value range: Boolean

  • on indicates the function of recording performance statistics is enabled.
  • off indicates the function of recording performance statistics is disabled.

Default value: off

log_executor_stats

Parameter description: Controls whether to record performance statistics about an executor in server logs.

Type: SUSET

Value range: Boolean

  • on indicates the function of recording performance statistics is enabled.
  • off indicates the function of recording performance statistics is disabled.

Default value: off

log_statement_stats

Parameter description: Controls whether to record performance statistics about an entire statement in server logs.

Type: SUSET

Value range: Boolean

  • on indicates the function of recording performance statistics is enabled.
  • off indicates the function of recording performance statistics is disabled.

Default value: off

This parameter cannot be enabled together with log_parser_stats, log_planner_stats or log_executor_stats.

Parent Topic: Statistics During the Database Running