Updated on 2023-10-23 GMT+08:00

GS_WLM_PLAN_OPERATOR_INFO

GS_WLM_PLAN_OPERATOR_INFO displays records about plan operator levels of completed jobs. The data is dumped from the kernel to the system catalog.

Table 1 GS_WLM_PLAN_OPERATOR_INFO 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, in 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