obclient> SELECT DBMS_XPLAN.DISPLAY_CURSOR( -> 38142, -> 'typical', -> '10.225.224.38', -> 2882, -> 1 -> ) FROM DUAL; +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | DBMS_XPLAN.DISPLAY_CURSOR( 38142, 'typical', '10.225.224.38', 2882, 1 ) | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ==================================================================================================================================================================== |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)|REAL.ROWS|REAL.TIME(us)|IO TIME(us)|CPU TIME(us)| -------------------------------------------------------------------------------------------------------------------------------------------------------------------- |0 |SORT | |1 |760 |0 |9633355 |0 |22 | |1 |└─HASH GROUP BY | |1 |759 |0 |9633355 |0 |25 | |2 | └─NESTED-LOOP JOIN | |1 |759 |0 |9633355 |0 |30 | |3 | ├─MERGE JOIN | |1 |738 |0 |9633355 |0 |14 | |4 | │ ├─SORT | |1 |730 |0 |9633355 |0 |21 | |5 | │ │ └─SUBPLAN SCAN |cdb_ob_table_locations |1 |730 |0 |9633355 |0 |9 | |6 | │ │ └─MERGE RIGHT OUTER JOIN | |1 |730 |0 |9633355 |0 |19 | |7 | │ │ ├─TABLE FULL SCAN |TG |1 |4 |1 |9632300 |0 |948 | |8 | │ │ └─SORT | |1 |726 |0 |9633355 |0 |24 | |9 | │ │ └─HASH JOIN | |1 |726 |0 |9633355 |0 |14670 | |10| │ │ ├─NESTED-LOOP JOIN | |3 |576 |44723 |9633355 |0 |76732 | |11| │ │ │ ├─MERGE JOIN | |1 |14 |131 |9633355 |0 |629 | |12| │ │ │ │ ├─SORT | |1 |9 |18 |9633355 |0 |119 | |13| │ │ │ │ │ └─SUBPLAN SCAN |CDB_OB_LS_LOCATIONS |1 |9 |47 |24236 |0 |15 | |14| │ │ │ │ │ └─UNION ALL | |1 |9 |47 |24236 |0 |17 | |15| │ │ │ │ │ ├─TABLE FULL SCAN |__ALL_VIRTUAL_CORE_META_TABLE |1 |3 |1 |1059 |0 |112 | |16| │ │ │ │ │ └─TABLE RANGE SCAN|__ALL_VIRTUAL_LS_META_TABLE |1 |6 |46 |24236 |0 |23236 | |17| │ │ │ │ └─TABLE FULL SCAN |D |10 |5 |64 |9633355 |0 |7093 | |18| │ │ │ └─SUBPLAN SCAN |A |225 |557 |44723 |9583821 |0 |4277 | |19| │ │ │ └─UNION ALL | |225 |556 |44723 |9583821 |0 |4842 | |20| │ │ │ ├─TABLE FULL SCAN |__ALL_VIRTUAL_CORE_ALL_TABLE |15 |23 |288 |9616512 |0 |4187261 | |21| │ │ │ ├─TABLE RANGE SCAN |__ALL_VIRTUAL_TABLE |208 |193 |16270 |9619691 |0 |372137 | |22| │ │ │ ├─HASH JOIN | |2 |178 |28165 |9619691 |0 |92576 | |23| │ │ │ │ ├─TABLE RANGE SCAN |P |1 |21 |197155 |9619691 |0 |329029 | |24| │ │ │ │ └─TABLE FULL SCAN |T |208 |138 |18510 |9078638 |0 |2787571 | |25| │ │ │ └─MERGE JOIN | |2 |163 |0 |9633355 |0 |212 | |26| │ │ │ ├─MERGE JOIN | |1 |8 |0 |9633355 |0 |384 | |27| │ │ │ │ ├─TABLE FULL SCAN |P |1 |4 |131 |9633355 |0 |405451 | |28| │ │ │ │ └─TABLE FULL SCAN |Q |1 |4 |0 |9633355 |0 |1324620 | |29| │ │ │ └─TABLE RANGE SCAN |T |208 |155 |0 |9633355 |0 |0 | |30| │ │ └─SUBPLAN SCAN |CDB_OB_TABLET_TO_LS |447 |105 |0 |9633355 |0 |0 | |31| │ │ └─UNION ALL | |447 |104 |0 |9633355 |0 |0 | |32| │ │ ├─TABLE FULL SCAN |__ALL_VIRTUAL_CORE_ALL_TABLE |16 |5 |0 |9633355 |0 |0 | |33| │ │ ├─TABLE FULL SCAN |__ALL_VIRTUAL_TABLE |429 |94 |0 |9633355 |0 |0 | |34| │ │ └─TABLE FULL SCAN |__ALL_VIRTUAL_TABLET_TO_LS |2 |4 |0 |9633355 |0 |0 | |35| │ └─SUBPLAN SCAN |dba_ob_tenants |1 |8 |0 |9633355 |0 |0 | |36| │ └─NESTED-LOOP OUTER JOIN | |1 |8 |0 |9633355 |0 |0 | |37| │ ├─TABLE FULL SCAN |A |1 |4 |0 |9633355 |0 |0 | |38| │ └─MATERIAL | |1 |5 |0 |9633355 |0 |0 | |39| │ └─SUBPLAN SCAN |C |1 |5 |0 |9633355 |0 |0 | |40| │ └─HASH DISTINCT | |1 |5 |0 |9633355 |0 |0 | |41| │ └─TABLE FULL SCAN |__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT|1 |4 |0 |9633355 |0 |0 | |42| └─SUBPLAN SCAN |cdb_ob_tablet_replicas |1 |21 |0 |9633355 |0 |0 | |43| └─TABLE RANGE SCAN |__ALL_VIRTUAL_TABLET_META_TABLE |1 |21 |0 |9633355 |0 |0 | ==================================================================================================================================================================== Outputs & filters: ------------------------------------- 0 - output([t.TENANT_NAME], [round(T_FUN_SUM(t2.DATA_SIZE) / cast(:0, DECIMAL(4, 0)) / cast(:1, DECIMAL(4, 0)) / cast(:2, DECIMAL(4, 0)), 2)], [round(T_FUN_SUM(t2.REQUIRED_SIZE) / cast(:3, DECIMAL(4, 0)) / cast(:4, DECIMAL(4, 0)) / cast(:5, DECIMAL(4, 0)), 2)]), filter(nil) sort_keys([round(T_FUN_SUM(t2.REQUIRED_SIZE) / cast(:3, DECIMAL(4, 0)) / cast(:4, DECIMAL(4, 0)) / cast(:5, DECIMAL(4, 0)), 2), DESC]) 1 - output([round(T_FUN_SUM(t2.REQUIRED_SIZE) / cast(:3, DECIMAL(4, 0)) / cast(:4, DECIMAL(4, 0)) / cast(:5, DECIMAL(4, 0)), 2)], [t.TENANT_NAME], [T_FUN_SUM(t2.DATA_SIZE)]), filter(nil) group([t.TENANT_NAME]), agg_func([T_FUN_SUM(t2.DATA_SIZE)], [T_FUN_SUM(t2.REQUIRED_SIZE)]) 2 - output([t.TENANT_NAME], [t2.DATA_SIZE], [t2.REQUIRED_SIZE]), filter(nil) conds(nil), nl_params_([t1.TENANT_ID(:68)], [t1.LS_ID(:69)], [t1.TABLET_ID(:70)], [t1.SVR_IP(:71)]), use_batch=false 3 - output([t.TENANT_NAME], [t1.TENANT_ID], [t1.LS_ID], [t1.TABLET_ID], [t1.SVR_IP]), filter(nil) equal_conds([t.TENANT_ID = t1.TENANT_ID]), other_conds(nil) merge_directions([ASC]) 4 - output([t1.TENANT_ID], [t1.LS_ID], [t1.TABLET_ID], [t1.SVR_IP]), filter(nil) sort_keys([t1.TENANT_ID, ASC]) 5 - output([t1.TENANT_ID], [t1.TABLET_ID], [t1.LS_ID], [t1.SVR_IP]), filter(nil) access([t1.TENANT_ID], [t1.TABLET_ID], [t1.LS_ID], [t1.SVR_IP]) 6 - output([A.TENANT_ID], [A.TABLET_ID], [C.LS_ID], [C.SVR_IP]), filter(nil) equal_conds([A.TENANT_ID = TG.tenant_id], [A.TABLEGROUP_ID = TG.tablegroup_id]), other_conds(nil) merge_directions([ASC], [ASC]) 7 - output([TG.tenant_id], [TG.tablegroup_id]), filter(nil) access([TG.tenant_id], [TG.tablegroup_id]), partitions(p1) is_index_back=false, is_global_index=false, range_key([TG.tenant_id], [TG.tablegroup_id]), range(MIN,MIN ; MAX,MAX)always true 8 - output([A.TENANT_ID], [A.TABLET_ID], [C.LS_ID], [C.SVR_IP], [A.TABLEGROUP_ID]), filter(nil) sort_keys([A.TENANT_ID, ASC], [A.TABLEGROUP_ID, ASC]) 9 - output([A.TENANT_ID], [A.TABLET_ID], [C.LS_ID], [C.SVR_IP], [A.TABLEGROUP_ID]), filter(nil) equal_conds([B.LS_ID = C.LS_ID], [A.TABLET_ID = B.TABLET_ID], [A.TENANT_ID = B.TENANT_ID]), other_conds(nil) 10 - output([A.TENANT_ID], [A.TABLET_ID], [C.LS_ID], [C.SVR_IP], [A.TABLEGROUP_ID]), filter(nil) conds(nil), nl_params_([D.tenant_id(:14)], [D.database_id(:15)]), use_batch=false 11 - output([C.LS_ID], [C.SVR_IP], [D.tenant_id], [D.database_id]), filter(nil) equal_conds([D.tenant_id = C.TENANT_ID]), other_conds(nil) merge_directions([ASC]) 12 - output([C.LS_ID], [C.SVR_IP], [C.TENANT_ID]), filter(nil) sort_keys([C.TENANT_ID, ASC]) 13 - output([C.TENANT_ID], [C.LS_ID], [C.SVR_IP]), filter(nil) access([C.TENANT_ID], [C.LS_ID], [C.SVR_IP]) 14 - output([UNION([1])], [UNION([2])], [UNION([3])]), filter(nil) 15 - output([__ALL_VIRTUAL_CORE_META_TABLE.tenant_id], [__ALL_VIRTUAL_CORE_META_TABLE.ls_id], [__ALL_VIRTUAL_CORE_META_TABLE.svr_ip]), filter([CASE WHEN __ALL_VIRTUAL_CORE_META_TABLE.role = 1 THEN 'LEADER' ELSE 'FOLLOWER' END = :6]) access([__ALL_VIRTUAL_CORE_META_TABLE.tenant_id], [__ALL_VIRTUAL_CORE_META_TABLE.ls_id], [__ALL_VIRTUAL_CORE_META_TABLE.svr_ip], [__ALL_VIRTUAL_CORE_META_TABLE.role]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key(nil), range(MIN ; MAX) 16 - output([__ALL_VIRTUAL_LS_META_TABLE.tenant_id], [__ALL_VIRTUAL_LS_META_TABLE.ls_id], [__ALL_VIRTUAL_LS_META_TABLE.svr_ip]), filter([CASE WHEN __ALL_VIRTUAL_LS_META_TABLE.role = 1 THEN 'LEADER' ELSE 'FOLLOWER' END = :6], [__ALL_VIRTUAL_LS_META_TABLE.tenant_id != 1]) access([__ALL_VIRTUAL_LS_META_TABLE.tenant_id], [__ALL_VIRTUAL_LS_META_TABLE.ls_id], [__ALL_VIRTUAL_LS_META_TABLE.svr_ip], [__ALL_VIRTUAL_LS_META_TABLE.role]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false,false], range_key([__ALL_VIRTUAL_LS_META_TABLE.tenant_id], [__ALL_VIRTUAL_LS_META_TABLE.ls_id], [__ALL_VIRTUAL_LS_META_TABLE.svr_ip], [__ALL_VIRTUAL_LS_META_TABLE.svr_port]), range(NULL,MAX,MAX,MAX ; 1,MIN,MIN,MIN), (1,MAX,MAX,MAX ; MAX,MAX,MAX,MAX), range_cond([__ALL_VIRTUAL_LS_META_TABLE.tenant_id != 1]) 17 - output([D.tenant_id], [D.database_id]), filter(nil) access([D.tenant_id], [D.database_id]), partitions(p1) is_index_back=false, is_global_index=false, range_key([D.tenant_id], [D.database_id]), range(MIN,MIN ; MAX,MAX)always true 18 - output([A.TENANT_ID], [A.TABLET_ID], [A.TABLEGROUP_ID]), filter(nil) access([A.TENANT_ID], [A.TABLET_ID], [A.TABLEGROUP_ID]) 19 - output([UNION([1])], [UNION([2])], [UNION([3])], [UNION([4])]), filter(nil) 20 - output([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id], [__ALL_VIRTUAL_CORE_ALL_TABLE.database_id], [__ALL_VIRTUAL_CORE_ALL_TABLE.tablet_id], [__ALL_VIRTUAL_CORE_ALL_TABLE.tablegroup_id]), filter([__ALL _VIRTUAL_CORE_ALL_TABLE.tablet_id != 0], [__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id = :14], [__ALL_VIRTUAL_CORE_ALL_TABLE.database_id = :15]) access([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id], [__ALL_VIRTUAL_CORE_ALL_TABLE.tablet_id], [__ALL_VIRTUAL_CORE_ALL_TABLE.database_id], [__ALL_VIRTUAL_CORE_ALL_TABLE.tablegroup_id]), partitions(p1 ) is_index_back=false, is_global_index=false, filter_before_indexback[false,false,false], range_key([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id], [__ALL_VIRTUAL_CORE_ALL_TABLE.table_id]), range(MIN,MIN ; MAX,MAX)always true 21 - output([__ALL_VIRTUAL_TABLE.tenant_id], [__ALL_VIRTUAL_TABLE.database_id], [__ALL_VIRTUAL_TABLE.tablet_id], [__ALL_VIRTUAL_TABLE.tablegroup_id]), filter([__ALL_VIRTUAL_TABLE.database_id = :15], [__ALL_VIRTUAL_TABLE.part_level = 0], [__ALL_VIRTUAL_TABLE.tablet_id != 0], [__ALL_VIRTUAL_TABLE.tenant_id = :14]) access([__ALL_VIRTUAL_TABLE.tenant_id], [__ALL_VIRTUAL_TABLE.tablet_id], [__ALL_VIRTUAL_TABLE.part_level], [__ALL_VIRTUAL_TABLE.database_id], [__ALL_VIRTUAL_TABLE.tablegroup_id]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false,false,false,false], range_key([__ALL_VIRTUAL_TABLE.tenant_id], [__ALL_VIRTUAL_TABLE.table_id]), range(MIN,MIN ; MAX,MAX)always true, range_cond([__ALL_VIRTUAL_TABLE.tenant_id = :14]) 22 - output([P.tenant_id], [T.database_id], [P.tablet_id], [T.tablegroup_id]), filter(nil) equal_conds([T.tenant_id = P.tenant_id], [T.table_id = P.table_id]), other_conds(nil) 23 - output([P.tenant_id], [P.table_id], [P.tablet_id]), filter([P.tenant_id = :14]) access([P.tenant_id], [P.table_id], [P.tablet_id]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([P.tenant_id], [P.table_id], [P.part_id]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true, range_cond([P.tenant_id = :14]) 24 - output([T.tenant_id], [T.table_id], [T.database_id], [T.tablegroup_id]), filter([T.database_id = :15], [T.part_level = 1]) access([T.tenant_id], [T.table_id], [T.part_level], [T.database_id], [T.tablegroup_id]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false,false], range_key([T.tenant_id], [T.table_id]), range(MIN,MIN ; MAX,MAX)always true 25 - output([T.tenant_id], [T.database_id], [Q.tablet_id], [T.tablegroup_id]), filter(nil) equal_conds([T.tenant_id = P.tenant_id], [T.table_id = P.table_id]), other_conds(nil) merge_directions([ASC], [ASC]) 26 - output([Q.tablet_id], [P.tenant_id], [P.table_id]), filter(nil) equal_conds([P.tenant_id = Q.tenant_id], [P.table_id = Q.table_id], [P.part_id = Q.part_id]), other_conds(nil) merge_directions([ASC], [ASC], [ASC]) 27 - output([P.tenant_id], [P.table_id], [P.part_id]), filter(nil) access([P.tenant_id], [P.table_id], [P.part_id]), partitions(p1) is_index_back=false, is_global_index=false, range_key([P.tenant_id], [P.table_id], [P.part_id]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true 28 - output([Q.tenant_id], [Q.table_id], [Q.part_id], [Q.tablet_id]), filter(nil) access([Q.tenant_id], [Q.table_id], [Q.part_id], [Q.tablet_id]), partitions(p1) is_index_back=false, is_global_index=false, range_key([Q.tenant_id], [Q.table_id], [Q.part_id], [Q.sub_part_id]), range(MIN,MIN,MIN,MIN ; MAX,MAX,MAX,MAX)always true 29 - output([T.tenant_id], [T.table_id], [T.database_id], [T.tablegroup_id]), filter([T.database_id = :15], [T.part_level = 2], [T.tenant_id = :14]) access([T.tenant_id], [T.table_id], [T.part_level], [T.database_id], [T.tablegroup_id]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false,false,false], range_key([T.tenant_id], [T.table_id]), range(MIN,MIN ; MAX,MAX)always true, range_cond([T.tenant_id = :14]) 30 - output([B.TABLET_ID], [B.TENANT_ID], [B.LS_ID]), filter(nil) access([B.TABLET_ID], [B.TENANT_ID], [B.LS_ID]) 31 - output([UNION([1])], [UNION([2])], [UNION([3])]), filter(nil) 32 - output([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id], [cast(__ALL_VIRTUAL_CORE_ALL_TABLE.table_id, BIGINT(0, 0))], [cast(1, BIGINT(0, 0))]), filter(nil) access([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id], [__ALL_VIRTUAL_CORE_ALL_TABLE.table_id]), partitions(p1) is_index_back=false, is_global_index=false, range_key([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id], [__ALL_VIRTUAL_CORE_ALL_TABLE.table_id]), range(MIN,MIN ; MAX,MAX)always true 33 - output([__ALL_VIRTUAL_TABLE.tenant_id], [cast(__ALL_VIRTUAL_TABLE.table_id, BIGINT(0, 0))], [cast(1, BIGINT(0, 0))]), filter([(T_OP_OR, __ALL_VIRTUAL_TABLE.table_id > 0 AND __ALL_VIRTUAL_TABLE.table_id < 10000, __ALL_VIRTUAL_TABLE.table_id > 50000 AND __ALL_VIRTUAL_TABLE.table_id < 70000, __ALL_VIRTUAL_TABLE.table_id > 100000 AND __ALL_VIRTUAL_TABLE.table_id < 200000)]) access([__ALL_VIRTUAL_TABLE.tenant_id], [__ALL_VIRTUAL_TABLE.table_id]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([__ALL_VIRTUAL_TABLE.tenant_id], [__ALL_VIRTUAL_TABLE.table_id]), range(MIN,MIN ; MAX,MAX)always true 34 - output([__ALL_VIRTUAL_TABLET_TO_LS.tenant_id], [__ALL_VIRTUAL_TABLET_TO_LS.tablet_id], [__ALL_VIRTUAL_TABLET_TO_LS.ls_id]), filter(nil) access([__ALL_VIRTUAL_TABLET_TO_LS.tenant_id], [__ALL_VIRTUAL_TABLET_TO_LS.tablet_id], [__ALL_VIRTUAL_TABLET_TO_LS.ls_id]), partitions(p1) is_index_back=false, is_global_index=false, range_key([__ALL_VIRTUAL_TABLET_TO_LS.tenant_id], [__ALL_VIRTUAL_TABLET_TO_LS.tablet_id]), range(MIN,MIN ; MAX,MAX)always true 35 - output([t.TENANT_ID], [t.TENANT_NAME]), filter(nil) access([t.TENANT_ID], [t.TENANT_NAME]) 36 - output([A.tenant_id], [A.tenant_name]), filter(nil) conds([A.tenant_id = C.TENANT_ID OR A.tenant_id = C.META_TENANT_ID]), nl_params_(nil), use_batch=false 37 - output([A.tenant_id], [A.tenant_name]), filter(nil) access([A.tenant_id], [A.tenant_name]), partitions(p1) is_index_back=false, is_global_index=false, range_key([A.tenant_id]), range(MIN ; MAX)always true 38 - output([C.TENANT_ID], [C.META_TENANT_ID]), filter(nil) 39 - output([C.TENANT_ID], [C.META_TENANT_ID]), filter(nil) access([C.TENANT_ID], [C.META_TENANT_ID]) 40 - output([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id], [CASE WHEN __ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id < 1 THEN NULL WHEN __ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id != 1 THEN __ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id - 1 ELSE NULL END]), filter(nil) distinct([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id]) 41 - output([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id]), filter(nil) access([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id]), partitions(p1) is_index_back=false, is_global_index=false, range_key([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.resource_pool_id]), range(MIN ; MAX)always true 42 - output([t2.DATA_SIZE], [t2.REQUIRED_SIZE]), filter(nil) access([t2.DATA_SIZE], [t2.REQUIRED_SIZE]) 43 - output([__ALL_VIRTUAL_TABLET_META_TABLE.tenant_id], [__ALL_VIRTUAL_TABLET_META_TABLE.tablet_id], [__ALL_VIRTUAL_TABLET_META_TABLE.svr_ip], [__ALL_VIRTUAL_TABLET_META_TABLE.ls_id], [__ALL_VIRTUAL_TABLET_META_TABLE.data_size], [__ALL_VIRTUAL_TABLET_META_TABLE.required_size]), filter([:70 = __ALL_VIRTUAL_TABLET_META_TABLE.tablet_id], [:68 = __ALL_VIRTUAL_TABLET_META_TABLE.tenant_id], [:69 = __ALL_VIRTUAL_TABLET_META_TABLE.ls_id], [:71 = __ALL_VIRTUAL_TABLET_META_TABLE.svr_ip]) access([__ALL_VIRTUAL_TABLET_META_TABLE.tenant_id], [__ALL_VIRTUAL_TABLET_META_TABLE.tablet_id], [__ALL_VIRTUAL_TABLET_META_TABLE.ls_id], [__ALL_VIRTUAL_TABLET_META_TABLE.svr_ip], [__ALL_VIRTUAL_TABLET_META_TABLE.data_size], [__ALL_VIRTUAL_TABLET_META_TABLE.required_size]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false,false,false,false], range_key([__ALL_VIRTUAL_TABLET_META_TABLE.tenant_id], [__ALL_VIRTUAL_TABLET_META_TABLE.tablet_id], [__ALL_VIRTUAL_TABLET_META_TABLE.ls_id], [__ALL_VIRTUAL_TABLET_META_TABLE.svr_ip], [__ALL_VIRTUAL_TABLET_META_TABLE.svr_port]), range(MIN,MIN,MIN,MIN,MIN ; MAX,MAX,MAX,MAX,MAX)always true, range_cond([:68 = __ALL_VIRTUAL_TABLET_META_TABLE.tenant_id], [:69 = __ALL_VIRTUAL_TABLET_META_TABLE.ls_id], [:70 = __ALL_VIRTUAL_TABLET_META_TABLE.tablet_id], [:71 = __ALL_VIRTUAL_TABLET_META_TABLE.svr_ip]) | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.02 sec)