DEV Community 👩‍💻👨‍💻


Posted on

Easy maintenance of openGauss - DETAIL level diagnostic report

Diagnostic category

  1. Time Model

It is mainly used to evaluate the performance of the current system in the time dimension. Contains the time spent by the system at various stages: kernel time, CPU time, execution time, parsing time, compile time, query rewrite time, plan generation time, network time, IO time.

  1. SQL Statistics

Mainly used for the diagnosis of SQL statement performance problems. Contains normalized SQL performance metrics sorted on multiple dimensions: Elapsed Time, CPU Time, Rows Returned, Tuples Reads, Executions, Physical Reads, Logical Reads. The types of these metrics include: execution time, number of executions, row activity, Cache IO, etc.

  1. Wait Events

It is mainly used for detailed performance diagnosis of system critical resources and critical time. It includes the performance of all key events over a period of time, mainly the number of events and the time consumed.

  1. Cache IO Stats

Used to diagnose the performance of user tables and indexes. Contains all user tables, file reads and writes on indexes, and cache hits.

  1. Utility status

Diagnostics for diagnosing backend job performance. Contains the performance of backend operations such as page operations, replication, etc.

  1. Object stats

Used to diagnose the performance of database objects. Contains user tables, tables on indexes, index scan activities, insert, update, delete activities, number of valid rows, status of table maintenance operations, etc.

  1. Configuration settings

Used to judge whether the configuration is changed enough. A snapshot containing all current configuration parameters.

Top comments (0)

🌚 Life is too short to browse without dark mode