With the request analysis feature, you can diagnose the SQL health status of databases under a specified tenant within a selected time range.
Procedure
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, find the target instance, click the instance name, and go to the Overview page of the instance.
Click Diagnostics in the left-side navigation pane, and then select the Real-Time Diagnostics tab on the Diagnostics page.
At the bottom of the page, click the Request Analysis tab.
(Optional) Configure the filter conditions.
Time: You can view data in the last Past 5 Minutes, Past 30 Minutes, Past 1 Hour, or Past 6 Hour(s). You can also customize the time range, with a maximum of 15 days. However, note the following limitations:
- Maximum range limit: The selected time range must not exceed 24 hours.
- Minimum range limit:
- For data within 3 days: The selected time range must be at least 1 minute.
- For data from 3 to 7 days: The selected time range must be at least 5 minutes.
- For data beyond 7 days: The selected time range must be at least 20 minutes.
Database: Select any database in the current cluster.
SQL Type: Select the SQL type to be queried. You can select multiple types.
Click Query.
As shown in the preceding figure:
Execution Time Percentage: Shows the distribution of execution times of all SQL statements in the selected time range. The system divides the execution times into five ranges:
(0, 10]ms, which indicates the proportion of SQL statements with execution times greater than 0 ms and less than or equal to 10 ms. This range is displayed in blue.
(10, 100]ms, which indicates the proportion of SQL statements with execution times greater than 10 ms and less than or equal to 100 ms. This range is displayed in green.
(100, 500]ms, which indicates the proportion of SQL statements with execution times greater than 100 ms and less than or equal to 500 ms. This range is displayed in orange.
(0.5, 5]s, which indicates the proportion of SQL statements with execution times greater than 0.5 s and less than or equal to 5 s. This range is displayed in gray.
-
5s, which indicates the proportion of SQL statements with execution times greater than 5 s. This range is displayed in light blue.
Note
If a database has a higher proportion of execution times in the blue range, its SQL health is better. If the proportion of execution times in the gray and light blue ranges is higher, its SQL health is worse.
Number of executions: Shows the execution count of SQL statements in the selected time range.
Database Request Statistics: Shows the execution count, execution count percentage (%), average response time (ms), and execution trend of the database in the selected time range.
Table Request Statistics: Shows the execution count, execution count percentage (%), average response time (ms), and execution trend of tables in the selected time range.