PGXC_WLM_OPERATOR_STATISTICS

PGXC_WLM_OPERATOR_STATISTICS displays the operator information of jobs being executed on CNs.

Only the system administrator or the preset role gs_role_read_all_stats can access this view.

**Table 1** **PGXC_WLM_OPERATOR_STATISTICS** columns
Name	Type	Description
queryid	bigint	Internal query_id used for statement execution.
pid	bigint	ID of the backend thread.
plan_node_id	integer	plan_node_id of the execution plan of a query.
plan_node_name	text	Name of the operator corresponding to 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 an operator. The unit is ms.
status	text	Execution status of the current operator. Its value can be finished or running.
query_dop	integer	DOP of the current operator.
estimated_rows	bigint	Number of rows estimated by the optimizer.
tuple_processed	bigint	Number of elements returned by the current operator.
min_peak_memory	integer	Minimum peak memory used by the current operator on all DNs. The unit is MB.
max_peak_memory	integer	Maximum peak memory used by the current operator on all DNs. The unit is MB.
average_peak_memory	integer	Average peak memory used by the current operator on all DNs. The unit is MB.
memory_skew_percent	integer	Memory usage skew of the current operator among DNs.
min_spill_size	integer	Minimum spilled data among all DNs when a spill occurs. The default value is 0. The unit is MB.
max_spill_size	integer	Maximum spilled data among all DNs when a spill occurs. The default value is 0. The unit is MB.
average_spill_size	integer	Average spilled data among all DNs when a spill occurs. The default value is 0. The unit is MB.
spill_skew_percent	integer	DN spill skew when a spill occurs.
min_cpu_time	bigint	Minimum execution time of the operator on all DNs. The unit is ms.
max_cpu_time	bigint	Maximum execution time of the operator on all DNs. The unit is ms.
total_cpu_time	bigint	Total execution time of the operator on all DNs. The unit is ms.
cpu_skew_percent	integer	Skew of the execution time among DNs.
warning	text	Warning. 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