GS_WLM_PLAN_OPERATOR_HISTORY
GS_WLM_PLAN_OPERATOR_HISTORY displays the execution plan operator-level records of the current user on the primary database node after the job is complete.
Contact Huawei technical support if the view displays no data.
| Name | Type | Description |
|---|---|---|
| datname | name | Name of the database where the collected plan information is located. |
| queryid | bigint | Internal query ID used for statement execution. |
| plan_node_id | integer | Plan node ID of the execution plan. |
| startup_time | bigint | Time when the operator starts to process the first data record. |
| total_time | bigint | Total execution time of the operator (unit: ms). |
| actual_rows | bigint | Number of rows that are actually executed. |
| max_peak_memory | integer | Maximum peak memory used by the operator on database nodes (unit: MB). |
| query_dop | integer | DOP of the operator. |
| parent_node_id | integer | Parent node ID of the operator. |
| left_child_id | integer | Left child node ID of the operator. |
| right_child_id | integer | Right child node ID of the operator. |
| operation | text | Name of the operation performed by the operator. |
| orientation | text | Alignment mode of the operator. |
| strategy | text | Implementation method of the operator. |
| options | text | Selection mode of the operator. |
| condition | text | Filter criteria of the operator. |
| projection | text | Mapping relationship of the operator. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
