Help Center > > Developer Guide> Setting GUC Parameters> Statistics During the Database Running> Performance Statistics

Performance Statistics

Updated at: Jul 15, 2020 GMT+08:00

During the running of the database, the lock access, disk I/O operation, and invalid message process are involved. All these operations are the bottleneck of the database performance. The performance statistics method provided by DWS can facilitate the performance fault location.

Generating Performance Statistics Logs

Parameter description: For each query, the following four parameters control the performance statistics of corresponding modules recorded in the server log:

  • The og_parser_stats parameter controls the performance statistics of a parser recorded in the server log.
  • The log_planner_stats parameter controls the performance statistics of a query optimizer recorded in the server log.
  • The log_executor_stats parameter controls the performance statistics of an executor recorded in the server log.
  • The log_statement_stats parameter controls the performance statistics of the whole statement recorded in the server log.

All these parameters can only provide assistant analysis for administrators, which are similar to the getrusage() of the Linux OS.

Type: SUSET

  • log_statement_stats records the total statement statistics while other parameters only record statistics about each statement.
  • The log_statement_stats parameter cannot be enabled together with other parameters recording statistics about each statement.

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel