Reducing the CPU utilization of SQL statements is a common method for optimizing an OceanBase cluster. You can locate SQL statements with high CPU load by using the custom column feature on the TopSQL tab.
Click Custom Column. In the dialog box that appears, set Column Expression to @executions * @avgCpuTime, and set Column Name to TotalCpuTime.
The SQL statements on the tab are automatically sorted by the TotalCpuTime column so that you can quickly find the SQL statements with high CPU load.