This topic describes how to view the detailed execution information about a plan.
Applicability
This topic applies only to OceanBase Cloud Platform (OCP) Enterprise Edition. OCP Community Edition does not support this feature.
View a plan execution task
You can view the execution details of a plan in the Executing, Failed, or Completed state.
Prerequisites
To view a plan execution task, make sure that you have the following permissions:
- Resource Permissions: Cluster read-only or Tenant Read-only permission
- Menu Permissions: Permission on the Plan Management menu of O&M management
Procedure
Log in to the OCP console.
In the left-side navigation pane, choose O&M Management > Plan Management. The Plans tab appears.
Find the target plan and click View Task in the Actions column.
The alert details page corresponding to the plan event appears, where you can view the execution information about the plan. For more information, see Execute the alert clearance plan.
View SQL information
For an SQL-related plan, you can view the SQL information about the corresponding event if the plan is in the Pending, Executing, Failed, or Completed state.
Prerequisites
To view SQL information, make sure that you have the following permissions:
- Resource Permissions: Cluster Read-only permission
- Menu Permissions: Permission on the Plan Management menu of O&M Management
- Menu Permissions: Permission on the Real-time Diagnostics menu of OceanBase Autonomy Service
Procedure
Log in to the OCP console.
In the left-side navigation pane, choose O&M Management > Plan Management. The Plans tab appears.
Find the target plan and click View SQL in the Actions column.
The SQL Details page appears, where you can view SQL information. For more information, see View details of an SQL statement.