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

GS_WLM_EC_OPERATOR_INFO

GS_WLM_EC_OPERATOR_INFO records operator information after an Extension Connector job ends. If the GUC parameter enable_resource_record is set to on, the system imports records from GS_WLM_EC_OPERATOR_HISTORY to this system catalog every 3 minutes. This operation occupies storage space and affects performance. Only users with the sysadmin permission can query this system catalog. The current feature is a lab feature. Contact Huawei technical support before using it.

Table 1 GS_WLM_EC_OPERATOR_INFO columns

Name

Type

Description

queryid

bigint

Internal query ID used for Extension Connector statement execution

plan_node_id

integer

Plan node ID of the execution plan of an Extension Connector operator

start_time

timestamp with time zone

Time when the Extension Connector operator starts to process the first data record

duration

bigint

Total execution time of the Extension Connector operator, in ms

tuple_processed

bigint

Number of elements returned by the Extension Connector operator

min_peak_memory

integer

Minimum peak memory used by the Extension Connector operator on all DNs, in MB

max_peak_memory

integer

Maximum peak memory used by the Extension Connector operator on all DNs, in MB

average_peak_memory

integer

Average peak memory used by the Extension Connector operator on all DNs, in MB

ec_status

text

Status of the Extension Connector job

ec_execute_datanode

text

Name of the DN executing the Extension Connector job

ec_dsn

text

DSN used by the Extension Connector job

ec_username

text

Username used by the Extension Connector job to access the remote cluster. This parameter is null if the remote cluster type is SPARK.

ec_query

text

Statement sent by the Extension Connector job to a remote cluster

ec_libodbc_type

text

Type of the unixODBC driver used by the Extension Connector job