mysql> EXPLAIN EXTENDED insert /*+ enable_parallel_dml parallel(16) no_direct */ into tmp1 select * from sbtest1; +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Query Plan | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ================================================================================ | | |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| | | -------------------------------------------------------------------------------- | | |0 |OPTIMIZER STATS MERGE | |10000000|82029323 | | | |1 |+-PX COORDINATOR | |10000000|82002854 | | | |2 | +-EXCHANGE OUT DISTR |:EX10001 |10000000|68173636 | | | |3 | +-INSERT | |10000000|66229594 | | | |4 | +-OPTIMIZER STATS GATHER | |10000000|2902743 | | | |5 | +-EXCHANGE IN DISTR | |10000000|2901089 | | | |6 | +-EXCHANGE OUT DISTR (HASH)|:EX10000 |10000000|2036763 | | | |7 | +-SUBPLAN SCAN |ANONYMOUS_VIEW1|10000000|92720 | | | |8 | +-PX BLOCK ITERATOR | |10000000|91066 | | | |9 | +-TABLE FULL SCAN |sbtest1 |10000000|91066 | | | ================================================================================ | | Outputs & filters: | | ------------------------------------- | | 0 - output(nil), filter(nil), rowset=256 | | 1 - output([column_conv(INT,PS:(11,0),NOT NULL,ANONYMOUS_VIEW1.id(0x7f24dd828410))(0x7f24dd829580)], [column_conv(INT,PS:(11,0),NOT NULL,ANONYMOUS_VIEW1.k(0x7f24dd828860))(0x7f24dd8314b0)], | | [column_conv(CHAR,utf8mb4_bin,length:120,NOT NULL,ANONYMOUS_VIEW1.c(0x7f24dd828cb0))(0x7f24dd8393e0)], [column_conv(CHAR,utf8mb4_bin,length:60,NOT NULL, | | ANONYMOUS_VIEW1.pad(0x7f24dd829100))(0x7f24dd853f90)]), filter(nil), rowset=256 | | 2 - output([column_conv(INT,PS:(11,0),NOT NULL,ANONYMOUS_VIEW1.id(0x7f24dd828410))(0x7f24dd829580)], [column_conv(INT,PS:(11,0),NOT NULL,ANONYMOUS_VIEW1.k(0x7f24dd828860))(0x7f24dd8314b0)], | | [column_conv(CHAR,utf8mb4_bin,length:120,NOT NULL,ANONYMOUS_VIEW1.c(0x7f24dd828cb0))(0x7f24dd8393e0)], [column_conv(CHAR,utf8mb4_bin,length:60,NOT NULL, | | ANONYMOUS_VIEW1.pad(0x7f24dd829100))(0x7f24dd853f90)]), filter(nil), rowset=256 | | dop=16 | | 3 - output([column_conv(INT,PS:(11,0),NOT NULL,ANONYMOUS_VIEW1.id(0x7f24dd828410))(0x7f24dd829580)], [column_conv(INT,PS:(11,0),NOT NULL,ANONYMOUS_VIEW1.k(0x7f24dd828860))(0x7f24dd8314b0)], | | [column_conv(CHAR,utf8mb4_bin,length:120,NOT NULL,ANONYMOUS_VIEW1.c(0x7f24dd828cb0))(0x7f24dd8393e0)], [column_conv(CHAR,utf8mb4_bin,length:60,NOT NULL, | | ANONYMOUS_VIEW1.pad(0x7f24dd829100))(0x7f24dd853f90)]), filter(nil) | | columns([{tmp1: ({tmp1: (tmp1.id(0x7f24dd811cf0), tmp1.k(0x7f24dd812140), tmp1.c(0x7f24dd812590), tmp1.pad(0x7f24dd8129e0))})}]), partitions(p0), | | | | column_values([column_conv(INT,PS:(11,0),NOT NULL,ANONYMOUS_VIEW1.id(0x7f24dd828410))(0x7f24dd829580)], [column_conv(INT,PS:(11,0),NOT NULL,ANONYMOUS_VIEW1.k(0x7f24dd828860))(0x7f24dd8314b0)], | | [column_conv(CHAR,utf8mb4_bin,length:120,NOT NULL,ANONYMOUS_VIEW1.c(0x7f24dd828cb0))(0x7f24dd8393e0)], [column_conv(CHAR,utf8mb4_bin,length:60,NOT NULL, | | ANONYMOUS_VIEW1.pad(0x7f24dd829100))(0x7f24dd853f90)]) | | 4 - output([column_conv(INT,PS:(11,0),NOT NULL,ANONYMOUS_VIEW1.id(0x7f24dd828410))(0x7f24dd829580)], [column_conv(INT,PS:(11,0),NOT NULL,ANONYMOUS_VIEW1.k(0x7f24dd828860))(0x7f24dd8314b0)], | | [column_conv(CHAR,utf8mb4_bin,length:120,NOT NULL,ANONYMOUS_VIEW1.c(0x7f24dd828cb0))(0x7f24dd8393e0)], [column_conv(CHAR,utf8mb4_bin,length:60,NOT NULL, | | ANONYMOUS_VIEW1.pad(0x7f24dd829100))(0x7f24dd853f90)]), filter(nil), rowset=256 | | 5 - output([column_conv(INT,PS:(11,0),NOT NULL,ANONYMOUS_VIEW1.id(0x7f24dd828410))(0x7f24dd829580)], [ANONYMOUS_VIEW1.k(0x7f24dd828860)], [ANONYMOUS_VIEW1.c(0x7f24dd828cb0)], | [0/1831] | [ANONYMOUS_VIEW1.pad(0x7f24dd829100)]), filter(nil), rowset=256 | | 6 - output([column_conv(INT,PS:(11,0),NOT NULL,ANONYMOUS_VIEW1.id(0x7f24dd828410))(0x7f24dd829580)], [ANONYMOUS_VIEW1.k(0x7f24dd828860)], [ANONYMOUS_VIEW1.c(0x7f24dd828cb0)], | | [ANONYMOUS_VIEW1.pad(0x7f24dd829100)]), filter(nil), rowset=256 | | (#keys=1, [column_conv(INT,PS:(11,0),NOT NULL,ANONYMOUS_VIEW1.id(0x7f24dd828410))(0x7f24dd829580)]), dop=16 | | 7 - output([ANONYMOUS_VIEW1.id(0x7f24dd828410)], [ANONYMOUS_VIEW1.k(0x7f24dd828860)], [ANONYMOUS_VIEW1.c(0x7f24dd828cb0)], [ANONYMOUS_VIEW1.pad(0x7f24dd829100)]), filter(nil), rowset=256 | | access([ANONYMOUS_VIEW1.id(0x7f24dd828410)], [ANONYMOUS_VIEW1.k(0x7f24dd828860)], [ANONYMOUS_VIEW1.c(0x7f24dd828cb0)], [ANONYMOUS_VIEW1.pad(0x7f24dd829100)]) | | 8 - output([sbtest1.id(0x7f24dd826f80)], [sbtest1.k(0x7f24dd8273d0)], [sbtest1.c(0x7f24dd827820)], [sbtest1.pad(0x7f24dd827c70)]), filter(nil), rowset=256 | | 9 - output([sbtest1.id(0x7f24dd826f80)], [sbtest1.k(0x7f24dd8273d0)], [sbtest1.c(0x7f24dd827820)], [sbtest1.pad(0x7f24dd827c70)]), filter(nil), rowset=256 | | access([sbtest1.id(0x7f24dd826f80)], [sbtest1.k(0x7f24dd8273d0)], [sbtest1.c(0x7f24dd827820)], [sbtest1.pad(0x7f24dd827c70)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([sbtest1.id(0x7f24dd826f80)]), range(MIN ; MAX)always true | | Used Hint: | | ------------------------------------- | | /*+ | | | | PARALLEL(16) | | ENABLE_PARALLEL_DML | | NO_DIRECT | | */ | | Qb name trace: | | ------------------------------------- | | stmt_id:0, stmt_type:T_EXPLAIN | | stmt_id:1, INS$1 | | stmt_id:2, SEL$1 | | Outline Data: | | ------------------------------------- | | /*+ | | BEGIN_OUTLINE_DATA | | PARALLEL(@"SEL$1" "sbtest"."sbtest1"@"SEL$1" 16) | | FULL(@"SEL$1" "sbtest"."sbtest1"@"SEL$1") | | PARALLEL(16) | | ENABLE_PARALLEL_DML | | OPTIMIZER_FEATURES_ENABLE('4.3.5.0') | | NO_DIRECT | | END_OUTLINE_DATA | | */ | | Optimization Info: | | ------------------------------------- | | sbtest1: | | table_rows:6111888 | | physical_range_rows:10000000 | | logical_range_rows:10000000 | | index_back_rows:0 | | output_rows:10000000 | | table_dop:16 | | dop_method:Global DOP | | avaiable_index_name:[k_1, sbtest1] | | pruned_index_name:[k_1] | | stats info:[version=2025-01-20 17:22:24.528913, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | Plan Type: | | DISTRIBUTED | | Note: | | Degree of Parallelism is 16 because of hint | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 91 rows in set (0.01 sec)