Purpose
gv$plan_cache_plan_explain displays the physical execution plans cached in the plan caches of all servers.
Note
This view supports only GET operations. To query information in this view, you must specify the IP, PORT, TENANT_ID, and PLAN_ID fields.
Related tables/views
oceanbase.__all_virtual_plan_cache_plan_explain
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| IP address | varchar(32) | NO | The IP address. |
| PORT | bigint(20) | NO | The port number. |
| PLAN_ID | bigint(20) | NO | The ID of the plan. |
| PLAN_DEPTH | bigint(20) | NO | The display depth of the operator. |
| PLAN_LINE_ID | bigint(20) | NO | The ID of the operator. |
| OPERATOR | varchar(128) | NO | The name of the operator. |
| NAME | varchar(128) | NO | The name of the table. |
| ROWS | bigint(20) | NO | The estimated number of rows in the result. |
| COST | bigint(20) | NO | The estimated cost. |
| PROPERTY | varchar(256) | NO | The information about the corresponding operator. |