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

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