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

GS_WLM_OPERATOR_STATISTICS

GS_WLM_OPERATOR_STATISTICS displays the operators of the jobs that are being executed by the current user.

Table 1 GS_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 unit is MB. The default value is 0.

max_spill_size

integer

Maximum spilled data among all DNs when a spill occurs. The unit is MB. The default value is 0.

average_spill_size

integer

Average spilled data among all DNs when a spill occurs. The unit is MB. The default value is 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. 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:

  1. Sort/SetOp/HashAgg/HashJoin spill
  2. Spill file size large than 256MB
  3. Broadcast size large than 100MB
  4. Early spill
  5. Spill times is greater than 3
  6. Spill on memory adaptive
  7. Hash table conflict