HomeMogDBMogDB StackUqbar
v3.1

Documentation:v3.1

Supported Versions:

GS_WLM_PLAN_OPERATOR_INFO

GS_WLM_PLAN_OPERATOR_INFO displays records about plan operator levels of completed jobs. Data is dumped from the kernel to this 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, in 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
Copyright © 2011-2024 www.enmotech.com All rights reserved.