Diagnostic category
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.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.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.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.Utility status
Diagnostics for diagnosing backend job performance. Contains the performance of backend operations such as page operations, replication, etc.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.Configuration settings
Used to judge whether the configuration is changed enough. A snapshot containing all current configuration parameters.
Latest comments (0)