Updated on 2024-06-03 GMT+08:00

OPERATOR_RUNTIME

OPERATOR_RUNTIME displays information about operators of the jobs that are being executed by the current user, as described in Table 1.

Table 1 OPERATOR_RUNTIME columns

Name

Type

Description

queryid

bigint

Internal query ID used for statement execution

pid

bigint

Thread ID of the backend

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 the operator starts to process the first data record

duration

bigint

Total execution time of the operator, in ms

status

text

Execution status of the current operator, which can be finished or running.

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 database nodes (unit: MB)

max_peak_memory

integer

Maximum peak memory used by the operator on database nodes (unit: MB)

average_peak_memory

integer

Average peak memory used by the operator on database nodes (unit: MB)

memory_skew_percent

integer

Memory usage skew of the operator among database nodes

min_spill_size

integer

Minimum spilled data among database nodes when a spill occurs (unit: MB) (default value: 0)

max_spill_size

integer

Maximum spilled data among database nodes when a spill occurs (unit: MB) (default value: 0)

average_spill_size

integer

Average spilled data among database nodes when a spill occurs (unit: MB) (default value: 0)

spill_skew_percent

integer

Database node spill skew when a spill occurs

min_cpu_time

bigint

Minimum execution time of the operator on database nodes (unit: ms).

max_cpu_time

bigint

Maximum execution time of the operator on database nodes (unit: ms).

total_cpu_time

bigint

Total execution time of the operator on database nodes (unit: ms).

cpu_skew_percent

integer

Execution time skew among database nodes

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