HomeMogDBMogDB StackUqbar
v2.1

Documentation:v2.1

Supported Versions:

OPERATOR_HISTORY_TABLE

OPERATOR_HISTORY_TABLE displays records about operators of completed jobs. Data is dumped from the kernel to this system catalog.

Table 1 OPERATOR_HISTORY_TABLE 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
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 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
Copyright © 2011-2024 www.enmotech.com All rights reserved.