================================================================================================================ |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| ---------------------------------------------------------------------------------------------------------------- |0 |SORT | |1 |1306 | |1 |└─HASH GROUP BY | |1 |1306 | |2 | └─MERGE JOIN | |66 |1298 | |3 | ├─SUBPLAN SCAN |dba_ob_tenants |1 |8 | |4 | │ └─NESTED-LOOP OUTER JOIN | |1 |8 | |5 | │ ├─TABLE FULL SCAN |A |1 |4 | |6 | │ └─MATERIAL | |1 |5 | |7 | │ └─SUBPLAN SCAN |C |1 |5 | |8 | │ └─HASH DISTINCT | |1 |5 | |9 | │ └─TABLE FULL SCAN |__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT|1 |4 | |10| └─MERGE JOIN | |66 |1287 | |11| ├─SUBPLAN SCAN |cdb_ob_tablet_replicas |888 |131 | |12| │ └─TABLE FULL SCAN |__ALL_VIRTUAL_TABLET_META_TABLE |888 |128 | |13| └─SORT | |24 |947 | |14| └─SUBPLAN SCAN |cdb_ob_table_locations |24 |942 | |15| └─HASH RIGHT OUTER JOIN | |24 |942 | |16| ├─TABLE FULL SCAN |TG |1 |4 | |17| └─HASH JOIN | |24 |935 | |18| ├─TABLE FULL SCAN |D |10 |5 | |19| └─HASH JOIN | |24 |925 | |20| ├─HASH JOIN | |298 |161 | |21| │ ├─SUBPLAN SCAN |CDB_OB_LS_LOCATIONS |2 |9 | |22| │ │ └─UNION ALL | |2 |9 | |23| │ │ ├─TABLE FULL SCAN |__ALL_VIRTUAL_CORE_META_TABLE |1 |3 | |24| │ │ └─TABLE RANGE SCAN |__ALL_VIRTUAL_LS_META_TABLE |1 |6 | |25| │ └─SUBPLAN SCAN |CDB_OB_TABLET_TO_LS |447 |105 | |26| │ └─UNION ALL | |447 |104 | |27| │ ├─TABLE FULL SCAN |__ALL_VIRTUAL_CORE_ALL_TABLE |16 |5 | |28| │ ├─TABLE FULL SCAN |__ALL_VIRTUAL_TABLE |429 |94 | |29| │ └─TABLE FULL SCAN |__ALL_VIRTUAL_TABLET_TO_LS |2 |4 | |30| └─SUBPLAN SCAN |A |846 |577 | |31| └─UNION ALL | |846 |575 | |32| ├─TABLE FULL SCAN |__ALL_VIRTUAL_CORE_ALL_TABLE |15 |6 | |33| ├─TABLE FULL SCAN |__ALL_VIRTUAL_TABLE |829 |210 | |34| ├─MERGE JOIN | |2 |177 | |35| │ ├─TABLE FULL SCAN |P |1 |4 | |36| │ └─TABLE FULL SCAN |T |829 |171 | |37| └─MERGE JOIN | |2 |181 | |38| ├─MERGE JOIN | |1 |8 | |39| │ ├─TABLE FULL SCAN|P |1 |4 | |40| │ └─TABLE FULL SCAN|Q |1 |4 | |41| └─TABLE FULL SCAN |T |829 |171 | ================================================================================================================ Outputs & filters: ------------------------------------- 0 - output([t.TENANT_NAME(0xffde132eff70)], [round(T_FUN_SUM(t2.DATA_SIZE(0xffde132f31c0))(0xffde132f09a0) / cast(1024, DECIMAL(4, 0))(0xffde132fa040)(0xffde132f12d0) / cast(1024, DECIMAL(4, 0))(0xffde132fad30)(0xffde132f1c50) / cast(1024, DECIMAL(4, 0))(0xffde132fba20)(0xffde132f25d0), 2)(0xffde132f0260)], [round(T_FUN_SUM(t2.REQUIRED_SIZE(0xffde132f6670))(0xffde13 2f3e50) / cast(1024, DECIMAL(4, 0))(0xffde132f7190)(0xffde132f4780) / cast(1024, DECIMAL(4, 0))(0xffde132f7e80)(0xffde132f5100) / cast(1024, DECIMAL(4, 0))(0xffde132f8b70)(0xffde132f5a80), 2)(0xffde132f3710)]), filter(nil) sort_keys([round(T_FUN_SUM(t2.REQUIRED_SIZE(0xffde132f6670))(0xffde132f3e50) / cast(1024, DECIMAL(4, 0))(0xffde132f7190)(0xffde132f4780) / cast(1024, DECIMAL(4, 0))(0xffde132f7e80)(0xffde132f5100) / cast(1024, DECIMAL(4, 0))(0xffde132f8b70)(0xffde132f5a80), 2)(0xffde132f3710), DESC]) 1 - output([round(T_FUN_SUM(t2.REQUIRED_SIZE(0xffde132f6670))(0xffde132f3e50) / cast(1024, DECIMAL(4, 0))(0xffde132f7190)(0xffde132f4780) / cast(1024, DECIMAL(4, 0))(0xffde132f7e80)(0xffde132f5100) / cast(1024, DECIMAL(4, 0))(0xffde132f8b70)(0xffde132f5a80), 2)(0xffde132f3710)], [t.TENANT_NAME(0xffde132eff70)], [T_FUN_SUM(t2.DATA_SIZE(0xffde132f31c0))(0xffde132f09a0)]), filter(nil) group([t.TENANT_NAME(0xffde132eff70)]), agg_func([T_FUN_SUM(t2.DATA_SIZE(0xffde132f31c0))(0xffde132f09a0)], [T_FUN_SUM(t2.REQUIRED_SIZE(0xffde132f6670))(0xffde132f3e50)]) 2 - output([t.TENANT_NAME(0xffde132eff70)], [t2.DATA_SIZE(0xffde132f31c0)], [t2.REQUIRED_SIZE(0xffde132f6670)]), filter(nil) equal_conds([t.TENANT_ID(0xffde132e9f90) = t1.TENANT_ID(0xffde132ea280)(0xffde132e9840)]), other_conds(nil) merge_directions([ASC]) 3 - output([t.TENANT_ID(0xffde132e9f90)], [t.TENANT_NAME(0xffde132eff70)]), filter(nil) access([t.TENANT_ID(0xffde132e9f90)], [t.TENANT_NAME(0xffde132eff70)]) 4 - output([A.tenant_id(0xffde0a254540)], [A.tenant_name(0xffde0a287940)]), filter(nil) conds([A.tenant_id(0xffde0a254540) = C.TENANT_ID(0xffde0a270730)(0xffde0a26f220) OR A.tenant_id(0xffde0a254540) = C.META_TENANT_ID(0xffde0a270a30)(0xffde0a26ff50)(0xffde0a26e520)]), nl_params_(nil), use_batch=false 5 - output([A.tenant_id(0xffde0a254540)], [A.tenant_name(0xffde0a287940)]), filter(nil) access([A.tenant_id(0xffde0a254540)], [A.tenant_name(0xffde0a287940)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([A.tenant_id(0xffde0a254540)]), range(MIN ; MAX)always true 6 - output([C.TENANT_ID(0xffde0a270730)], [C.META_TENANT_ID(0xffde0a270a30)]), filter(nil) 7 - output([C.TENANT_ID(0xffde0a270730)], [C.META_TENANT_ID(0xffde0a270a30)]), filter(nil) access([C.TENANT_ID(0xffde0a270730)], [C.META_TENANT_ID(0xffde0a270a30)]) 8 - output([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0xffde0a2672e0)], [CASE WHEN __ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0xffde0a2672e0) < 1(0xffde0a268370) THEN NULL WHEN __ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0xffde0a2672e0) != 1(0xffde0a269270) THEN __ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0xffde0a2672e0) - 1(0xffde0a269ef0) ELSE NULL END(0xffde0a2675d0)]), filter(nil) distinct([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0xffde0a2672e0)]) 9 - output([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0xffde0a2672e0)]), filter(nil) access([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0xffde0a2672e0)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.resource_pool_id(0xffde1331e470)]), range(MIN ; MAX)always true 10 - output([t1.TENANT_ID(0xffde132ea280)], [t2.DATA_SIZE(0xffde132f31c0)], [t2.REQUIRED_SIZE(0xffde132f6670)]), filter(nil) equal_conds([t1.TENANT_ID(0xffde132ea280) = t2.TENANT_ID(0xffde132ecb40)(0xffde132ec3e0)], [t1.TABLET_ID(0xffde132ef3f0) = t2.TABLET_ID(0xffde132ef6e0)(0xffde132eeca0)], [t1.LS_ID(0xffde132ede20) = t2.LS_ID(0xffde132ee110)(0xffde132ed6d0)], [t1.SVR_IP(0xffde132eb560) = t2.SVR_IP(0xffde132eb850)(0xffde132eae10)]), other_conds(nil) merge_directions([ASC], [ASC], [ASC], [ASC]) 11 - output([t2.TENANT_ID(0xffde132ecb40)], [t2.TABLET_ID(0xffde132ef6e0)], [t2.SVR_IP(0xffde132eb850)], [t2.LS_ID(0xffde132ee110)], [t2.DATA_SIZE(0xffde132f31c0)], [t2.REQUIRED_SIZE(0xffde132f6670)]), filter(nil) access([t2.TENANT_ID(0xffde132ecb40)], [t2.TABLET_ID(0xffde132ef6e0)], [t2.SVR_IP(0xffde132eb850)], [t2.LS_ID(0xffde132ee110)], [t2.DATA_SIZE(0xffde132f31c0)], [t2.REQUIRED_SIZE(0xffde132f6670)]) 12 - output([__ALL_VIRTUAL_TABLET_META_TABLE.tenant_id(0xffde132e5540)], [__ALL_VIRTUAL_TABLET_META_TABLE.tablet_id(0xffde132e5b40)], [__ALL_VIRTUAL_TABLET_META_TABLE.svr_ip(0xffde132e6140)], [__ALL_VIRTUAL_TABLET_META_TABLE.ls_id(0xffde132e6d40)], [__ALL_VIRTUAL_TABLET_META_TABLE.data_size(0xffde132e7940)], [__ALL_VIRTUAL_TABLET_META_TABLE.required_size(0xffde132e7f40)]), filter(nil) access([__ALL_VIRTUAL_TABLET_META_TABLE.tenant_id(0xffde132e5540)], [__ALL_VIRTUAL_TABLET_META_TABLE.tablet_id(0xffde132e5b40)], [__ALL_VIRTUAL_TABLET_META_TABLE.ls_id(0xffde132e6d40)], [__ALL_VIRTUAL_TABLET_META_TABLE.svr_ip(0xffde132e6140)], [__ALL_VIRTUAL_TABLET_META_TABLE.data_size(0xffde132e7940)], [__ALL_VIRTUAL_TABLET_META_TABLE.required_size(0xffde132e7f40)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([__ALL_VIRTUAL_TABLET_META_TABLE.tenant_id(0xffde132e5540)], [__ALL_VIRTUAL_TABLET_META_TABLE.tablet_id(0xffde132e5b40)], [__ALL_VIRTUAL_TABLET_META_TABLE.ls_id(0xffde132e6d40)], [__ALL_VIRTUAL_TABLET_META_TABLE.svr_ip(0xffde132e6140)], [__ALL_VIRTUAL_TABLET_META_TABLE.svr_port(0xffde132e6740)]), range(MIN,MIN,MIN,MIN,MIN ; MAX, MAX,MAX,MAX,MAX)always true 13 - output([t1.TENANT_ID(0xffde132ea280)], [t1.TABLET_ID(0xffde132ef3f0)], [t1.LS_ID(0xffde132ede20)], [t1.SVR_IP(0xffde132eb560)]), filter(nil) sort_keys([t1.TENANT_ID(0xffde132ea280), ASC], [t1.TABLET_ID(0xffde132ef3f0), ASC], [t1.LS_ID(0xffde132ede20), ASC], [t1.SVR_IP(0xffde132eb560), ASC]) 14 - output([t1.TENANT_ID(0xffde132ea280)], [t1.TABLET_ID(0xffde132ef3f0)], [t1.LS_ID(0xffde132ede20)], [t1.SVR_IP(0xffde132eb560)]), filter(nil) access([t1.TENANT_ID(0xffde132ea280)], [t1.TABLET_ID(0xffde132ef3f0)], [t1.LS_ID(0xffde132ede20)], [t1.SVR_IP(0xffde132eb560)]) 15 - output([A.TENANT_ID(0xffde0a3fd7c0)], [A.TABLET_ID(0xffde0a3fc230)], [C.LS_ID(0xffde13285a70)], [C.SVR_IP(0xffde132a2af0)]), filter(nil) equal_conds([A.TABLEGROUP_ID(0xffde1328cd50) = TG.tablegroup_id(0xffde1328d040)(0xffde1328c600)], [A.TENANT_ID(0xffde0a3fd7c0) = TG.tenant_id(0xffde1328e2f0)(0xffde1328db90)]), other_conds(nil) 16 - output([TG.tenant_id(0xffde1328e2f0)], [TG.tablegroup_id(0xffde1328d040)]), filter(nil) access([TG.tenant_id(0xffde1328e2f0)], [TG.tablegroup_id(0xffde1328d040)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([TG.tenant_id(0xffde1328e2f0)], [TG.tablegroup_id(0xffde1328d040)]), range(MIN,MIN ; MAX,MAX)always true 17 - output([A.TENANT_ID(0xffde0a3fd7c0)], [A.TABLET_ID(0xffde0a3fc230)], [C.LS_ID(0xffde13285a70)], [C.SVR_IP(0xffde132a2af0)], [A.TABLEGROUP_ID(0xffde1328cd50)]), filter(nil) equal_conds([A.TENANT_ID(0xffde0a3fd7c0) = D.tenant_id(0xffde132882f0)(0xffde13287b90)], [A.DATABASE_ID(0xffde13289590) = D.database_id(0xffde13289880)(0xffde13288e40)]), other_conds(nil) 18 - output([D.tenant_id(0xffde132882f0)], [D.database_id(0xffde13289880)]), filter(nil) access([D.tenant_id(0xffde132882f0)], [D.database_id(0xffde13289880)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([D.tenant_id(0xffde132882f0)], [D.database_id(0xffde13289880)]), range(MIN,MIN ; MAX,MAX)always true 19 - output([A.TENANT_ID(0xffde0a3fd7c0)], [A.TABLET_ID(0xffde0a3fc230)], [C.LS_ID(0xffde13285a70)], [C.SVR_IP(0xffde132a2af0)], [A.DATABASE_ID(0xffde13289590)], [A.TABLEGROUP_ID(0xffde1328cd50)]), filter(nil) equal_conds([A.TENANT_ID(0xffde0a3fd7c0) = C.TENANT_ID(0xffde13286d20)(0xffde132865c0)], [A.TABLET_ID(0xffde0a3fc230) = B.TABLET_ID(0xffde0a3fc520)(0xffde0a3fbae0)], [A.TENANT_ID(0xffde0a3fd7c0) = B.TENANT_ID(0xffde0a3fdab0)(0xffde0a3fd070)]), other_conds(nil) 20 - output([C.LS_ID(0xffde13285a70)], [C.SVR_IP(0xffde132a2af0)], [C.TENANT_ID(0xffde13286d20)], [B.TABLET_ID(0xffde0a3fc520)], [B.TENANT_ID(0xffde0a3fdab0)]), filter(nil) equal_conds([B.LS_ID(0xffde13285780) = C.LS_ID(0xffde13285a70)(0xffde13285030)]), other_conds(nil) 21 - output([C.TENANT_ID(0xffde13286d20)], [C.LS_ID(0xffde13285a70)], [C.SVR_IP(0xffde132a2af0)]), filter(nil) access([C.TENANT_ID(0xffde13286d20)], [C.LS_ID(0xffde13285a70)], [C.SVR_IP(0xffde132a2af0)]) 22 - output([UNION([1])(0xffde132728c0)], [UNION([2])(0xffde13272b10)], [UNION([3])(0xffde13272d60)]), filter(nil) 23 - output([__ALL_VIRTUAL_CORE_META_TABLE.tenant_id(0xffde13237590)], [__ALL_VIRTUAL_CORE_META_TABLE.ls_id(0xffde13237b90)], [__ALL_VIRTUAL_CORE_META_TABLE.svr_ip(0xffde13238190)]), filter(nil) access([__ALL_VIRTUAL_CORE_META_TABLE.tenant_id(0xffde13237590)], [__ALL_VIRTUAL_CORE_META_TABLE.ls_id(0xffde13237b90)], [__ALL_VIRTUAL_CORE_META_TABLE.svr_ip(0xffde13238190)]), partitions(p1) is_index_back=false, is_global_index=false, range_key(nil), range(MIN ; MAX) 24 - output([__ALL_VIRTUAL_LS_META_TABLE.tenant_id(0xffde1325d0d0)], [__ALL_VIRTUAL_LS_META_TABLE.ls_id(0xffde1325e840)], [__ALL_VIRTUAL_LS_META_TABLE.svr_ip(0xffde1325ee40)]), filter([__ALL_VIRTUAL_L S_META_TABLE.tenant_id(0xffde1325d0d0) != 1(0xffde1325c980)]) access([__ALL_VIRTUAL_LS_META_TABLE.tenant_id(0xffde1325d0d0)], [__ALL_VIRTUAL_LS_META_TABLE.ls_id(0xffde1325e840)], [__ALL_VIRTUAL_LS_META_TABLE.svr_ip(0xffde1325ee40)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([__ALL_VIRTUAL_LS_META_TABLE.tenant_id(0xffde1325d0d0)], [__ALL_VIRTUAL_LS_META_TABLE.ls_id(0xffde1325e840)], [__ALL_VIRTUAL_LS_META_TABLE.svr_ip(0xffde1325ee40)], [__ALL_VIRTUAL_LS_META_TABLE.svr_port(0xffde1325f440)]), 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(0xffde1325d0d0) != 1(0xffde1325c980)]) 25 - output([B.TABLET_ID(0xffde0a3fc520)], [B.TENANT_ID(0xffde0a3fdab0)], [B.LS_ID(0xffde13285780)]), filter(nil) access([B.TABLET_ID(0xffde0a3fc520)], [B.TENANT_ID(0xffde0a3fdab0)], [B.LS_ID(0xffde13285780)]) 26 - output([UNION([1])(0xffde0a3f9c00)], [UNION([2])(0xffde0a3f9e50)], [UNION([3])(0xffde0a3fa0a0)]), filter(nil) 27 - output([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id(0xffde0a3c51e0)], [cast(__ALL_VIRTUAL_CORE_ALL_TABLE.table_id(0xffde0a3c6320), BIGINT(0, 0))(0xffde0a3c54d0)], [cast(1, BIGINT(0, 0))(0xffde0a3c6690)]), filter(nil) access([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id(0xffde0a3c51e0)], [__ALL_VIRTUAL_CORE_ALL_TABLE.table_id(0xffde0a3c6320)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id(0xffde0a3c51e0)], [__ALL_VIRTUAL_CORE_ALL_TABLE.table_id(0xffde0a3c6320)]), range(MIN,MIN ; MAX, MAX)always true 28 - output([__ALL_VIRTUAL_TABLE.tenant_id(0xffde0a3e1fc0)], [cast(__ALL_VIRTUAL_TABLE.table_id(0xffde0a3e0220), BIGINT(0, 0))(0xffde0a3e22b0)], [cast(1, BIGINT(0, 0))(0xffde0a3e3190)]), filter([(T_OP_OR, __ALL_VIRTUAL_TABLE.table_id(0xffde0a3e0220) > 0(0xffde0a3dabc0) AND __ALL_VIRTUAL_TABLE.table_id(0xffde0a3e0220) < 10000(0xffde0a3db840)(0xffde0a3d9f40), __ALL_VIRTUAL_TABLE.table_id(0xffde0a3e0220) > 50000(0xffde0a3dcbc0) AND __ALL_VIRTUAL_TABLE.table_id(0xffde0a3e0220) < 70000(0xffde0a3dd870)(0xffde0a3dbf40), __ALL_VIRTUAL_TABLE.table_id(0xffde0a3e0220) > 100000(0xffde0a3debf0) AND __ALL_VIRTUAL_TABLE.table_id(0xffde0a3e0220) < 200000(0xffde0a3df870)(0xffde0a3ddf70))(0xffde0a3d9840)]) access([__ALL_VIRTUAL_TABLE.tenant_id(0xffde0a3e1fc0)], [__ALL_VIRTUAL_TABLE.table_id(0xffde0a3e0220)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([__ALL_VIRTUAL_TABLE.tenant_id(0xffde0a3e1fc0)], [__ALL_VIRTUAL_TABLE.table_id(0xffde0a3e0220)]), range(MIN,MIN ; MAX,MAX)always true 29 - output([__ALL_VIRTUAL_TABLET_TO_LS.tenant_id(0xffde0a3f6e10)], [__ALL_VIRTUAL_TABLET_TO_LS.tablet_id(0xffde0a3f7410)], [__ALL_VIRTUAL_TABLET_TO_LS.ls_id(0xffde0a3f7a10)]), filter(nil) access([__ALL_VIRTUAL_TABLET_TO_LS.tenant_id(0xffde0a3f6e10)], [__ALL_VIRTUAL_TABLET_TO_LS.tablet_id(0xffde0a3f7410)], [__ALL_VIRTUAL_TABLET_TO_LS.ls_id(0xffde0a3f7a10)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([__ALL_VIRTUAL_TABLET_TO_LS.tenant_id(0xffde0a3f6e10)], [__ALL_VIRTUAL_TABLET_TO_LS.tablet_id(0xffde0a3f7410)]), range(MIN,MIN ; MAX,MAX)always true 30 - output([A.TENANT_ID(0xffde0a3fd7c0)], [A.DATABASE_ID(0xffde13289590)], [A.TABLET_ID(0xffde0a3fc230)], [A.TABLEGROUP_ID(0xffde1328cd50)]), filter(nil) access([A.TENANT_ID(0xffde0a3fd7c0)], [A.DATABASE_ID(0xffde13289590)], [A.TABLET_ID(0xffde0a3fc230)], [A.TABLEGROUP_ID(0xffde1328cd50)]) 31 - output([UNION([1])(0xffde0a398230)], [UNION([2])(0xffde0a398480)], [UNION([3])(0xffde0a399260)], [UNION([4])(0xffde0a399ba0)]), filter(nil) 32 - output([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id(0xffde0a33d840)], [__ALL_VIRTUAL_CORE_ALL_TABLE.database_id(0xffde0a33de40)], [__ALL_VIRTUAL_CORE_ALL_TABLE.tablet_id(0xffde0a33cff0)], [__ALL_VIRTUAL_CORE_ALL_TABLE.tablegroup_id(0xffde0a340da0)]), filter([__ALL_VIRTUAL_CORE_ALL_TABLE.tablet_id(0xffde0a33cff0) != 0(0xffde0a33c8a0)]) access([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id(0xffde0a33d840)], [__ALL_VIRTUAL_CORE_ALL_TABLE.tablet_id(0xffde0a33cff0)], [__ALL_VIRTUAL_CORE_ALL_TABLE.database_id(0xffde0a33de40)], [__ALL_VIRTUAL_CORE_ALL_TABLE.tablegroup_id(0xffde0a340da0)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id(0xffde0a33d840)], [__ALL_VIRTUAL_CORE_ALL_TABLE.table_id(0xffde0a33ea40)]), range(MIN,MIN ; MAX, MAX)always true 33 - output([__ALL_VIRTUAL_TABLE.tenant_id(0xffde0a357a00)], [__ALL_VIRTUAL_TABLE.database_id(0xffde0a358000)], [__ALL_VIRTUAL_TABLE.tablet_id(0xffde0a355f90)], [__ALL_VIRTUAL_TABLE.tablegroup_id(0xffde0a35af60)]), filter([__ALL_VIRTUAL_TABLE.part_level(0xffde0a3571b0) = 0(0xffde0a356a60)], [__ALL_VIRTUAL_TABLE.tablet_id(0xffde0a355f90) != 0(0xffde0a355840)]) access([__ALL_VIRTUAL_TABLE.tenant_id(0xffde0a357a00)], [__ALL_VIRTUAL_TABLE.tablet_id(0xffde0a355f90)], [__ALL_VIRTUAL_TABLE.part_level(0xffde0a3571b0)], [__ALL_VIRTUAL_TABLE.database_id(0xffde0a358000)], [__ALL_VIRTUAL_TABLE.tablegroup_id(0xffde0a35af60)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false,false], range_key([__ALL_VIRTUAL_TABLE.tenant_id(0xffde0a357a00)], [__ALL_VIRTUAL_TABLE.table_id(0xffde0a358c00)]), range(MIN,MIN ; MAX,MAX)always true 34 - output([P.tenant_id(0xffde0a370430)], [T.database_id(0xffde0a3721c0)], [P.tablet_id(0xffde0a373f70)], [T.tablegroup_id(0xffde0a375770)]), filter(nil) equal_conds([T.tenant_id(0xffde0a370140) = P.tenant_id(0xffde0a370430)(0xffde0a36f9f0)], [T.table_id(0xffde0a36ebb0) = P.table_id(0xffde0a36eea0)(0xffde0a36e460)]), other_conds(nil) merge_directions([ASC], [ASC]) 35 - output([P.tenant_id(0xffde0a370430)], [P.table_id(0xffde0a36eea0)], [P.tablet_id(0xffde0a373f70)]), filter(nil) access([P.tenant_id(0xffde0a370430)], [P.table_id(0xffde0a36eea0)], [P.tablet_id(0xffde0a373f70)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([P.tenant_id(0xffde0a370430)], [P.table_id(0xffde0a36eea0)], [P.part_id(0xffde0a373970)]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true 36 - output([T.tenant_id(0xffde0a370140)], [T.table_id(0xffde0a36ebb0)], [T.database_id(0xffde0a3721c0)], [T.tablegroup_id(0xffde0a375770)]), filter([T.part_level(0xffde0a371650) = 1(0xffde0a370f00)]) access([T.tenant_id(0xffde0a370140)], [T.table_id(0xffde0a36ebb0)], [T.part_level(0xffde0a371650)], [T.database_id(0xffde0a3721c0)], [T.tablegroup_id(0xffde0a375770)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([T.tenant_id(0xffde0a370140)], [T.table_id(0xffde0a36ebb0)]), range(MIN,MIN ; MAX,MAX)always true 37 - output([T.tenant_id(0xffde0a38d060)], [T.database_id(0xffde0a390390)], [Q.tablet_id(0xffde0a3924b0)], [T.tablegroup_id(0xffde0a395bc0)]), filter(nil) equal_conds([T.tenant_id(0xffde0a38d060) = P.tenant_id(0xffde0a38d350)(0xffde0a38c910)], [T.table_id(0xffde0a389290) = P.table_id(0xffde0a389580)(0xffde0a388b40)]), other_conds(nil) merge_directions([ASC], [ASC]) 38 - output([Q.tablet_id(0xffde0a3924b0)], [P.tenant_id(0xffde0a38d350)], [P.table_id(0xffde0a389580)]), filter(nil) equal_conds([P.tenant_id(0xffde0a38d350) = Q.tenant_id(0xffde0a38e600)(0xffde0a38dea0)], [P.table_id(0xffde0a389580) = Q.table_id(0xffde0a38a830)(0xffde0a38a0d0)], [P.part_id(0xffde0a38bad0) = Q.part_id(0xffde0a38bdc0)(0xffde0a38b380)]), other_conds(nil) merge_directions([ASC], [ASC], [ASC]) 39 - output([P.tenant_id(0xffde0a38d350)], [P.table_id(0xffde0a389580)], [P.part_id(0xffde0a38bad0)]), filter(nil) access([P.tenant_id(0xffde0a38d350)], [P.table_id(0xffde0a389580)], [P.part_id(0xffde0a38bad0)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([P.tenant_id(0xffde0a38d350)], [P.table_id(0xffde0a389580)], [P.part_id(0xffde0a38bad0)]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true 40 - output([Q.tenant_id(0xffde0a38e600)], [Q.table_id(0xffde0a38a830)], [Q.part_id(0xffde0a38bdc0)], [Q.tablet_id(0xffde0a3924b0)]), filter(nil) access([Q.tenant_id(0xffde0a38e600)], [Q.table_id(0xffde0a38a830)], [Q.part_id(0xffde0a38bdc0)], [Q.tablet_id(0xffde0a3924b0)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([Q.tenant_id(0xffde0a38e600)], [Q.table_id(0xffde0a38a830)], [Q.part_id(0xffde0a38bdc0)], [Q.sub_part_id(0xffde0a391eb0)]), range(MIN,MIN, MIN,MIN ; MAX,MAX,MAX,MAX)always true 41 - output([T.tenant_id(0xffde0a38d060)], [T.table_id(0xffde0a389290)], [T.database_id(0xffde0a390390)], [T.tablegroup_id(0xffde0a395bc0)]), filter([T.part_level(0xffde0a38f820) = 2(0xffde0a38f0d0)]) access([T.tenant_id(0xffde0a38d060)], [T.table_id(0xffde0a389290)], [T.part_level(0xffde0a38f820)], [T.database_id(0xffde0a390390)], [T.tablegroup_id(0xffde0a395bc0)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([T.tenant_id(0xffde0a38d060)], [T.table_id(0xffde0a389290)]), range(MIN,MIN ; MAX,MAX)always true Used Hint: ------------------------------------- /*+ */ Qb name trace: ------------------------------------- stmt_id:0, stmt_type:T_EXPLAIN stmt_id:1, SEL$1 > SEL$C1AAFB47 stmt_id:2, SEL$2 > SEL$B1ECDC80 > SEL$10B20A2A stmt_id:3, SEL$3 > SEL$C6E3AFCA > SEL$BAF9C0FC stmt_id:4, SEL$4 > SEL$CE31B455 stmt_id:5, SEL$5 > SEL$E072F116 > SEL$9C6ED978 stmt_id:6, SET$1 > SET$F1DE0E82 stmt_id:7, SEL$6 stmt_id:8, SEL$7 stmt_id:9, SEL$8 > SEL$2DAF0EAD stmt_id:10, SEL$9 stmt_id:11, SET$2 stmt_id:12, SEL$10 stmt_id:13, SEL$11 stmt_id:14, SEL$12 stmt_id:15, SET$3 > SET$07F8DF3F stmt_id:16, SEL$13 stmt_id:17, SEL$14 stmt_id:18, SEL$15 > SEL$E8F52B00 Outline Data: ------------------------------------- /*+ BEGIN_OUTLINE_DATA USE_HASH_AGGREGATION(@"SEL$C1AAFB47") LEADING(@"SEL$C1AAFB47" ("t"@"SEL$1" ("t2"@"SEL$1" "t1"@"SEL$1"))) USE_MERGE(@"SEL$C1AAFB47" ("t2"@"SEL$1" "t1"@"SEL$1")) LEADING(@"SEL$10B20A2A" ("oceanbase"."A"@"SEL$2" "C"@"SEL$2")) USE_NL(@"SEL$10B20A2A" "C"@"SEL$2") USE_NL_MATERIALIZATION(@"SEL$10B20A2A" "C"@"SEL$2") FULL(@"SEL$10B20A2A" "A"@"SEL$2") USE_HASH_DISTINCT(@"SEL$BAF9C0FC") FULL(@"SEL$BAF9C0FC" "oceanbase"."__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT"@"SEL$3") USE_MERGE(@"SEL$C1AAFB47" "t1"@"SEL$1") FULL(@"SEL$E8F52B00" "oceanbase"."__ALL_VIRTUAL_TABLET_META_TABLE"@"SEL$15") LEADING(@"SEL$9C6ED978" ("oceanbase"."TG"@"SEL$5" ("oceanbase"."D"@"SEL$5" (("C"@"SEL$5" "B"@"SEL$5") "A"@"SEL$5")))) USE_HASH(@"SEL$9C6ED978" ("oceanbase"."D"@"SEL$5" "C"@"SEL$5" "B"@"SEL$5" "A"@"SEL$5")) FULL(@"SEL$9C6ED978" "TG"@"SEL$5") USE_HASH(@"SEL$9C6ED978" ("C"@"SEL$5" "B"@"SEL$5" "A"@"SEL$5")) FULL(@"SEL$9C6ED978" "D"@"SEL$5") USE_HASH(@"SEL$9C6ED978" "A"@"SEL$5") USE_HASH(@"SEL$9C6ED978" "B"@"SEL$5") FULL(@"SEL$13" "oceanbase"."__ALL_VIRTUAL_CORE_META_TABLE"@"SEL$13") FULL(@"SEL$14" "oceanbase"."__ALL_VIRTUAL_LS_META_TABLE"@"SEL$14") FULL(@"SEL$10" "__ALL_VIRTUAL_CORE_ALL_TABLE"@"SEL$10") FULL(@"SEL$11" "__ALL_VIRTUAL_TABLE"@"SEL$11") FULL(@"SEL$12" "oceanbase"."__ALL_VIRTUAL_TABLET_TO_LS"@"SEL$12") FULL(@"SEL$6" "oceanbase"."__ALL_VIRTUAL_CORE_ALL_TABLE"@"SEL$6") FULL(@"SEL$7" "oceanbase"."__ALL_VIRTUAL_TABLE"@"SEL$7") LEADING(@"SEL$2DAF0EAD" ("oceanbase"."P"@"SEL$8" "oceanbase"."T"@"SEL$8")) USE_MERGE(@"SEL$2DAF0EAD" "oceanbase"."T"@"SEL$8") FULL(@"SEL$2DAF0EAD" "P"@"SEL$8") FULL(@"SEL$2DAF0EAD" "T"@"SEL$8") LEADING(@"SEL$9" (("oceanbase"."P"@"SEL$9" "oceanbase"."Q"@"SEL$9") "oceanbase"."T"@"SEL$9")) USE_MERGE(@"SEL$9" "oceanbase"."T"@"SEL$9") USE_MERGE(@"SEL$9" "oceanbase"."Q"@"SEL$9") FULL(@"SEL$9" "P"@"SEL$9") FULL(@"SEL$9" "Q"@"SEL$9") FULL(@"SEL$9" "T"@"SEL$9") SIMPLIFY_ORDER_BY(@"SEL$1") PROJECT_PRUNE(@"SEL$2") PROJECT_PRUNE(@"SEL$5") PROJECT_PRUNE(@"SEL$15") PROJECT_PRUNE(@"SEL$3") PROJECT_PRUNE(@"SEL$4") PROJECT_PRUNE(@"SET$1") PROJECT_PRUNE(@"SET$3") OUTER_TO_INNER(@"SEL$8") ELIMINATE_JOIN(@"SEL$B1ECDC80" "oceanbase"."B"@"SEL$2" "D"@"SEL$2") PRED_DEDUCE(@"SEL$E072F116") SIMPLIFY_GROUP_BY(@"SEL$C6E3AFCA") OPTIMIZER_FEATURES_ENABLE('4.2.1.0') END_OUTLINE_DATA */ Optimization Info: ------------------------------------- A: table_rows:1 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_tenant_mysql_sys_agent] stats version:1717164012257935 dynamic sampling level:0 __ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT: table_rows:1 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_resource_pool_mysql_sys_agent] stats version:1717164012869057 dynamic sampling level:0 __ALL_VIRTUAL_TABLET_META_TABLE: table_rows:888 physical_range_rows:888 logical_range_rows:888 index_back_rows:0 output_rows:888 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_tablet_meta_table] stats version:1717164010040946 dynamic sampling level:0 TG: table_rows:1 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_tablegroup] stats version:1717164006158044 dynamic sampling level:0 D: table_rows:10 physical_range_rows:10 logical_range_rows:10 index_back_rows:0 output_rows:10 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_database] stats version:1717164006116692 dynamic sampling level:0 __ALL_VIRTUAL_CORE_META_TABLE: table_rows:1 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_core_meta_table] stats version:1717164002369413 dynamic sampling level:0 __ALL_VIRTUAL_LS_META_TABLE: table_rows:1 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_ls_meta_table] stats version:1717164010010619 dynamic sampling level:0 __ALL_VIRTUAL_CORE_ALL_TABLE: table_rows:16 physical_range_rows:16 logical_range_rows:16 index_back_rows:0 output_rows:16 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_core_all_table] stats version:1717164002946906 dynamic sampling level:0 __ALL_VIRTUAL_TABLE: table_rows:1658 physical_range_rows:1658 logical_range_rows:1658 index_back_rows:0 output_rows:428 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_table] stats version:1717164006300209 dynamic sampling level:0 __ALL_VIRTUAL_TABLET_TO_LS: table_rows:2 physical_range_rows:2 logical_range_rows:2 index_back_rows:0 output_rows:2 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_tablet_to_ls] stats version:1717164010059404 dynamic sampling level:0 __ALL_VIRTUAL_CORE_ALL_TABLE: table_rows:16 physical_range_rows:16 logical_range_rows:16 index_back_rows:0 output_rows:15 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_core_all_table] stats version:1717164002946906 dynamic sampling level:0 __ALL_VIRTUAL_TABLE: table_rows:1658 physical_range_rows:1658 logical_range_rows:1658 index_back_rows:0 output_rows:828 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_table] stats version:1717164006300209 dynamic sampling level:0 P: table_rows:1 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_part] stats version:1717164007125291 dynamic sampling level:0 T: table_rows:1658 physical_range_rows:1658 logical_range_rows:1658 index_back_rows:0 output_rows:829 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_table] stats version:1717164006300209 dynamic sampling level:0 P: table_rows:1 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_part] stats version:1717164007125291 dynamic sampling level:0 Q: table_rows:1 physical_range_rows:1 logical_range_rows:1 index_back_rows:0 output_rows:1 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_sub_part] stats version:1717164007293064 dynamic sampling level:0 T: table_rows:1658 physical_range_rows:1658 logical_range_rows:1658 index_back_rows:0 output_rows:829 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_table] stats version:1717164006300209 dynamic sampling level:0 Plan Type: LOCAL Note: Degree of Parallelisim is 1 because of table property