Purpose
gv$sql_plan_statistics displays the statistics about the physical execution plans in the whole cluster.
Related tables/views
oceanbase.__all_virtual_sql_plan_statistics
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| CON_ID | bigint(20) | NO | The ID of the tenant. |
| SVR_IP | varchar(32) | NO | The IP address. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| PLAN_ID | bigint(20) | NO | The ID of the physical plan. |
| OPERATION_ID | bigint(20) | N | The ID of the physical operator. |
| EXECUTIONS | bigint(20) | NO | The total number of times the plan has been executed. |
| OUTPUT_ROWS | bigint(20) | NO | The total number of rows that have been returned by the executions of the operator. |
| INPUT_ROWS | bigint(20) | NO | The total number of input rows that have been fed to the operator. |
| RESCAN_TIMES | bigint(20) | NO | The total number of rescans. |
| BUFFER_GETS | bigint(20) | NO | The number of buffer hits. |
| DISK_READS | bigint(20) | NO | The total number of physical disk reads. |
| DISK_WRITES | bigint(20) | NO | The total number of physical disk writes. |
| ELAPSED_TIME | bigint(20) | NO | The total amount of time consumed by the executions of the operator. |
| EXTEND_INFO1 | varchar(65535) | NO | At present, this field is not used. |
| EXTEND_INFO2 | varchar(65535) | NO | At present, this field is not used. |