obdiag gather plan_monitor --trace_id YB420BA2D99B-0005EBBFC45D5A00-0-0 --env "{db_connect='-hxx -Pxx -uxx -pxx -Dxx'}" =================================================================================================================== |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| ------------------------------------------------------------------------------------------------------------------- |0 |SORT | |17 |5229 | |1 |└─HASH GROUP BY | |17 |5224 | |2 | └─MERGE JOIN | |13 |5217 | |3 | ├─SUBPLAN SCAN |dba_ob_tenants |18 |16 | |4 | │ └─NESTED-LOOP OUTER JOIN | |18 |16 | |5 | │ ├─TABLE FULL SCAN |A |17 |5 | |6 | │ └─MATERIAL | |9 |9 | |7 | │ └─SUBPLAN SCAN |C |9 |9 | |8 | │ └─HASH DISTINCT | |9 |9 | |9 | │ └─TABLE FULL SCAN |__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT|25 |5 | |10| └─NESTED-LOOP JOIN | |13 |5197 | |11| ├─SUBPLAN SCAN |cdb_ob_table_locations |6 |5076 | |12| │ └─MERGE JOIN | |6 |5076 | |13| │ ├─SORT | |6 |5064 | |14| │ │ └─HASH RIGHT OUTER JOIN | |6 |5062 | |15| │ │ ├─TABLE FULL SCAN |TG |17 |5 | |16| │ │ └─HASH JOIN | |5 |5053 | |17| │ │ ├─NESTED-LOOP JOIN | |137 |3319 | |18| │ │ │ ├─SUBPLAN SCAN |CDB_OB_LS_LOCATIONS |1 |21 | |19| │ │ │ │ └─UNION ALL | |1 |21 | |20| │ │ │ │ ├─PX COORDINATOR | |1 |9 | |21| │ │ │ │ │ └─EXCHANGE OUT DISTR|:EX10000 |1 |9 | |22| │ │ │ │ │ └─TABLE FULL SCAN |__ALL_VIRTUAL_CORE_META_TABLE |1 |9 | |23| │ │ │ │ └─TABLE RANGE SCAN |__ALL_VIRTUAL_LS_META_TABLE |1 |13 | |24| │ │ │ └─SUBPLAN SCAN |A |606 |3283 | |25| │ │ │ └─UNION ALL | |606 |3281 | |26| │ │ │ ├─TABLE FULL SCAN |__ALL_VIRTUAL_CORE_ALL_TABLE |15 |23 | |27| │ │ │ ├─TABLE RANGE SCAN |__ALL_VIRTUAL_TABLE |588 |167 | |28| │ │ │ ├─HASH JOIN | |1 |2943 | |29| │ │ │ │ ├─TABLE RANGE SCAN |P |1 |21 | |30| │ │ │ │ └─TABLE FULL SCAN |T |10006 |2011 | |31| │ │ │ └─MERGE JOIN | |2 |148 | |32| │ │ │ ├─MERGE JOIN | |1 |8 | |33| │ │ │ │ ├─TABLE FULL SCAN |P |1 |4 | |34| │ │ │ │ └─TABLE FULL SCAN |Q |1 |4 | |35| │ │ │ └─TABLE RANGE SCAN |T |589 |139 | |36| │ │ └─SUBPLAN SCAN |CDB_OB_TABLET_TO_LS |5451 |1145 | |37| │ │ └─UNION ALL | |5451 |1131 | |38| │ │ ├─TABLE FULL SCAN |__ALL_VIRTUAL_CORE_ALL_TABLE |272 |20 | |39| │ │ ├─TABLE FULL SCAN |__ALL_VIRTUAL_TABLE |5177 |1093 | |40| │ │ └─TABLE FULL SCAN |__ALL_VIRTUAL_TABLET_TO_LS |2 |4 | |41| │ └─TABLE FULL SCAN |D |120 |11 | |42| └─SUBPLAN SCAN |cdb_ob_tablet_replicas |1 |21 | |43| └─TABLE RANGE SCAN |__ALL_VIRTUAL_TABLET_META_TABLE |1 |21 | =================================================================================================================== Outputs & filters: ------------------------------------- 0 - output([t.TENANT_NAME(0x7fbea40f1bc0)], [round(T_FUN_SUM(t2.DATA_SIZE(0x7fbea40f4e10))(0x7fbea40f25f0) / cast(1024, DECIMAL(4, 0))(0x7fbea40fbd50)(0x7fbea40f2f20) / cast(1024, DECIMAL(4, 0))(0x7fbea40fca40)(0x7fbea40f38a0) / cast(1024, DECIMAL(4, 0))(0x7fbea40fd730)(0x7fbea40f4220), 2)(0x7fbea40f1eb0)], [round(T_FUN_SUM(t2.REQUIRED_SIZE(0x7fbea40f82c0))(0x7fbea4 0f5aa0) / cast(1024, DECIMAL(4, 0))(0x7fbea40f8de0)(0x7fbea40f63d0) / cast(1024, DECIMAL(4, 0))(0x7fbea40f9ad0)(0x7fbea40f6d50) / cast(1024, DECIMAL(4, 0))(0x7fbea40fa7c0)(0x7fbea40f76d0), 2)(0x7fbea40f5360)]), filter(nil) sort_keys([round(T_FUN_SUM(t2.REQUIRED_SIZE(0x7fbea40f82c0))(0x7fbea40f5aa0) / cast(1024, DECIMAL(4, 0))(0x7fbea40f8de0)(0x7fbea40f63d0) / cast(1024, DECIMAL(4, 0))(0x7fbea40f9ad0)(0x7fbea40f6d50) / cast(1024, DECIMAL(4, 0))(0x7fbea40fa7c0)(0x7fbea40f76d0), 2)(0x7fbea40f5360), DESC]) 1 - output([round(T_FUN_SUM(t2.REQUIRED_SIZE(0x7fbea40f82c0))(0x7fbea40f5aa0) / cast(1024, DECIMAL(4, 0))(0x7fbea40f8de0)(0x7fbea40f63d0) / cast(1024, DECIMAL(4, 0))(0x7fbea40f9ad0)(0x7fbea40f6d50) / cast(1024, DECIMAL(4, 0))(0x7fbea40fa7c0)(0x7fbea40f76d0), 2)(0x7fbea40f5360)], [t.TENANT_NAME(0x7fbea40f1bc0)], [T_FUN_SUM(t2.DATA_SIZE(0x7fbea40f4e10))(0x7fbea40f25f0)]), filter(nil) group([t.TENANT_NAME(0x7fbea40f1bc0)]), agg_func([T_FUN_SUM(t2.DATA_SIZE(0x7fbea40f4e10))(0x7fbea40f25f0)], [T_FUN_SUM(t2.REQUIRED_SIZE(0x7fbea40f82c0))(0x7fbea40f5aa0)]) 2 - output([t.TENANT_NAME(0x7fbea40f1bc0)], [t2.DATA_SIZE(0x7fbea40f4e10)], [t2.REQUIRED_SIZE(0x7fbea40f82c0)]), filter(nil) equal_conds([t.TENANT_ID(0x7fbea40ea980) = t1.TENANT_ID(0x7fbea40eac70)(0x7fbea40ea230)]), other_conds(nil) merge_directions([ASC]) 3 - output([t.TENANT_ID(0x7fbea40ea980)], [t.TENANT_NAME(0x7fbea40f1bc0)]), filter(nil) access([t.TENANT_ID(0x7fbea40ea980)], [t.TENANT_NAME(0x7fbea40f1bc0)]) 4 - output([A.tenant_id(0x7fc47c054f00)], [A.tenant_name(0x7fc47c088300)]), filter(nil) conds([A.tenant_id(0x7fc47c054f00) = C.TENANT_ID(0x7fc47c0710f0)(0x7fc47c06fbe0) OR A.tenant_id(0x7fc47c054f00) = C.META_TENANT_ID(0x7fc47c0713f0)(0x7fc47c070910)(0x7fc47c06eee0)]), nl_params_(nil), use_batch=false 5 - output([A.tenant_id(0x7fc47c054f00)], [A.tenant_name(0x7fc47c088300)]), filter(nil) access([A.tenant_id(0x7fc47c054f00)], [A.tenant_name(0x7fc47c088300)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([A.tenant_id(0x7fc47c054f00)]), range(MIN ; MAX)always true 6 - output([C.TENANT_ID(0x7fc47c0710f0)], [C.META_TENANT_ID(0x7fc47c0713f0)]), filter(nil) 7 - output([C.TENANT_ID(0x7fc47c0710f0)], [C.META_TENANT_ID(0x7fc47c0713f0)]), filter(nil) access([C.TENANT_ID(0x7fc47c0710f0)], [C.META_TENANT_ID(0x7fc47c0713f0)]) 8 - output([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0x7fc47c067ca0)], [CASE WHEN __ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0x7fc47c067ca0) < 1(0x7fc47c068d30) THEN NULL WHEN __ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0x7fc47c067ca0) != 1(0x7fc47c069c30) THEN __ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0x7fc47c067ca0) - 1(0x7fc47c06a8b0) ELSE NULL END(0x7fc47c067f90)]), filter(nil) distinct([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0x7fc47c067ca0)]) 9 - output([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0x7fc47c067ca0)]), filter(nil) access([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.tenant_id(0x7fc47c067ca0)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT.resource_pool_id(0x7fbea41201c0)]), range(MIN ; MAX)always true 10 - output([t1.TENANT_ID(0x7fbea40eac70)], [t2.DATA_SIZE(0x7fbea40f4e10)], [t2.REQUIRED_SIZE(0x7fbea40f82c0)]), filter(nil) conds(nil), nl_params_([t1.TENANT_ID(0x7fbea40eac70)(:61)], [t1.LS_ID(0x7fbea40ee810)(:62)], [t1.TABLET_ID(0x7fbea40efde0)(:63)], [t1.SVR_IP(0x7fbea40ebf50)(:64)]), use_batch=false 11 - output([t1.TENANT_ID(0x7fbea40eac70)], [t1.TABLET_ID(0x7fbea40efde0)], [t1.LS_ID(0x7fbea40ee810)], [t1.SVR_IP(0x7fbea40ebf50)]), filter(nil) access([t1.TENANT_ID(0x7fbea40eac70)], [t1.TABLET_ID(0x7fbea40efde0)], [t1.LS_ID(0x7fbea40ee810)], [t1.SVR_IP(0x7fbea40ebf50)]) 12 - output([A.TENANT_ID(0x7fc47c1fe180)], [A.TABLET_ID(0x7fc47c1fcbf0)], [C.LS_ID(0x7fbea4086460)], [C.SVR_IP(0x7fbea40a34e0)]), filter(nil) equal_conds([A.TENANT_ID(0x7fc47c1fe180) = D.tenant_id(0x7fbea4088ce0)(0x7fbea4088580)], [A.DATABASE_ID(0x7fbea4089f80) = D.database_id(0x7fbea408a270)(0x7fbea4089830)]), other_conds(nil) merge_directions([ASC], [ASC]) 13 - output([A.TENANT_ID(0x7fc47c1fe180)], [A.TABLET_ID(0x7fc47c1fcbf0)], [C.LS_ID(0x7fbea4086460)], [C.SVR_IP(0x7fbea40a34e0)], [A.DATABASE_ID(0x7fbea4089f80)]), filter(nil) sort_keys([A.TENANT_ID(0x7fc47c1fe180), ASC], [A.DATABASE_ID(0x7fbea4089f80), ASC]) 14 - output([A.TENANT_ID(0x7fc47c1fe180)], [A.TABLET_ID(0x7fc47c1fcbf0)], [C.LS_ID(0x7fbea4086460)], [C.SVR_IP(0x7fbea40a34e0)], [A.DATABASE_ID(0x7fbea4089f80)]), filter(nil) equal_conds([A.TABLEGROUP_ID(0x7fbea408d740) = TG.tablegroup_id(0x7fbea408da30)(0x7fbea408cff0)], [A.TENANT_ID(0x7fc47c1fe180) = TG.tenant_id(0x7fbea408ece0)(0x7fbea408e580)]), other_conds(nil) 15 - output([TG.tenant_id(0x7fbea408ece0)], [TG.tablegroup_id(0x7fbea408da30)]), filter(nil) access([TG.tenant_id(0x7fbea408ece0)], [TG.tablegroup_id(0x7fbea408da30)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([TG.tenant_id(0x7fbea408ece0)], [TG.tablegroup_id(0x7fbea408da30)]), range(MIN,MIN ; MAX,MAX)always true 16 - output([A.TENANT_ID(0x7fc47c1fe180)], [A.TABLET_ID(0x7fc47c1fcbf0)], [C.LS_ID(0x7fbea4086460)], [C.SVR_IP(0x7fbea40a34e0)], [A.DATABASE_ID(0x7fbea4089f80)], [A.TABLEGROUP_ID(0x7fbea408d740)]), filter(nil) equal_conds([B.LS_ID(0x7fbea4086170) = C.LS_ID(0x7fbea4086460)(0x7fbea4085a20)], [A.TABLET_ID(0x7fc47c1fcbf0) = B.TABLET_ID(0x7fc47c1fcee0)(0x7fc47c1fc4a0)], [A.TENANT_ID(0x7fc47c1fe180) = B.TENANT_ID(0x7fc47c1fe470)(0x7fc47c1fda30)]), other_conds(nil) 17 - output([A.TENANT_ID(0x7fc47c1fe180)], [A.TABLET_ID(0x7fc47c1fcbf0)], [C.LS_ID(0x7fbea4086460)], [C.SVR_IP(0x7fbea40a34e0)], [A.DATABASE_ID(0x7fbea4089f80)], [A.TABLEGROUP_ID(0x7fbea408d740)]), filter(nil) conds(nil), nl_params_([C.TENANT_ID(0x7fbea4087710)(:6)]), use_batch=false 18 - output([C.TENANT_ID(0x7fbea4087710)], [C.LS_ID(0x7fbea4086460)], [C.SVR_IP(0x7fbea40a34e0)]), filter(nil) access([C.TENANT_ID(0x7fbea4087710)], [C.LS_ID(0x7fbea4086460)], [C.SVR_IP(0x7fbea40a34e0)]) 19 - output([UNION([1])(0x7fbea40732b0)], [UNION([2])(0x7fbea4073500)], [UNION([3])(0x7fbea4073750)]), filter(nil) 20 - output([__ALL_VIRTUAL_CORE_META_TABLE.tenant_id(0x7fbea4037f80)], [__ALL_VIRTUAL_CORE_META_TABLE.ls_id(0x7fbea4038580)], [__ALL_VIRTUAL_CORE_META_TABLE.svr_ip(0x7fbea4038b80)]), filter(nil) 21 - output([__ALL_VIRTUAL_CORE_META_TABLE.tenant_id(0x7fbea4037f80)], [__ALL_VIRTUAL_CORE_META_TABLE.ls_id(0x7fbea4038580)], [__ALL_VIRTUAL_CORE_META_TABLE.svr_ip(0x7fbea4038b80)]), filter(nil) is_single, dop=1 22 - output([__ALL_VIRTUAL_CORE_META_TABLE.tenant_id(0x7fbea4037f80)], [__ALL_VIRTUAL_CORE_META_TABLE.ls_id(0x7fbea4038580)], [__ALL_VIRTUAL_CORE_META_TABLE.svr_ip(0x7fbea4038b80)]), filter([CASE WHEN __ALL_VIRTUAL_CORE_META_TABLE.role(0x7fbea403b3a0) = 1(0x7fbea4132b70) THEN 'LEADER' ELSE 'FOLLOWER' END(0x7fbea4132350) = 'leader'(0x7fbe75c2f1f0)]) access([__ALL_VIRTUAL_CORE_META_TABLE.tenant_id(0x7fbea4037f80)], [__ALL_VIRTUAL_CORE_META_TABLE.ls_id(0x7fbea4038580)], [__ALL_VIRTUAL_CORE_META_TABLE.svr_ip(0x7fbea4038b80)], [__ALL_VIRTUAL_CORE_META_TABLE.role(0x7fbea403b3a0)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key(nil), range(MIN ; MAX) 23 - output([__ALL_VIRTUAL_LS_META_TABLE.tenant_id(0x7fbea405dac0)], [__ALL_VIRTUAL_LS_META_TABLE.ls_id(0x7fbea405f230)], [__ALL_VIRTUAL_LS_META_TABLE.svr_ip(0x7fbea405f830)]), filter([CASE WHEN __ALL_VIRTUAL_LS_META_TABLE.role(0x7fbea4062050) = 1(0x7fbea414f450) THEN 'LEADER' ELSE 'FOLLOWER' END(0x7fbea414ec30) = 'leader'(0x7fbe75c2fbe0)], [__ALL_VIRTUAL_LS_META_TABLE.tenant_id(0x7fbea405dac0) != 1(0x7fbea405d370)]) access([__ALL_VIRTUAL_LS_META_TABLE.tenant_id(0x7fbea405dac0)], [__ALL_VIRTUAL_LS_META_TABLE.ls_id(0x7fbea405f230)], [__ALL_VIRTUAL_LS_META_TABLE.svr_ip(0x7fbea405f830)], [__ALL_VIRTUAL_LS_META_TABLE.role(0x7fbea4062050)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false,false], range_key([__ALL_VIRTUAL_LS_META_TABLE.tenant_id(0x7fbea405dac0)], [__ALL_VIRTUAL_LS_META_TABLE.ls_id(0x7fbea405f230)], [__ALL_VIRTUAL_LS_META_TABLE.svr_ip(0x7fbea405f830)], [__ALL_VIRTUAL_LS_META_TABLE.svr_port(0x7fbea405fe30)]), 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(0x7fbea405dac0) != 1(0x7fbea405d370)]) 24 - output([A.TENANT_ID(0x7fc47c1fe180)], [A.DATABASE_ID(0x7fbea4089f80)], [A.TABLET_ID(0x7fc47c1fcbf0)], [A.TABLEGROUP_ID(0x7fbea408d740)]), filter(nil) access([A.TENANT_ID(0x7fc47c1fe180)], [A.DATABASE_ID(0x7fbea4089f80)], [A.TABLET_ID(0x7fc47c1fcbf0)], [A.TABLEGROUP_ID(0x7fbea408d740)]) 25 - output([UNION([1])(0x7fc47c198bf0)], [UNION([2])(0x7fc47c198e40)], [UNION([3])(0x7fc47c199c20)], [UNION([4])(0x7fc47c19a560)]), filter(nil) 26 - output([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id(0x7fc47c13e200)], [__ALL_VIRTUAL_CORE_ALL_TABLE.database_id(0x7fc47c13e800)], [__ALL_VIRTUAL_CORE_ALL_TABLE.tablet_id(0x7fc47c13d9b0)], [__ALL_VIRTUAL_CORE_ALL_TABLE.tablegroup_id(0x7fc47c141760)]), filter([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id(0x7fc47c13e200) = :6(0x7fc09b7aa2c0)], [__ALL_VIRTUAL_CORE_ALL_TABLE.tablet_id(0x7fc47c13d 9b0) != 0(0x7fc47c13d260)]) access([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id(0x7fc47c13e200)], [__ALL_VIRTUAL_CORE_ALL_TABLE.tablet_id(0x7fc47c13d9b0)], [__ALL_VIRTUAL_CORE_ALL_TABLE.database_id(0x7fc47c13e800)], [__ALL_VIRTUAL_CORE_ALL_TABLE.tablegroup_id(0x7fc47c141760)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false,false], range_key([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id(0x7fc47c13e200)], [__ALL_VIRTUAL_CORE_ALL_TABLE.table_id(0x7fc47c13f400)]), range(MIN,MIN ; MAX, MAX)always true 27 - output([__ALL_VIRTUAL_TABLE.tenant_id(0x7fc47c1583c0)], [__ALL_VIRTUAL_TABLE.database_id(0x7fc47c1589c0)], [__ALL_VIRTUAL_TABLE.tablet_id(0x7fc47c156950)], [__ALL_VIRTUAL_TABLE.tablegroup_id(0x7fc47c15b920)]), filter([__ALL_VIRTUAL_TABLE.tenant_id(0x7fc47c1583c0) = :6(0x7fc09b7ef500)], [__ALL_VIRTUAL_TABLE.part_level(0x7fc47c157b70) = 0(0x7fc47c157420)], [__ALL_VIRTUAL_TABLE.tablet_id(0x7fc47c156950) != 0(0x7fc47c156200)]) access([__ALL_VIRTUAL_TABLE.tenant_id(0x7fc47c1583c0)], [__ALL_VIRTUAL_TABLE.tablet_id(0x7fc47c156950)], [__ALL_VIRTUAL_TABLE.part_level(0x7fc47c157b70)], [__ALL_VIRTUAL_TABLE.database_id(0x7fc47c1589c0)], [__ALL_VIRTUAL_TABLE.tablegroup_id(0x7fc47c15b920)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false,false,false], range_key([__ALL_VIRTUAL_TABLE.tenant_id(0x7fc47c1583c0)], [__ALL_VIRTUAL_TABLE.table_id(0x7fc47c1595c0)]), range(MIN,MIN ; MAX,MAX)always true, range_cond([__ALL_VIRTUAL_TABLE.tenant_id(0x7fc47c1583c0) = :6(0x7fc09b7ef500)]) 28 - output([P.tenant_id(0x7fc47c170df0)], [T.database_id(0x7fc47c172b80)], [P.tablet_id(0x7fc47c174930)], [T.tablegroup_id(0x7fc47c176130)]), filter(nil) equal_conds([T.tenant_id(0x7fc47c170b00) = P.tenant_id(0x7fc47c170df0)(0x7fc47c1703b0)], [T.table_id(0x7fc47c16f570) = P.table_id(0x7fc47c16f860)(0x7fc47c16ee20)]), other_conds(nil) 29 - output([P.tenant_id(0x7fc47c170df0)], [P.table_id(0x7fc47c16f860)], [P.tablet_id(0x7fc47c174930)]), filter([P.tenant_id(0x7fc47c170df0) = :6(0x7fb633248a60)]) access([P.tenant_id(0x7fc47c170df0)], [P.table_id(0x7fc47c16f860)], [P.tablet_id(0x7fc47c174930)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([P.tenant_id(0x7fc47c170df0)], [P.table_id(0x7fc47c16f860)], [P.part_id(0x7fc47c174330)]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true, range_cond([P.tenant_id(0x7fc47c170df0) = :6(0x7fb633248a60)]) 30 - output([T.tenant_id(0x7fc47c170b00)], [T.table_id(0x7fc47c16f570)], [T.database_id(0x7fc47c172b80)], [T.tablegroup_id(0x7fc47c176130)]), filter([T.part_level(0x7fc47c172010) = 1(0x7fc47c1718c0)]) access([T.tenant_id(0x7fc47c170b00)], [T.table_id(0x7fc47c16f570)], [T.part_level(0x7fc47c172010)], [T.database_id(0x7fc47c172b80)], [T.tablegroup_id(0x7fc47c176130)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([T.tenant_id(0x7fc47c170b00)], [T.table_id(0x7fc47c16f570)]), range(MIN,MIN ; MAX,MAX)always true 31 - output([T.tenant_id(0x7fc47c18da20)], [T.database_id(0x7fc47c190d50)], [Q.tablet_id(0x7fc47c192e70)], [T.tablegroup_id(0x7fc47c196580)]), filter(nil) equal_conds([T.tenant_id(0x7fc47c18da20) = P.tenant_id(0x7fc47c18dd10)(0x7fc47c18d2d0)], [T.table_id(0x7fc47c189c50) = P.table_id(0x7fc47c189f40)(0x7fc47c189500)]), other_conds(nil) merge_directions([ASC], [ASC]) 32 - output([Q.tablet_id(0x7fc47c192e70)], [P.tenant_id(0x7fc47c18dd10)], [P.table_id(0x7fc47c189f40)]), filter(nil) equal_conds([P.tenant_id(0x7fc47c18dd10) = Q.tenant_id(0x7fc47c18efc0)(0x7fc47c18e860)], [P.table_id(0x7fc47c189f40) = Q.table_id(0x7fc47c18b1f0)(0x7fc47c18aa90)], [P.part_id(0x7fc47c18c490) = Q.part_id(0x7fc47c18c780)(0x7fc47c18bd40)]), other_conds(nil) merge_directions([ASC], [ASC], [ASC]) 33 - output([P.tenant_id(0x7fc47c18dd10)], [P.table_id(0x7fc47c189f40)], [P.part_id(0x7fc47c18c490)]), filter(nil) access([P.tenant_id(0x7fc47c18dd10)], [P.table_id(0x7fc47c189f40)], [P.part_id(0x7fc47c18c490)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([P.tenant_id(0x7fc47c18dd10)], [P.table_id(0x7fc47c189f40)], [P.part_id(0x7fc47c18c490)]), range(MIN,MIN,MIN ; MAX,MAX,MAX)always true 34 - output([Q.tenant_id(0x7fc47c18efc0)], [Q.table_id(0x7fc47c18b1f0)], [Q.part_id(0x7fc47c18c780)], [Q.tablet_id(0x7fc47c192e70)]), filter(nil) access([Q.tenant_id(0x7fc47c18efc0)], [Q.table_id(0x7fc47c18b1f0)], [Q.part_id(0x7fc47c18c780)], [Q.tablet_id(0x7fc47c192e70)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([Q.tenant_id(0x7fc47c18efc0)], [Q.table_id(0x7fc47c18b1f0)], [Q.part_id(0x7fc47c18c780)], [Q.sub_part_id(0x7fc47c192870)]), range(MIN,MIN, MIN,MIN ; MAX,MAX,MAX,MAX)always true 35 - output([T.tenant_id(0x7fc47c18da20)], [T.table_id(0x7fc47c189c50)], [T.database_id(0x7fc47c190d50)], [T.tablegroup_id(0x7fc47c196580)]), filter([T.tenant_id(0x7fc47c18da20) = :6(0x7fb6332a7dc0)], [T.part_level(0x7fc47c1901e0) = 2(0x7fc47c18fa90)]) access([T.tenant_id(0x7fc47c18da20)], [T.table_id(0x7fc47c189c50)], [T.part_level(0x7fc47c1901e0)], [T.database_id(0x7fc47c190d50)], [T.tablegroup_id(0x7fc47c196580)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false,false], range_key([T.tenant_id(0x7fc47c18da20)], [T.table_id(0x7fc47c189c50)]), range(MIN,MIN ; MAX,MAX)always true, range_cond([T.tenant_id(0x7fc47c18da20) = :6(0x7fb6332a7dc0)]) 36 - output([B.TABLET_ID(0x7fc47c1fcee0)], [B.TENANT_ID(0x7fc47c1fe470)], [B.LS_ID(0x7fbea4086170)]), filter(nil) access([B.TABLET_ID(0x7fc47c1fcee0)], [B.TENANT_ID(0x7fc47c1fe470)], [B.LS_ID(0x7fbea4086170)]) 37 - output([UNION([1])(0x7fc47c1fa5c0)], [UNION([2])(0x7fc47c1fa810)], [UNION([3])(0x7fc47c1faa60)]), filter(nil) 38 - output([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id(0x7fc47c1c5ba0)], [cast(__ALL_VIRTUAL_CORE_ALL_TABLE.table_id(0x7fc47c1c6ce0), BIGINT(0, 0))(0x7fc47c1c5e90)], [cast(1, BIGINT(0, 0))(0x7fc47c1c7050)]), filter(nil) access([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id(0x7fc47c1c5ba0)], [__ALL_VIRTUAL_CORE_ALL_TABLE.table_id(0x7fc47c1c6ce0)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([__ALL_VIRTUAL_CORE_ALL_TABLE.tenant_id(0x7fc47c1c5ba0)], [__ALL_VIRTUAL_CORE_ALL_TABLE.table_id(0x7fc47c1c6ce0)]), range(MIN,MIN ; MAX, MAX)always true 39 - output([__ALL_VIRTUAL_TABLE.tenant_id(0x7fc47c1e2980)], [cast(__ALL_VIRTUAL_TABLE.table_id(0x7fc47c1e0be0), BIGINT(0, 0))(0x7fc47c1e2c70)], [cast(1, BIGINT(0, 0))(0x7fc47c1e3b50)]), filter([(T_OP_OR, __ALL_VIRTUAL_TABLE.table_id(0x7fc47c1e0be0) > 0(0x7fc47c1db580) AND __ALL_VIRTUAL_TABLE.table_id(0x7fc47c1e0be0) < 10000(0x7fc47c1dc200)(0x7fc47c1da900), __ALL_VIRTUAL_TABLE.table_id(0x7fc47c1e0be0) > 50000(0x7fc47c1dd580) AND __ALL_VIRTUAL_TABLE.table_id(0x7fc47c1e0be0) < 70000(0x7fc47c1de230)(0x7fc47c1dc900), __ALL_VIRTUAL_TABLE.table_id(0x7fc47c1e0be0) > 100000(0x7fc47c1df5b0) AND __ALL_VIRTUAL_TABLE.table_id(0x7fc47c1e0be0) < 200000(0x7fc47c1e0230)(0x7fc47c1de930))(0x7fc47c1da200)]) access([__ALL_VIRTUAL_TABLE.tenant_id(0x7fc47c1e2980)], [__ALL_VIRTUAL_TABLE.table_id(0x7fc47c1e0be0)]), partitions(p1) is_index_back=false, is_global_index=false, filter_before_indexback[false], range_key([__ALL_VIRTUAL_TABLE.tenant_id(0x7fc47c1e2980)], [__ALL_VIRTUAL_TABLE.table_id(0x7fc47c1e0be0)]), range(MIN,MIN ; MAX,MAX)always true 40 - output([__ALL_VIRTUAL_TABLET_TO_LS.tenant_id(0x7fc47c1f77d0)], [__ALL_VIRTUAL_TABLET_TO_LS.tablet_id(0x7fc47c1f7dd0)], [__ALL_VIRTUAL_TABLET_TO_LS.ls_id(0x7fc47c1f83d0)]), filter(nil) access([__ALL_VIRTUAL_TABLET_TO_LS.tenant_id(0x7fc47c1f77d0)], [__ALL_VIRTUAL_TABLET_TO_LS.tablet_id(0x7fc47c1f7dd0)], [__ALL_VIRTUAL_TABLET_TO_LS.ls_id(0x7fc47c1f83d0)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([__ALL_VIRTUAL_TABLET_TO_LS.tenant_id(0x7fc47c1f77d0)], [__ALL_VIRTUAL_TABLET_TO_LS.tablet_id(0x7fc47c1f7dd0)]), range(MIN,MIN ; MAX,MAX)always true 41 - output([D.tenant_id(0x7fbea4088ce0)], [D.database_id(0x7fbea408a270)]), filter(nil) access([D.tenant_id(0x7fbea4088ce0)], [D.database_id(0x7fbea408a270)]), partitions(p1) is_index_back=false, is_global_index=false, range_key([D.tenant_id(0x7fbea4088ce0)], [D.database_id(0x7fbea408a270)]), range(MIN,MIN ; MAX,MAX)always true 42 - output([t2.DATA_SIZE(0x7fbea40f4e10)], [t2.REQUIRED_SIZE(0x7fbea40f82c0)]), filter(nil) access([t2.DATA_SIZE(0x7fbea40f4e10)], [t2.REQUIRED_SIZE(0x7fbea40f82c0)]) 43 - output([__ALL_VIRTUAL_TABLET_META_TABLE.tenant_id(0x7fbea40e5f30)], [__ALL_VIRTUAL_TABLET_META_TABLE.tablet_id(0x7fbea40e6530)], [__ALL_VIRTUAL_TABLET_META_TABLE.svr_ip(0x7fbea40e6b30)], [__ALL_VIRTUAL_TABLET_META_TABLE.ls_id(0x7fbea40e7730)], [__ALL_VIRTUAL_TABLET_META_TABLE.data_size(0x7fbea40e8330)], [__ALL_VIRTUAL_TABLET_META_TABLE.required_size(0x7fbea40e8930)]), filter([:63 = __ALL_VIRTUAL_TABLET_META_TABLE.tablet_id(0x7fbea40e6530)(0x7fc4f34bdbb0)], [:61 = __ALL_VIRTUAL_TABLET_META_TABLE.tenant_id(0x7fbea40e5f30)(0x7fc4f34bca90)], [:64 = __ALL_VIRTUAL_TABLET_META_TABLE.svr_ip(0x7fbea40e6b30)(0x7fc4f34be440)], [:62 = __ALL_VIRTUAL_TABLET_META_TABLE.ls_id(0x7fbea40e7730)(0x7fc4f34bd320)]) access([__ALL_VIRTUAL_TABLET_META_TABLE.tenant_id(0x7fbea40e5f30)], [__ALL_VIRTUAL_TABLET_META_TABLE.tablet_id(0x7fbea40e6530)], [__ALL_VIRTUAL_TABLET_META_TABLE.ls_id(0x7fbea40e7730)], [__ALL_VIRTUAL_TABLET_META_TABLE.svr_ip(0x7fbea40e6b30)], [__ALL_VIRTUAL_TABLET_META_TABLE.data_size(0x7fbea40e8330)], [__ALL_VIRTUAL_TABLET_META_TABLE.required_size(0x7fbea40e8930)]), 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(0x7fbea40e5f30)], [__ALL_VIRTUAL_TABLET_META_TABLE.tablet_id(0x7fbea40e6530)], [__ALL_VIRTUAL_TABLET_META_TABLE.ls_id(0x7fbea40e7730)], [__ALL_VIRTUAL_TABLET_META_TABLE.svr_ip(0x7fbea40e6b30)], [__ALL_VIRTUAL_TABLET_META_TABLE.svr_port(0x7fbea40e7130)]), range(MIN,MIN,MIN,MIN,MIN ; MAX, MAX,MAX,MAX,MAX)always true, range_cond([:61 = __ALL_VIRTUAL_TABLET_META_TABLE.tenant_id(0x7fbea40e5f30)(0x7fc4f34bca90)], [:62 = __ALL_VIRTUAL_TABLET_META_TABLE.ls_id(0x7fbea40e7730)(0x7fc4f34bd320)], [:63 = __ALL_VIRTUAL_TABLET_META_TABLE.tablet_id(0x7fbea40e6530)(0x7fc4f34bdbb0)], [:64 = __ALL_VIRTUAL_TABLET_META_TABLE.svr_ip(0x7fbea40e6b30)(0x7fc4f34be440)]) Used Hint: ------------------------------------- /*+ */ Qb name trace: ------------------------------------- stmt_id:0, stmt_type:T_EXPLAIN stmt_id:1, SEL$1 > SEL$C1AAFB47 > SEL$9C6ED978 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$ED434F45 > SEL$184C3650 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 > SET$3B393986 stmt_id:16, SEL$13 > SEL$F2C7A788 stmt_id:17, SEL$14 > SEL$5769D34C stmt_id:18, SEL$15 > SEL$E8F52B00 Outline Data: ------------------------------------- /*+ BEGIN_OUTLINE_DATA USE_HASH_AGGREGATION(@"SEL$9C6ED978") LEADING(@"SEL$9C6ED978" ("t"@"SEL$1" ("t1"@"SEL$1" "t2"@"SEL$1"))) USE_MERGE(@"SEL$9C6ED978" ("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_NL(@"SEL$9C6ED978" "t2"@"SEL$1") LEADING(@"SEL$184C3650" (("oceanbase"."TG"@"SEL$5" (("C"@"SEL$5" "A"@"SEL$5") "B"@"SEL$5")) "oceanbase"."D"@"SEL$5")) USE_MERGE(@"SEL$184C3650" "oceanbase"."D"@"SEL$5") USE_HASH(@"SEL$184C3650" ("C"@"SEL$5" "B"@"SEL$5" "A"@"SEL$5")) FULL(@"SEL$184C3650" "TG"@"SEL$5") USE_HASH(@"SEL$184C3650" "B"@"SEL$5") USE_NL(@"SEL$184C3650" "A"@"SEL$5") PQ_SET(@"SET$3B393986" LOCAL LOCAL) FULL(@"SEL$F2C7A788" "oceanbase"."__ALL_VIRTUAL_CORE_META_TABLE"@"SEL$13") FULL(@"SEL$5769D34C" "oceanbase"."__ALL_VIRTUAL_LS_META_TABLE"@"SEL$14") 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_HASH(@"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") 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$184C3650" "D"@"SEL$5") FULL(@"SEL$E8F52B00" "oceanbase"."__ALL_VIRTUAL_TABLET_META_TABLE"@"SEL$15") 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$C1AAFB47") PRED_DEDUCE(@"SEL$E072F116") PRED_DEDUCE(@"SEL$13") PRED_DEDUCE(@"SEL$14") SIMPLIFY_GROUP_BY(@"SEL$C6E3AFCA") PROJECT_PRUNE(@"SEL$ED434F45") PROJECT_PRUNE(@"SET$07F8DF3F") OPTIMIZER_FEATURES_ENABLE('4.2.1.0') END_OUTLINE_DATA */ Optimization Info: ------------------------------------- A: table_rows:17 physical_range_rows:17 logical_range_rows:17 index_back_rows:0 output_rows:17 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_tenant_mysql_sys_agent] stats version:1705327307762099 dynamic sampling level:0 __ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT: table_rows:25 physical_range_rows:25 logical_range_rows:25 index_back_rows:0 output_rows:25 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_resource_pool_mysql_sys_agent] stats version:1705327312321741 dynamic sampling level:0 TG: table_rows:17 physical_range_rows:17 logical_range_rows:17 index_back_rows:0 output_rows:17 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_tablegroup] stats version:1705327233638904 dynamic sampling level:0 __ALL_VIRTUAL_CORE_META_TABLE: table_rows:3 physical_range_rows:3 logical_range_rows:3 index_back_rows:0 output_rows:0 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_core_meta_table] stats version:1705327211037974 dynamic sampling level:0 __ALL_VIRTUAL_LS_META_TABLE: table_rows:99 physical_range_rows:93 logical_range_rows:93 index_back_rows:0 output_rows:0 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_ls_meta_table] stats version:1705327287897984 dynamic sampling level:0 __ALL_VIRTUAL_CORE_ALL_TABLE: table_rows:272 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:1705327214452784 dynamic sampling level:0 __ALL_VIRTUAL_TABLE: table_rows:20012 physical_range_rows:1177 logical_range_rows:1177 index_back_rows:0 output_rows:587 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_table] stats version:1705327237624733 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:1705327252370554 dynamic sampling level:0 T: table_rows:20012 physical_range_rows:20012 logical_range_rows:20012 index_back_rows:0 output_rows:10006 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_table] stats version:1705327237624733 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:1705327252370554 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:1705327253969090 dynamic sampling level:0 T: table_rows:20012 physical_range_rows:1177 logical_range_rows:1177 index_back_rows:0 output_rows:588 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_table] stats version:1705327237624733 dynamic sampling level:0 __ALL_VIRTUAL_CORE_ALL_TABLE: table_rows:272 physical_range_rows:272 logical_range_rows:272 index_back_rows:0 output_rows:272 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_core_all_table] stats version:1705327214452784 dynamic sampling level:0 __ALL_VIRTUAL_TABLE: table_rows:20012 physical_range_rows:20012 logical_range_rows:20012 index_back_rows:0 output_rows:5176 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_table] stats version:1705327237624733 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:1705327288571596 dynamic sampling level:0 D: table_rows:120 physical_range_rows:120 logical_range_rows:120 index_back_rows:0 output_rows:120 table_dop:1 dop_method:Table DOP avaiable_index_name:[__all_virtual_database] stats version:1705327232488554 dynamic sampling level:0 __ALL_VIRTUAL_TABLET_META_TABLE: table_rows:36432 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_tablet_meta_table] stats version:1705327288410394 dynamic sampling level:0 Plan Type: DISTRIBUTED Note: Degree of Parallelisim is 1 because of table property