GS_WLM_OPERATOR_INFO

GS_WLM_OPERATOR_INFO displays records about operators of completed jobs. The data is dumped from the kernel to the system catalog. If enable_resource_record is set to on, the system imports records from GS_WLM_SESSION_HISTORY to this system catalog every 3 minutes. You are not advised to enable this function, because it occupies storage space and affects performance. This system catalog can be queried by users with the sysadmin permission only in Postgres.

**Table 1** GS_WLM_OPERATOR_INFO columns
Name	Type	Description
queryid	bigint	Internal query ID used for statement execution
pid	bigint	Backend thread ID
plan_node_id	integer	Plan node ID of the execution plan of a query
plan_node_name	text	Name of the operator corresponding to the plan node ID
start_time	timestamp with time zone	Time when an operator starts to process the first data record
duration	bigint	Total execution time of the operator, in ms
query_dop	integer	DOP of the operator
estimated_rows	bigint	Number of rows estimated by the optimizer
tuple_processed	bigint	Number of elements returned by the operator
min_peak_memory	integer	Minimum peak memory used by the operator on all DNs, in MB
max_peak_memory	integer	Maximum peak memory used by the operator on all DNs, in MB
average_peak_memory	integer	Average peak memory used by the operator on all DNs, in MB
memory_skew_percent	integer	Memory usage skew of the operator among DNs
min_spill_size	integer	Minimum spilled data among all DNs when a spill occurs, in MB (default value: 0)
max_spill_size	integer	Maximum spilled data among all DNs when a spill occurs, in MB (default value: 0)
average_spill_size	integer	Average spilled data among all DNs when a spill occurs, in MB (default value: 0)
spill_skew_percent	integer	DN spill skew when a spill occurs
min_cpu_time	bigint	Minimum execution time of the operator on all DNs, in ms
max_cpu_time	bigint	Maximum execution time of the operator on all DNs, in ms
total_cpu_time	bigint	Total execution time of the operator on all DNs, in ms
cpu_skew_percent	integer	Skew of the execution time among DNs
warning	text	The following warnings are displayed: Sort/SetOp/HashAgg/HashJoin spill Spill file size large than 256MB Broadcast size large than 100MB Early spill Spill times is greater than 3 Spill on memory adaptive Hash table conflict