View the optimization history

This topic describes how to view the optimization history.

Procedure

1. Log in to the OceanBase Cloud console.

2. In the left-side navigation pane, click Instances.

3. In the instance list, find the target instance, click the instance name, and go to the Overview page of the instance.

4. Click Diagnostics in the left-side navigation pane, and then select the Real-Time Diagnostics tab on the Diagnostics page.

5. On the SQL tab, click View Optimization Records.

6. In the Optimization Records section, click Optimization History.

7. On the Optimization History tab, view information about the optimization operations you performed with the diagnostics feature, including: SQL Text , SQL ID , Tenant Name , Database Name , Operation Type , Operation Details , Task Start Time , Task End Time , and Status .

   Note

   • Find the optimization records marked with Aggregated and click the + sign on the left to view optimization operations in batches.
   • You can use the time selector in the upper right corner to filter the optimization records for the last 5 minutes, 30 minutes, 1 hour, 6 hours, 3 days, or other custom time periods.