Updated on 2025-05-29 GMT+08:00

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.

Table 1 GS_WLM_PLAN_OPERATOR_HISTORY columns

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.