explain extended -> SELECT -> a.order_id, -> a.use_type, -> ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND -> (h.sensi_flag is null OR h.sensi_flag in (1,1000))) unfinished_count, -> ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND -> h.sensi_flag in (2,96,97) ) sensi_count, -> ( SELECT COUNT( 1 ) FROM t_order_file g,t_file h WHERE g.order_id = a.order_id AND h.file_id = g.file_id AND -> h.sensi_flag in (98,99)) black_count, -> u.censor_flag,u.sensi_handle_flag -> FROM -> t_order a -> LEFT JOIN t_set s ON a.set_id = s.set_id -> LEFT JOIN t_set_security_policy t on s.set_id = t.set_id -> LEFT JOIN t_security_policy u on t.policy_id = u.policy_id -> WHERE -> a.state_date > DATE_ADD(now(),INTERVAL - 3 HOUR) and a.r_tenant_id = 'woqu' -> AND a.state_date < DATE_ADD(now(),INTERVAL - 60 SECOND) -> AND a.state = '00' -> AND a.checked_flag is null; +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Query Plan | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ===================================================================================== | | |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| | | ------------------------------------------------------------------------------------- | | |0 |SUBPLAN FILTER | |1 |15984800 | | | |1 |├─HASH OUTER JOIN | |1 |52826 | | | |2 |│ ├─NESTED-LOOP OUTER JOIN | |1 |52823 | | | |3 |│ │ ├─PX COORDINATOR | |1 |52802 | | | |4 |│ │ │ └─EXCHANGE OUT DISTR |:EX10001 |1 |52802 | | | |5 |│ │ │ └─NESTED-LOOP OUTER JOIN | |1 |52801 | | | |6 |│ │ │ ├─EXCHANGE IN DISTR | |1 |52789 | | | |7 |│ │ │ │ └─EXCHANGE OUT DISTR (BC2HOST)|:EX10000 |1 |52788 | | | |8 |│ │ │ │ └─TABLE RANGE SCAN |a(idx_10) |1 |52786 | | | |9 |│ │ │ └─TABLE GET |s |1 |16 | | | |10|│ │ └─TABLE GET |t(udx_set_id) |1 |27 | | | |11|│ └─TABLE FULL SCAN |u |6 |3 | | | |12|├─PX COORDINATOR | |1 |15840441 | | | |13|│ └─EXCHANGE OUT DISTR |:EX20001 |1 |15840441 | | | |14|│ └─SCALAR GROUP BY | |1 |15840440 | | | |15|│ └─NESTED-LOOP JOIN | |6 |15840440 | | | |16|│ ├─EXCHANGE IN DISTR | |501475 |634902 | | | |17|│ │ └─EXCHANGE OUT DISTR (BC2HOST) |:EX20000 |501475 |448679 | | | |18|│ │ └─TABLE RANGE SCAN |h(i_sensi_flag)|501475 |31041 | | | |19|│ └─TABLE RANGE SCAN |g(idx_4) |1 |30 | | | |20|├─PX COORDINATOR | |1 |34763 | | | |21|│ └─EXCHANGE OUT DISTR |:EX30001 |1 |34763 | | | |22|│ └─SCALAR GROUP BY | |1 |34763 | | | |23|│ └─NESTED-LOOP JOIN | |6 |34762 | | | |24|│ ├─EXCHANGE IN DISTR | |1100 |1409 | | | |25|│ │ └─EXCHANGE OUT DISTR (BC2HOST) |:EX30000 |1100 |1000 | | | |26|│ │ └─TABLE RANGE SCAN |h(i_sensi_flag)|1100 |84 | | | |27|│ └─TABLE RANGE SCAN |g(idx_4) |1 |30 | | | |28|└─PX COORDINATOR | |1 |55577 | | | |29| └─EXCHANGE OUT DISTR |:EX40001 |1 |55577 | | | |30| └─SCALAR GROUP BY | |1 |55576 | | | |31| └─NESTED-LOOP JOIN | |6 |55576 | | | |32| ├─EXCHANGE IN DISTR | |1760 |2210 | | | |33| │ └─EXCHANGE OUT DISTR (BC2HOST) |:EX40000 |1760 |1557 | | | |34| │ └─TABLE RANGE SCAN |h(i_sensi_flag)|1760 |91 | | | |35| └─TABLE RANGE SCAN |g(idx_4) |1 |30 | | | ===================================================================================== | | Outputs & filters: | | ------------------------------------- | | 0 - output([a.order_id(0x7fd106e3df00)], [a.use_type(0x7fd106e3e250)], [subquery(1)(0x7fd106e3e3f0)], [subquery(2)(0x7fd106e67490)], [subquery(3)(0x7fd106e7c890)], | | [u.censor_flag(0x7fd106ea4e30)], [u.sensi_handle_flag(0x7fd106ea5180)]), filter(nil), rowset=256 | | exec_params_([a.order_id(0x7fd106e3df00)(:0(0x7fd106e653f0))], [a.order_id(0x7fd106e3df00)(:1(0x7fd106e7aeb0))], [a.order_id(0x7fd106e3df00)(:2(0x7fd106ea33f0))]), | | onetime_exprs_(nil), init_plan_idxs_(nil), use_batch=false | | 1 - output([a.order_id(0x7fd106e3df00)], [a.use_type(0x7fd106e3e250)], [u.censor_flag(0x7fd106ea4e30)], [u.sensi_handle_flag(0x7fd106ea5180)]), filter(nil), rowset=256 | | equal_conds([t.policy_id(0x7fd106e3a4e0) = u.policy_id(0x7fd106e3a670)(0x7fd106e3a390)]), other_conds(nil) | | 2 - output([a.order_id(0x7fd106e3df00)], [a.use_type(0x7fd106e3e250)], [t.policy_id(0x7fd106e3a4e0)]), filter(nil), rowset=256 | | conds(nil), nl_params_([s.set_id(0x7fd106e36ff0)(:4(0x7fd31f2a01a0))]), use_batch=true | | 3 - output([a.order_id(0x7fd106e3df00)], [a.use_type(0x7fd106e3e250)], [s.set_id(0x7fd106e36ff0)]), filter(nil), rowset=256 | | 4 - output([a.order_id(0x7fd106e3df00)], [a.use_type(0x7fd106e3e250)], [s.set_id(0x7fd106e36ff0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 5 - output([a.order_id(0x7fd106e3df00)], [a.use_type(0x7fd106e3e250)], [s.set_id(0x7fd106e36ff0)]), filter(nil), rowset=256 | | conds(nil), nl_params_([a.set_id(0x7fd106e36e60)(:3(0x7fd31f287ba0))]), use_batch=true | | 6 - output([a.order_id(0x7fd106e3df00)], [a.use_type(0x7fd106e3e250)], [a.set_id(0x7fd106e36e60)]), filter(nil), rowset=256 | | 7 - output([a.order_id(0x7fd106e3df00)], [a.use_type(0x7fd106e3e250)], [a.set_id(0x7fd106e36e60)]), filter(nil), rowset=256 | | is_single, dop=1 | | 8 - output([a.order_id(0x7fd106e3df00)], [a.set_id(0x7fd106e36e60)], [a.use_type(0x7fd106e3e250)]), filter([a.state_date(0x7fd106e3b370) > date_add(current_timestamp()(0x7fd106e3ad60), | | cast(-3(0x7fd106e3aea0), VARCHAR(1048576))(0x7fd106e3b5e0), 3)(0x7fd106e3abf0)(0x7fd106e3b220)], [a.checked_flag(0x7fd106e3dac0) IS NULL(0x7fd106e3d970)], | | [a.r_tenant_id(0x7fd106e3bef0) = 'woqu'(0x7fd106e3bc50)(0x7fd106e3bda0)], [a.state_date(0x7fd106e3b370) < date_add(current_timestamp()(0x7fd106e3ad60), | | cast(-60(0x7fd106e3c5f0), VARCHAR(1048576))(0x7fd106e3cac0), 1)(0x7fd106e3c340)(0x7fd106e3c970)]), rowset=256 | | access([a.order_id(0x7fd106e3df00)], [a.set_id(0x7fd106e36e60)], [a.state_date(0x7fd106e3b370)], [a.r_tenant_id(0x7fd106e3bef0)], [a.checked_flag(0x7fd106e3dac0)], | | [a.use_type(0x7fd106e3e250)]), partitions(p0) | | is_index_back=true, is_global_index=false, filter_before_indexback[true,false,false,true], | | range_key([a.state(0x7fd106e3d3d0)], [a.exec_print_flag(0x7fd106f725d0)], [a.use_type(0x7fd106e3e250)], [a.print_mode(0x7fd106f72760)], [a.state_date(0x7fd106e3b370)], | | [a.order_id(0x7fd106e3df00)]), range(00,MIN,MIN,MIN,MIN,MIN ; 00,MAX,MAX,MAX,MAX,MAX), | | range_cond([a.state(0x7fd106e3d3d0) = '00'(0x7fd106e3d130)(0x7fd106e3d280)]) | | 9 - output([s.set_id(0x7fd106e36ff0)]), filter(nil), rowset=256 | | access([GROUP_ID(0x7fcff6f257c0)], [s.set_id(0x7fd106e36ff0)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([s.set_id(0x7fd106e36ff0)]), range(MIN ; MAX), | | range_cond([:3(0x7fd31f287ba0) = s.set_id(0x7fd106e36ff0)(0x7fd31f287d10)]), is_fast_range = true | | 10 - output([t.policy_id(0x7fd106e3a4e0)]), filter(nil), rowset=256 | | access([GROUP_ID(0x7fcff6f258c0)], [t.id(0x7fd106ea7680)], [t.policy_id(0x7fd106e3a4e0)]), partitions(p0) | | is_index_back=true, is_global_index=false, | | range_key([t.set_id(0x7fd106e399f0)], [t.shadow_pk_0(0x7fd31f25e3d0)]), range(MIN ; MAX), | | range_cond([:4(0x7fd31f2a01a0) = t.set_id(0x7fd106e399f0)(0x7fd31f2a0310)]), is_fast_range = true | | 11 - output([u.policy_id(0x7fd106e3a670)], [u.censor_flag(0x7fd106ea4e30)], [u.sensi_handle_flag(0x7fd106ea5180)]), filter(nil), rowset=256 | | access([u.policy_id(0x7fd106e3a670)], [u.censor_flag(0x7fd106ea4e30)], [u.sensi_handle_flag(0x7fd106ea5180)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([u.policy_id(0x7fd106e3a670)]), range(MIN ; MAX)always true | | 12 - output([T_FUN_COUNT(*)(0x7fd106e670d0)]), filter(nil), rowset=256 | | 13 - output([T_FUN_COUNT(*)(0x7fd106e670d0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 14 - output([T_FUN_COUNT(*)(0x7fd106e670d0)]), filter(nil), rowset=256 | | group(nil), agg_func([T_FUN_COUNT(*)(0x7fd106e670d0)]) | | 15 - output(nil), filter(nil), rowset=256 | | conds(nil), nl_params_([h.file_id(0x7fd106e65b20)(:7(0x7fd25d65e9a0))]), use_batch=true | | 16 - output([h.file_id(0x7fd106e65b20)]), filter(nil), rowset=256 | | 17 - output([h.file_id(0x7fd106e65b20)]), filter(nil), rowset=256 | | is_single, dop=1 | | 18 - output([h.file_id(0x7fd106e65b20)]), filter(nil), rowset=256 | | access([h.file_id(0x7fd106e65b20)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([h.sensi_flag(0x7fd106e66c80)], [h.upload_time(0x7fd31f3e74c0)], [h.file_id(0x7fd106e65b20)]), range(NULL,MIN,MIN ; NULL,MAX,MAX), (1,MIN, | | MIN ; 1,MAX,MAX), (1000,MIN,MIN ; 1000,MAX,MAX), | | range_cond([h.sensi_flag(0x7fd106e66c80) IS NULL(0x7fd106e66440) OR h.sensi_flag(0x7fd106e66c80) IN (1(0x7fd106e669c0), 1000(0x7fd106e66b10))(0x7fd106eb33e0)(0x7fd106e66590)(0x7fd106e65ff0)]) | | 19 - output(nil), filter([g.order_id(0x7fd106e65260) = :0(0x7fd106e653f0)(0x7fd106e65110)]), rowset=256 | | access([GROUP_ID(0x7fcff6f259c0)], [g.order_file_id(0x7fd106ea69f0)], [g.order_id(0x7fd106e65260)]), partitions(p0) | | is_index_back=true, is_global_index=false, filter_before_indexback[false], | | range_key([g.file_id(0x7fd106e65cb0)], [g.order_file_id(0x7fd106ea69f0)]), range(MIN ; MAX), | | range_cond([:7(0x7fd25d65e9a0) = g.file_id(0x7fd106e65cb0)(0x7fd25d65eb10)]), is_fast_range = true | | 20 - output([T_FUN_COUNT(*)(0x7fd106e7c4d0)]), filter(nil), rowset=256 | | 21 - output([T_FUN_COUNT(*)(0x7fd106e7c4d0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 22 - output([T_FUN_COUNT(*)(0x7fd106e7c4d0)]), filter(nil), rowset=256 | | group(nil), agg_func([T_FUN_COUNT(*)(0x7fd106e7c4d0)]) | | 23 - output(nil), filter(nil), rowset=256 | | conds(nil), nl_params_([h.file_id(0x7fd106e7b5e0)(:9(0x7fd64ac1cda0))]), use_batch=true | | 24 - output([h.file_id(0x7fd106e7b5e0)]), filter(nil), rowset=256 | | 25 - output([h.file_id(0x7fd106e7b5e0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 26 - output([h.file_id(0x7fd106e7b5e0)]), filter(nil), rowset=256 | | access([h.file_id(0x7fd106e7b5e0)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([h.sensi_flag(0x7fd106e7c250)], [h.upload_time(0x7fd25d7ab350)], [h.file_id(0x7fd106e7b5e0)]), range(2,MIN,MIN ; 2,MAX,MAX), (96,MIN,MIN | | ; 96,MAX,MAX), (97,MIN,MIN ; 97,MAX,MAX), | | range_cond([h.sensi_flag(0x7fd106e7c250) IN (2(0x7fd106e7be40), 96(0x7fd106e7bf90), 97(0x7fd106e7c0e0))(0x7fd106eb3530)(0x7fd106e7ba10)]) | | 27 - output(nil), filter([g.order_id(0x7fd106e7ad20) = :1(0x7fd106e7aeb0)(0x7fd106e7abd0)]), rowset=256 | | access([GROUP_ID(0x7fcff6f25f60)], [g.order_file_id(0x7fd106ea6e20)], [g.order_id(0x7fd106e7ad20)]), partitions(p0) | | is_index_back=true, is_global_index=false, filter_before_indexback[false], | | range_key([g.file_id(0x7fd106e7b770)], [g.order_file_id(0x7fd106ea6e20)]), range(MIN ; MAX), | | range_cond([:9(0x7fd64ac1cda0) = g.file_id(0x7fd106e7b770)(0x7fd64ac1cf10)]), is_fast_range = true | | 28 - output([T_FUN_COUNT(*)(0x7fd106ea48c0)]), filter(nil), rowset=256 | | 29 - output([T_FUN_COUNT(*)(0x7fd106ea48c0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 30 - output([T_FUN_COUNT(*)(0x7fd106ea48c0)]), filter(nil), rowset=256 | | group(nil), agg_func([T_FUN_COUNT(*)(0x7fd106ea48c0)]) | | 31 - output(nil), filter(nil), rowset=256 | | conds(nil), nl_params_([h.file_id(0x7fd106ea3b20)(:11(0x7fd64adccfe0))]), use_batch=true | | 32 - output([h.file_id(0x7fd106ea3b20)]), filter(nil), rowset=256 | | 33 - output([h.file_id(0x7fd106ea3b20)]), filter(nil), rowset=256 | | is_single, dop=1 | | 34 - output([h.file_id(0x7fd106ea3b20)]), filter(nil), rowset=256 | | access([h.file_id(0x7fd106ea3b20)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([h.sensi_flag(0x7fd106ea4640)], [h.upload_time(0x7fd64ad6b440)], [h.file_id(0x7fd106ea3b20)]), range(98,MIN,MIN ; 98,MAX,MAX), (99,MIN,MIN | | ; 99,MAX,MAX), | | range_cond([h.sensi_flag(0x7fd106ea4640) IN (98(0x7fd106ea4380), 99(0x7fd106ea44d0))(0x7fd106eb3680)(0x7fd106ea3f50)]) | | 35 - output(nil), filter([g.order_id(0x7fd106ea3260) = :2(0x7fd106ea33f0)(0x7fd106ea3110)]), rowset=256 | | access([GROUP_ID(0x7fcff6f26500)], [g.order_file_id(0x7fd106ea7250)], [g.order_id(0x7fd106ea3260)]), partitions(p0) | | is_index_back=true, is_global_index=false, filter_before_indexback[false], | | range_key([g.file_id(0x7fd106ea3cb0)], [g.order_file_id(0x7fd106ea7250)]), range(MIN ; MAX), | | range_cond([:11(0x7fd64adccfe0) = g.file_id(0x7fd106ea3cb0)(0x7fd64adcd150)]), is_fast_range = true | | Used Hint: | | ------------------------------------- | | /*+ | | | | */ | | Qb name trace: | | ------------------------------------- | | stmt_id:0, stmt_type:T_EXPLAIN | | stmt_id:1, SEL$1 | | stmt_id:2, SEL$2 > SEL$B15E051B | | stmt_id:3, SEL$3 > SEL$9C7D1284 | | stmt_id:4, SEL$4 > SEL$94AF091B | | Outline Data: | | ------------------------------------- | | /*+ | | BEGIN_OUTLINE_DATA | | PQ_SUBQUERY(@"SEL$1" ("SEL$B15E051B" "SEL$9C7D1284" "SEL$94AF091B") LOCAL LOCAL) | | LEADING(@"SEL$1" ((("a"@"SEL$1" "s"@"SEL$1") "t"@"SEL$1") "u"@"SEL$1")) | | USE_HASH(@"SEL$1" "u"@"SEL$1") | | USE_NL(@"SEL$1" "t"@"SEL$1") | | PQ_DISTRIBUTE(@"SEL$1" "t"@"SEL$1" LOCAL LOCAL) | | USE_NL(@"SEL$1" "s"@"SEL$1") | | PQ_DISTRIBUTE(@"SEL$1" "s"@"SEL$1" BC2HOST NONE) | | INDEX(@"SEL$1" "a"@"SEL$1" "idx_10") | | INDEX(@"SEL$1" "s"@"SEL$1" "primary") | | INDEX(@"SEL$1" "t"@"SEL$1" "udx_set_id") | | FULL(@"SEL$1" "u"@"SEL$1") | | LEADING(@"SEL$B15E051B" ("h"@"SEL$2" "g"@"SEL$2")) | | USE_NL(@"SEL$B15E051B" "g"@"SEL$2") | | PQ_DISTRIBUTE(@"SEL$B15E051B" "g"@"SEL$2" BC2HOST NONE) | | INDEX(@"SEL$B15E051B" "h"@"SEL$2" "i_sensi_flag") | | INDEX(@"SEL$B15E051B" "g"@"SEL$2" "idx_4") | | LEADING(@"SEL$9C7D1284" ("h"@"SEL$3" "g"@"SEL$3")) | | USE_NL(@"SEL$9C7D1284" "g"@"SEL$3") | | PQ_DISTRIBUTE(@"SEL$9C7D1284" "g"@"SEL$3" BC2HOST NONE) | | INDEX(@"SEL$9C7D1284" "h"@"SEL$3" "i_sensi_flag") | | INDEX(@"SEL$9C7D1284" "g"@"SEL$3" "idx_4") | | LEADING(@"SEL$94AF091B" ("h"@"SEL$4" "g"@"SEL$4")) | | USE_NL(@"SEL$94AF091B" "g"@"SEL$4") | | PQ_DISTRIBUTE(@"SEL$94AF091B" "g"@"SEL$4" BC2HOST NONE) | | INDEX(@"SEL$94AF091B" "h"@"SEL$4" "i_sensi_flag") | | INDEX(@"SEL$94AF091B" "g"@"SEL$4" "idx_4") | | SIMPLIFY_GROUP_BY(@"SEL$2") | | SIMPLIFY_GROUP_BY(@"SEL$3") | | SIMPLIFY_GROUP_BY(@"SEL$4") | | OPTIMIZER_FEATURES_ENABLE('4.4.1.0') | | END_OUTLINE_DATA | | */ | | Optimization Info: | | ------------------------------------- | | a: | | table_rows:14148572 | | physical_range_rows:705086 | | logical_range_rows:552243 | | index_back_rows:1 | | output_rows:1 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_3, idx_6, idx_7, idx_8, idx_dev_id, idx_exec_print_time, idx_group, idx_merchant_id, idx_set_id, idx_10, idx_9, i_station_create_time, idx_time_id, idx_create_time_state_tenant, idx_composite1, t_order] | | pruned_index_name:[idx_1, idx_3, idx_6, idx_7, idx_8, idx_dev_id, idx_exec_print_time, idx_group, idx_merchant_id, i_station_create_time, idx_time_id, idx_create_time_state_tenant] | | stats info:[version=2025-12-07 22:00:46.809593, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | s: | | table_rows:363 | | physical_range_rows:1 | | logical_range_rows:1 | | output_rows:1 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_real_merchant_id, idx_total_set_id, t_set] | | pruned_index_name:[idx_1, idx_real_merchant_id, idx_total_set_id] | | stats info:[version=2025-12-03 07:35:07.668931, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS] | | t: | | table_rows:334 | | physical_range_rows:1 | | logical_range_rows:1 | | index_back_rows:1 | | output_rows:1 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[udx_set_id, idx_policy_id, t_set_security_policy] | | pruned_index_name:[idx_policy_id, t_set_security_policy] | | stats info:[version=2025-12-03 07:35:05.054972, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS] | | u: | | table_rows:6 | | physical_range_rows:6 | | logical_range_rows:6 | | output_rows:6 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[t_security_policy] | | stats info:[version=2025-12-03 07:35:09.853051, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | h: | | table_rows:16351598 | | physical_range_rows:634270 | | logical_range_rows:501475 | | output_rows:501475 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_2, idx_3, idx_detect_start_time, i_end_time_sensi_inst, i_sensi_flag, idx_upload_storage_flag, idx_upload_tenant, t_file] | | pruned_index_name:[idx_1, idx_2, idx_3, idx_detect_start_time, i_end_time_sensi_inst, idx_upload_storage_flag, idx_upload_tenant] | | stats info:[version=2025-12-05 22:01:06.242261, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | g: | | table_rows:19236902 | | physical_range_rows:2 | | logical_range_rows:2 | | index_back_rows:2 | | output_rows:1 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_2, idx_3, idx_4, idx_print_state, idx_update_time, idx_update_time_speed, idx_time_id, t_order_file] | | pruned_index_name:[idx_2, idx_3, idx_print_state, idx_update_time, idx_update_time_speed, idx_time_id] | | unstable_index_name:[t_order_file] | | stats info:[version=2025-12-07 22:01:11.194020, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS] | | h: | | table_rows:16351598 | | physical_range_rows:1579 | | logical_range_rows:1100 | | output_rows:1100 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_2, idx_3, idx_detect_start_time, i_end_time_sensi_inst, i_sensi_flag, idx_upload_storage_flag, idx_upload_tenant, t_file] | | pruned_index_name:[idx_1, idx_2, idx_3, idx_detect_start_time, i_end_time_sensi_inst, idx_upload_storage_flag, idx_upload_tenant] | | stats info:[version=2025-12-05 22:01:06.242261, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | g: | | table_rows:19236902 | | physical_range_rows:2 | | logical_range_rows:2 | | index_back_rows:2 | | output_rows:1 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_2, idx_3, idx_4, idx_print_state, idx_update_time, idx_update_time_speed, idx_time_id, t_order_file] | | pruned_index_name:[idx_2, idx_3, idx_print_state, idx_update_time, idx_update_time_speed, idx_time_id] | | unstable_index_name:[t_order_file] | | stats info:[version=2025-12-07 22:01:11.194020, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS] | | h: | | table_rows:16351598 | | physical_range_rows:1760 | | logical_range_rows:1760 | | output_rows:1760 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_2, idx_3, idx_detect_start_time, i_end_time_sensi_inst, i_sensi_flag, idx_upload_storage_flag, idx_upload_tenant, t_file] | | pruned_index_name:[idx_1, idx_2, idx_3, idx_detect_start_time, i_end_time_sensi_inst, idx_upload_storage_flag, idx_upload_tenant] | | stats info:[version=2025-12-05 22:01:06.242261, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS, STORAGE] | | g: | | table_rows:19236902 | | physical_range_rows:2 | | logical_range_rows:2 | | index_back_rows:2 | | output_rows:1 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[idx_1, idx_2, idx_3, idx_4, idx_print_state, idx_update_time, idx_update_time_speed, idx_time_id, t_order_file] | | pruned_index_name:[idx_2, idx_3, idx_print_state, idx_update_time, idx_update_time_speed, idx_time_id] | | unstable_index_name:[t_order_file] | | stats info:[version=2025-12-07 22:01:11.194020, is_locked=0, is_expired=0] | | dynamic sampling level:0 | | estimation method:[OPTIMIZER STATISTICS] | | Plan Type: | | DISTRIBUTED | | Parameters: | | :0 => 1 | | :1 => 1 | | :2 => 1000 | | :3 => 1 | | :4 => 2 | | :5 => 96 | | :6 => 97 | | :7 => 1 | | :8 => 98 | | :9 => 99 | | :10 => -3 | | :11 => 'woqu' | | :12 => -60 | | :13 => '00' | | Note: | | Degree of Parallelisim is 1 because of table property | | Expr Constraints: | | 1 result is NOT NULL | | 1 result is NOT NULL | | 1 result is NOT NULL | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 345 rows in set (0.038 sec)