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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot