OPERATOR_RUNTIME

OPERATOR_RUNTIME displays information about operators of the jobs that are being executed by the current user.

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 (unit: 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
Feedback
编组 3备份
    openGauss 2024-10-13 00:54:14
    cancel