Neoview SQL Reference Manual (R2.4)

------------------------------------------------------------------ NODE LISTING
ROOT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 5
EST_OPER_COST ............ 0.0001
EST_TOTAL_COST ........... 0.0092
cpu_cost ............... 0.0003
io_cost ................ 0.0089
msg_cost ............... 0
idle_cost .............. 1.2005
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
statement_index ........ 0
affinity_value 1,141,615,548
xn_access_mode ......... read_only
xn_autoabort_interval 0
plan_version ....... 2,020
SCHEMA ................. TPCH2X_CAT.TPCH2X_SCH
select_list ............ TPCH2X_CAT.TPCH2X_SCH.REGION.R_REGIONKEY,
TPCH2X_CAT.TPCH2X_SCH.REGION.R_NAME,
TPCH2X_CAT.TPCH2X_SCH.REGION.R_COMMENT
SPLIT_TOP ================================= SEQ_NO 3 ONLY CHILD 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 5
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.0092
cpu_cost ............... 0.0003
io_cost ................ 0.0089
msg_cost ............... 0
idle_cost .............. 1.1025
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
parent_processes ....... 1
child_processes ....... 64
parent_partitioning_fun grouped 1 to 64,PAPA with 64 PA(s),
exactly 1 partition
child_partitioning_func hash2 partitioned 64 ways on
(TPCH2X_CAT.TPCH2X_SCH.REGION.R_REGIONKEY)
bottom_node_map ........ (\SQA0101:0-15, \SQA0102:0-15, \SQA0103:0-15,
\SQA0104:0-15)
PARTITION_ACCESS ========================== SEQ_NO 2 ONLY CHILD 1
REQUESTS_IN .............. 1
ROWS_OUT ................. 5
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.0092
cpu_cost ............... 0.0003
io_cost ................ 0.0089
msg_cost ............... 0
idle_cost .............. 1.1025
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
buffer_size ....... 31,000
record_length ........ 184
space_usage ............ 8:32:100:144
bottom_partitioning_fun logphys partitioned(grouping, PAPA with 64 PA(s),
log=exactly 1 partition,
phys=hash2 partitioned 64 ways on
(TPCH2X_CAT.TPCH2X_SCH.REGION.R_REGIONKEY))
bottom_node_map ........ (\SQA0101:0-15, \SQA0102:0-15, \SQA0103:0-15,
\SQA0104:0-15)
begin_part_no_expr ..... \:_sys_hostVarPAPartNo_1539575856
end_part_no_expr ....... \:_sys_hostVarPAPartNo_1539575856
EXPLAIN Statement 125