On the SQL tab of the diagnostics page in the ApsaraDB for OceanBase console, you can perform analysis and diagnostics for suspicious SQL statements, top SQL statements, and slow SQL statements.
SQL diagnostics
SQL statements supported by the SQL diagnostics feature are classified into the following types:
Suspicious SQL statements, which are SQL statements that meet the diagnostic criteria based on the diagnostic type, SQL syntax, execution history, and table structure.
Top SQL statements, which are SQL statements that take the longest time to execute.
Slow SQL statements, which are SQL statements whose execution time exceeds the specified threshold.
For more information, see Suspicious SQL statements, Top SQL statements, and Slow SQL statements.
SQL diagnostic details
You can click the SQL text in the diagnostic result to go to the details page. On this page, you can view the SQL text, optimization suggestion, SQL diagnostic details, SQL sampling details, SQL execution history, physical execution plan, SQL index, and advanced settings. For more information, see View the SQL diagnostic details in OceanBase Autonomy Service.