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 |52926 | | | |1 |├─HASH OUTER JOIN | |1 |51281 | | | |2 |│ ├─PX COORDINATOR | |1 |50227 | | | |3 |│ │ └─EXCHANGE OUT DISTR |:EX10000 |1 |50226 | | | |4 |│ │ └─TABLE RANGE SCAN |a(idx_10)|1 |50224 | | | |5 |│ └─HASH OUTER JOIN | |370 |1023 | | | |6 |│ ├─PX COORDINATOR | |370 |242 | | | |7 |│ │ └─EXCHANGE OUT DISTR |:EX20000 |370 |171 | | | |8 |│ │ └─TABLE FULL SCAN |s |370 |12 | | | |9 |│ └─PX COORDINATOR | |334 |679 | | | |10|│ └─EXCHANGE OUT DISTR |:EX30000 |334 |489 | | | |11|│ └─HASH RIGHT OUTER JOIN | |334 |61 | | | |12|│ ├─TABLE FULL SCAN |u |6 |3 | | | |13|│ └─TABLE FULL SCAN |t |334 |19 | | | |14|├─PX COORDINATOR | |1 |151 | | | |15|│ └─EXCHANGE OUT DISTR |:EX40001 |1 |151 | | | |16|│ └─SCALAR GROUP BY | |1 |150 | | | |17|│ └─NESTED-LOOP JOIN | |6 |150 | | | |18|│ ├─EXCHANGE IN DISTR | |6 |57 | | | |19|│ │ └─EXCHANGE OUT DISTR (BC2HOST)|:EX40000 |6 |55 | | | |20|│ │ └─TABLE RANGE SCAN |g(idx_1) |6 |50 | | | |21|│ └─TABLE GET |h |1 |16 | | | |22|├─PX COORDINATOR | |1 |151 | | | |23|│ └─EXCHANGE OUT DISTR |:EX50001 |1 |150 | | | |24|│ └─SCALAR GROUP BY | |1 |150 | | | |25|│ └─NESTED-LOOP JOIN | |6 |150 | | | |26|│ ├─EXCHANGE IN DISTR | |6 |57 | | | |27|│ │ └─EXCHANGE OUT DISTR (BC2HOST)|:EX50000 |6 |55 | | | |28|│ │ └─TABLE RANGE SCAN |g(idx_1) |6 |50 | | | |29|│ └─TABLE GET |h |1 |16 | | | |30|└─PX COORDINATOR | |1 |151 | | | |31| └─EXCHANGE OUT DISTR |:EX60001 |1 |150 | | | |32| └─SCALAR GROUP BY | |1 |150 | | | |33| └─NESTED-LOOP JOIN | |6 |150 | | | |34| ├─EXCHANGE IN DISTR | |6 |57 | | | |35| │ └─EXCHANGE OUT DISTR (BC2HOST)|:EX60000 |6 |55 | | | |36| │ └─TABLE RANGE SCAN |g(idx_1) |6 |50 | | | |37| └─TABLE GET |h |1 |16 | | | ============================================================================= | | Outputs & filters: | | ------------------------------------- | | 0 - output([a.order_id(0x7fa9b183df00)], [a.use_type(0x7fa9b183e250)], [subquery(1)(0x7fa9b183e3f0)], [subquery(2)(0x7fa9b1867490)], [subquery(3)(0x7fa9b187c890)], | | [u.censor_flag(0x7fa9b18a4e30)], [u.sensi_handle_flag(0x7fa9b18a5180)]), filter(nil), rowset=256 | | exec_params_([a.order_id(0x7fa9b183df00)(:0(0x7fa9b18653f0))], [a.order_id(0x7fa9b183df00)(:1(0x7fa9b187aeb0))], [a.order_id(0x7fa9b183df00)(:2(0x7fa9b18a33f0))]), | | onetime_exprs_(nil), init_plan_idxs_(nil), use_batch=false | | 1 - output([a.order_id(0x7fa9b183df00)], [a.use_type(0x7fa9b183e250)], [u.censor_flag(0x7fa9b18a4e30)], [u.sensi_handle_flag(0x7fa9b18a5180)]), filter(nil), rowset=256 | | equal_conds([a.set_id(0x7fa9b1836e60) = s.set_id(0x7fa9b1836ff0)(0x7fa9b1836d10)]), other_conds(nil) | | 2 - output([a.order_id(0x7fa9b183df00)], [a.use_type(0x7fa9b183e250)], [a.set_id(0x7fa9b1836e60)]), filter(nil), rowset=256 | | 3 - output([a.order_id(0x7fa9b183df00)], [a.use_type(0x7fa9b183e250)], [a.set_id(0x7fa9b1836e60)]), filter(nil), rowset=256 | | is_single, dop=1 | | 4 - output([a.order_id(0x7fa9b183df00)], [a.set_id(0x7fa9b1836e60)], [a.use_type(0x7fa9b183e250)]), filter([a.state_date(0x7fa9b183b370) > date_add(current_timestamp()(0x7fa9b183ad60), | | cast(-3(0x7fa9b183aea0), VARCHAR(1048576))(0x7fa9b183b5e0), 3)(0x7fa9b183abf0)(0x7fa9b183b220)], [a.checked_flag(0x7fa9b183dac0) IS NULL(0x7fa9b183d970)], | | [a.r_tenant_id(0x7fa9b183bef0) = 'woqu'(0x7fa9b183bc50)(0x7fa9b183bda0)], [a.state_date(0x7fa9b183b370) < date_add(current_timestamp()(0x7fa9b183ad60), | | cast(-60(0x7fa9b183c5f0), VARCHAR(1048576))(0x7fa9b183cac0), 1)(0x7fa9b183c340)(0x7fa9b183c970)]), rowset=256 | | access([a.order_id(0x7fa9b183df00)], [a.set_id(0x7fa9b1836e60)], [a.state_date(0x7fa9b183b370)], [a.r_tenant_id(0x7fa9b183bef0)], [a.checked_flag(0x7fa9b183dac0)], | | [a.use_type(0x7fa9b183e250)]), partitions(p0) | | is_index_back=true, is_global_index=false, filter_before_indexback[true,false,false,true], | | range_key([a.state(0x7fa9b183d3d0)], [a.exec_print_flag(0x7fa9b19725d0)], [a.use_type(0x7fa9b183e250)], [a.print_mode(0x7fa9b1972760)], [a.state_date(0x7fa9b183b370)], | | [a.order_id(0x7fa9b183df00)]), range(00,MIN,MIN,MIN,MIN,MIN ; 00,MAX,MAX,MAX,MAX,MAX), | | range_cond([a.state(0x7fa9b183d3d0) = '00'(0x7fa9b183d130)(0x7fa9b183d280)]) | | 5 - output([u.censor_flag(0x7fa9b18a4e30)], [u.sensi_handle_flag(0x7fa9b18a5180)], [s.set_id(0x7fa9b1836ff0)]), filter(nil), rowset=256 | | equal_conds([s.set_id(0x7fa9b1836ff0) = t.set_id(0x7fa9b18399f0)(0x7fa9b18398a0)]), other_conds(nil) | | 6 - output([s.set_id(0x7fa9b1836ff0)]), filter(nil), rowset=256 | | 7 - output([s.set_id(0x7fa9b1836ff0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 8 - output([s.set_id(0x7fa9b1836ff0)]), filter(nil), rowset=256 | | access([s.set_id(0x7fa9b1836ff0)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([s.set_id(0x7fa9b1836ff0)]), range(MIN ; MAX)always true | | 9 - output([u.censor_flag(0x7fa9b18a4e30)], [u.sensi_handle_flag(0x7fa9b18a5180)], [t.set_id(0x7fa9b18399f0)]), filter(nil), rowset=256 | | 10 - output([u.censor_flag(0x7fa9b18a4e30)], [u.sensi_handle_flag(0x7fa9b18a5180)], [t.set_id(0x7fa9b18399f0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 11 - output([u.censor_flag(0x7fa9b18a4e30)], [u.sensi_handle_flag(0x7fa9b18a5180)], [t.set_id(0x7fa9b18399f0)]), filter(nil), rowset=256 | | equal_conds([t.policy_id(0x7fa9b183a4e0) = u.policy_id(0x7fa9b183a670)(0x7fa9b183a390)]), other_conds(nil) | | 12 - output([u.policy_id(0x7fa9b183a670)], [u.censor_flag(0x7fa9b18a4e30)], [u.sensi_handle_flag(0x7fa9b18a5180)]), filter(nil), rowset=256 | | access([u.policy_id(0x7fa9b183a670)], [u.censor_flag(0x7fa9b18a4e30)], [u.sensi_handle_flag(0x7fa9b18a5180)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([u.policy_id(0x7fa9b183a670)]), range(MIN ; MAX)always true | | 13 - output([t.set_id(0x7fa9b18399f0)], [t.policy_id(0x7fa9b183a4e0)]), filter(nil), rowset=256 | | access([t.set_id(0x7fa9b18399f0)], [t.policy_id(0x7fa9b183a4e0)]), partitions(p0) | | is_index_back=false, is_global_index=false, | | range_key([t.id(0x7fa9b18a7680)]), range(MIN ; MAX)always true | | 14 - output([T_FUN_COUNT(*)(0x7fa9b18670d0)]), filter(nil), rowset=256 | | 15 - output([T_FUN_COUNT(*)(0x7fa9b18670d0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 16 - output([T_FUN_COUNT(*)(0x7fa9b18670d0)]), filter(nil), rowset=256 | | group(nil), agg_func([T_FUN_COUNT(*)(0x7fa9b18670d0)]) | | 17 - output(nil), filter(nil), rowset=256 | | conds(nil), nl_params_([g.file_id(0x7fa9b1865cb0)(:6(0x7fac39c834d0))]), use_batch=true | | 18 - output([g.file_id(0x7fa9b1865cb0)]), filter(nil), rowset=256 | | 19 - output([g.file_id(0x7fa9b1865cb0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 20 - output([g.file_id(0x7fa9b1865cb0)]), filter(nil), rowset=256 | | access([g.order_file_id(0x7fa9b18a69f0)], [g.file_id(0x7fa9b1865cb0)]), partitions(p0) | | is_index_back=true, is_global_index=false, | | range_key([g.order_id(0x7fa9b1865260)], [g.order_file_id(0x7fa9b18a69f0)]), range(MIN,MIN ; MAX,MAX)always true, | | range_cond([g.order_id(0x7fa9b1865260) = :0(0x7fa9b18653f0)(0x7fa9b1865110)]), is_fast_range = true | | 21 - output(nil), filter([h.sensi_flag(0x7fa9b1866c80) IS NULL(0x7fa9b1866440) OR h.sensi_flag(0x7fa9b1866c80) IN (1(0x7fa9b18669c0), 1000(0x7fa9b1866b10))(0x7fa9b18b33e0)(0x7fa9b1866590)(0x7fa9b1865f | | f0)]), rowset=256 | | access([GROUP_ID(0x7fa8f97cdf30)], [h.sensi_flag(0x7fa9b1866c80)]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([h.file_id(0x7fa9b1865b20)]), range(MIN ; MAX), | | range_cond([h.file_id(0x7fa9b1865b20) = :6(0x7fac39c834d0)(0x7fac39c83640)]), is_fast_range = true | | 22 - output([T_FUN_COUNT(*)(0x7fa9b187c4d0)]), filter(nil), rowset=256 | | 23 - output([T_FUN_COUNT(*)(0x7fa9b187c4d0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 24 - output([T_FUN_COUNT(*)(0x7fa9b187c4d0)]), filter(nil), rowset=256 | | group(nil), agg_func([T_FUN_COUNT(*)(0x7fa9b187c4d0)]) | | 25 - output(nil), filter(nil), rowset=256 | | conds(nil), nl_params_([g.file_id(0x7fa9b187b770)(:8(0x7fa9d603fdc0))]), use_batch=true | | 26 - output([g.file_id(0x7fa9b187b770)]), filter(nil), rowset=256 | | 27 - output([g.file_id(0x7fa9b187b770)]), filter(nil), rowset=256 | | is_single, dop=1 | | 28 - output([g.file_id(0x7fa9b187b770)]), filter(nil), rowset=256 | | access([g.order_file_id(0x7fa9b18a6e20)], [g.file_id(0x7fa9b187b770)]), partitions(p0) | | is_index_back=true, is_global_index=false, | | range_key([g.order_id(0x7fa9b187ad20)], [g.order_file_id(0x7fa9b18a6e20)]), range(MIN,MIN ; MAX,MAX)always true, | | range_cond([g.order_id(0x7fa9b187ad20) = :1(0x7fa9b187aeb0)(0x7fa9b187abd0)]), is_fast_range = true | | 29 - output(nil), filter([h.sensi_flag(0x7fa9b187c250) IN (2(0x7fa9b187be40), 96(0x7fa9b187bf90), 97(0x7fa9b187c0e0))(0x7fa9b18b3530)(0x7fa9b187ba10)]), rowset=256 | | access([GROUP_ID(0x7fa8f97ce030)], [h.sensi_flag(0x7fa9b187c250)]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([h.file_id(0x7fa9b187b5e0)]), range(MIN ; MAX), | | range_cond([h.file_id(0x7fa9b187b5e0) = :8(0x7fa9d603fdc0)(0x7fa9d603ff30)]), is_fast_range = true | | 30 - output([T_FUN_COUNT(*)(0x7fa9b18a48c0)]), filter(nil), rowset=256 | | 31 - output([T_FUN_COUNT(*)(0x7fa9b18a48c0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 32 - output([T_FUN_COUNT(*)(0x7fa9b18a48c0)]), filter(nil), rowset=256 | | group(nil), agg_func([T_FUN_COUNT(*)(0x7fa9b18a48c0)]) | | 33 - output(nil), filter(nil), rowset=256 | | conds(nil), nl_params_([g.file_id(0x7fa9b18a3cb0)(:10(0x7fa9d61f0050))]), use_batch=true | | 34 - output([g.file_id(0x7fa9b18a3cb0)]), filter(nil), rowset=256 | | 35 - output([g.file_id(0x7fa9b18a3cb0)]), filter(nil), rowset=256 | | is_single, dop=1 | | 36 - output([g.file_id(0x7fa9b18a3cb0)]), filter(nil), rowset=256 | | access([g.order_file_id(0x7fa9b18a7250)], [g.file_id(0x7fa9b18a3cb0)]), partitions(p0) | | is_index_back=true, is_global_index=false, | | range_key([g.order_id(0x7fa9b18a3260)], [g.order_file_id(0x7fa9b18a7250)]), range(MIN,MIN ; MAX,MAX)always true, | | range_cond([g.order_id(0x7fa9b18a3260) = :2(0x7fa9b18a33f0)(0x7fa9b18a3110)]), is_fast_range = true | | 37 - output(nil), filter([h.sensi_flag(0x7fa9b18a4640) IN (98(0x7fa9b18a4380), 99(0x7fa9b18a44d0))(0x7fa9b18b3680)(0x7fa9b18a3f50)]), rowset=256 | | access([GROUP_ID(0x7fa8f97ce130)], [h.sensi_flag(0x7fa9b18a4640)]), partitions(p0) | | is_index_back=false, is_global_index=false, filter_before_indexback[false], | | range_key([h.file_id(0x7fa9b18a3b20)]), range(MIN ; MAX), | | range_cond([h.file_id(0x7fa9b18a3b20) = :10(0x7fa9d61f0050)(0x7fa9d61f01c0)]), 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" ("u"@"SEL$1" "t"@"SEL$1")))) | | USE_HASH(@"SEL$1" ("u"@"SEL$1" "t"@"SEL$1" "s"@"SEL$1")) | | PQ_DISTRIBUTE(@"SEL$1" ("u"@"SEL$1" "t"@"SEL$1" "s"@"SEL$1") LOCAL LOCAL) | | INDEX(@"SEL$1" "a"@"SEL$1" "idx_10") | | USE_HASH(@"SEL$1" ("u"@"SEL$1" "t"@"SEL$1")) | | PQ_DISTRIBUTE(@"SEL$1" ("u"@"SEL$1" "t"@"SEL$1") LOCAL LOCAL) | | FULL(@"SEL$1" "s"@"SEL$1") | | USE_HASH(@"SEL$1" "t"@"SEL$1") | | FULL(@"SEL$1" "u"@"SEL$1") | | FULL(@"SEL$1" "t"@"SEL$1") | | LEADING(@"SEL$B15E051B" ("g"@"SEL$2" "h"@"SEL$2")) | | USE_NL(@"SEL$B15E051B" "h"@"SEL$2") | | PQ_DISTRIBUTE(@"SEL$B15E051B" "h"@"SEL$2" BC2HOST NONE) | | INDEX(@"SEL$B15E051B" "g"@"SEL$2" "idx_1") | | INDEX(@"SEL$B15E051B" "h"@"SEL$2" "primary") | | LEADING(@"SEL$9C7D1284" ("g"@"SEL$3" "h"@"SEL$3")) | | USE_NL(@"SEL$9C7D1284" "h"@"SEL$3") | | PQ_DISTRIBUTE(@"SEL$9C7D1284" "h"@"SEL$3" BC2HOST NONE) | | INDEX(@"SEL$9C7D1284" "g"@"SEL$3" "idx_1") | | INDEX(@"SEL$9C7D1284" "h"@"SEL$3" "primary") | | LEADING(@"SEL$94AF091B" ("g"@"SEL$4" "h"@"SEL$4")) | | USE_NL(@"SEL$94AF091B" "h"@"SEL$4") | | PQ_DISTRIBUTE(@"SEL$94AF091B" "h"@"SEL$4" BC2HOST NONE) | | INDEX(@"SEL$94AF091B" "g"@"SEL$4" "idx_1") | | INDEX(@"SEL$94AF091B" "h"@"SEL$4" "primary") | | 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:670881 | | logical_range_rows:552137 | | 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:376 | | logical_range_rows:370 | | output_rows:370 | | 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, STORAGE] | | 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] | | t: | | table_rows:334 | | physical_range_rows:334 | | logical_range_rows:334 | | output_rows:334 | | table_dop:1 | | dop_method:Table DOP | | avaiable_index_name:[udx_set_id, 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, STORAGE] | | g: | | table_rows:19236902 | | physical_range_rows:6 | | logical_range_rows:6 | | index_back_rows:6 | | output_rows:6 | | 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:[idx_4, 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, STORAGE] | | h: | | table_rows:16351598 | | physical_range_rows:1 | | logical_range_rows:1 | | output_rows:1 | | 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, i_sensi_flag, 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] | | g: | | table_rows:19236902 | | physical_range_rows:6 | | logical_range_rows:6 | | index_back_rows:6 | | output_rows:6 | | 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:[idx_4, 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, STORAGE] | | h: | | table_rows:16351598 | | physical_range_rows:1 | | logical_range_rows:1 | | output_rows:1 | | 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, i_sensi_flag, 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] | | g: | | table_rows:19236902 | | physical_range_rows:6 | | logical_range_rows:6 | | index_back_rows:6 | | output_rows:6 | | 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:[idx_4, 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, STORAGE] | | h: | | table_rows:16351598 | | physical_range_rows:1 | | logical_range_rows:1 | | output_rows:1 | | 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, i_sensi_flag, 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] | | 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 | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 344 rows in set (0.085 sec)