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
|