----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| =================================================================================================================================================================
|ID|OPERATOR                                 |NAME                                       |EST.ROWS|EST.TIME(us)|REAL.ROWS|REAL.TIME(us)|IO TIME(us)|CPU TIME(us)|
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
|0 |SORT                                     |                                           |1       |1306        |17       |839880       |0          |0           |
|1 |└─HASH GROUP BY                          |                                           |1       |1306        |17       |839880       |0          |0           |
|2 |  └─MERGE JOIN                           |                                           |66      |1298        |22007    |839880       |0          |0           |
|3 |    ├─SUBPLAN SCAN                       |dba_ob_tenants                             |1       |8           |17       |839880       |0          |0           |
|4 |    │ └─NESTED-LOOP OUTER JOIN           |                                           |1       |8           |17       |839880       |0          |0           |
|5 |    │   ├─TABLE FULL SCAN                |A                                          |1       |4           |17       |839880       |0          |0           |
|6 |    │   └─MATERIAL                       |                                           |1       |5           |153      |839880       |0          |0           |
|7 |    │     └─SUBPLAN SCAN                 |C                                          |1       |5           |9        |1055         |0          |0           |
|8 |    │       └─HASH DISTINCT              |                                           |1       |5           |9        |1055         |0          |0           |
|9 |    │         └─TABLE FULL SCAN          |__ALL_VIRTUAL_RESOURCE_POOL_MYSQL_SYS_AGENT|1       |4           |9        |1055         |0          |0           |
|10|    └─MERGE JOIN                         |                                           |66      |1287        |22007    |839880       |0          |0           |
|11|      ├─SUBPLAN SCAN                     |cdb_ob_tablet_replicas                     |888     |131         |22007    |839880       |0          |0           |
|12|      │ └─TABLE FULL SCAN                |__ALL_VIRTUAL_TABLET_META_TABLE            |888     |128         |22007    |839880       |0          |0           |
|13|      └─SORT                             |                                           |24      |947         |22007    |839880       |0          |0           |
|14|        └─SUBPLAN SCAN                   |cdb_ob_table_locations                     |24      |942         |22007    |656342       |0          |0           |
|15|          └─HASH RIGHT OUTER JOIN        |                                           |24      |942         |22007    |656342       |0          |0           |
|16|            ├─TABLE FULL SCAN            |TG                                         |1       |4           |35       |26316        |0          |0           |
|17|            └─HASH JOIN                  |                                           |24      |935         |22007    |656342       |0          |0           |
|18|              ├─TABLE FULL SCAN          |D                                          |10      |5           |118      |38967        |0          |0           |
|19|              └─HASH JOIN                |                                           |24      |925         |22007    |656342       |3089094    |0           |
|20|                ├─HASH JOIN              |                                           |298     |161         |235804   |292265       |0          |0           |
|21|                │ ├─SUBPLAN SCAN         |CDB_OB_LS_LOCATIONS                        |2       |9           |47       |72660        |0          |0           |
|22|                │ │ └─UNION ALL          |                                           |2       |9           |47       |72660        |0          |0           |
|23|                │ │   ├─TABLE FULL SCAN  |__ALL_VIRTUAL_CORE_META_TABLE              |1       |3           |1        |38967        |0          |0           |
|24|                │ │   └─TABLE RANGE SCAN |__ALL_VIRTUAL_LS_META_TABLE                |1       |6           |46       |72660        |0          |0           |
|25|                │ └─SUBPLAN SCAN         |CDB_OB_TABLET_TO_LS                        |447     |105         |22007    |292265       |0          |0           |
|26|                │   └─UNION ALL          |                                           |447     |104         |22007    |292265       |0          |0           |
|27|                │     ├─TABLE FULL SCAN  |__ALL_VIRTUAL_CORE_ALL_TABLE               |16      |5           |272      |107558       |0          |0           |
|28|                │     ├─TABLE FULL SCAN  |__ALL_VIRTUAL_TABLE                        |429     |94          |11897    |251130       |0          |0           |
|29|                │     └─TABLE FULL SCAN  |__ALL_VIRTUAL_TABLET_TO_LS                 |2       |4           |9838     |292265       |0          |0           |
|30|                └─SUBPLAN SCAN           |A                                          |846     |577         |22007    |619370       |0          |0           |
|31|                  └─UNION ALL            |                                           |846     |575         |22007    |619370       |0          |0           |
|32|                    ├─TABLE FULL SCAN    |__ALL_VIRTUAL_CORE_ALL_TABLE               |15      |6           |272      |368232       |0          |0           |
|33|                    ├─TABLE FULL SCAN    |__ALL_VIRTUAL_TABLE                        |829     |210         |13818    |482109       |0          |0           |
|34|                    ├─MERGE JOIN         |                                           |2       |177         |7917     |604502       |0          |0           |
|35|                    │ ├─TABLE FULL SCAN  |P                                          |1       |4           |7917     |604502       |0          |0           |
|36|                    │ └─TABLE FULL SCAN  |T                                          |829     |171         |1680     |841988       |0          |0           |
|37|                    └─MERGE JOIN         |                                           |2       |181         |0        |841988       |0          |0           |
|38|                      ├─MERGE JOIN       |                                           |1       |8           |0        |841988       |0          |0           |
|39|                      │ ├─TABLE FULL SCAN|P                                          |1       |4           |1        |841988       |0          |0           |
|40|                      │ └─TABLE FULL SCAN|Q                                          |1       |4           |0        |841988       |0          |0           |
|41|                      └─TABLE FULL SCAN  |T                                          |829     |171         |0        |841988       |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)
      equal_conds([t.TENANT_ID = t1.TENANT_ID]), other_conds(nil)
      merge_directions([ASC])
  3 - output([t.TENANT_ID], [t.TENANT_NAME]), filter(nil)
      access([t.TENANT_ID], [t.TENANT_NAME])
  4 - 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
  5 - 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
  6 - output([C.TENANT_ID], [C.META_TENANT_ID]), filter(nil)
  7 - output([C.TENANT_ID], [C.META_TENANT_ID]), filter(nil)
      access([C.TENANT_ID], [C.META_TENANT_ID])
  8 - 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])
  9 - 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
 10 - output([t1.TENANT_ID], [t2.DATA_SIZE], [t2.REQUIRED_SIZE]), filter(nil)
      equal_conds([t1.TENANT_ID = t2.TENANT_ID], [t1.TABLET_ID = t2.TABLET_ID], [t1.LS_ID = t2.LS_ID], [t1.SVR_IP = t2.SVR_IP]), other_conds(nil)
      merge_directions([ASC], [ASC], [ASC], [ASC])
 11 - output([t2.TENANT_ID], [t2.TABLET_ID], [t2.SVR_IP], [t2.LS_ID], [t2.DATA_SIZE], [t2.REQUIRED_SIZE]), filter(nil)
      access([t2.TENANT_ID], [t2.TABLET_ID], [t2.SVR_IP], [t2.LS_ID], [t2.DATA_SIZE], [t2.REQUIRED_SIZE])
 12 - 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(nil)
      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, 
      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
 13 - output([t1.TENANT_ID], [t1.TABLET_ID], [t1.LS_ID], [t1.SVR_IP]), filter(nil)
      sort_keys([t1.TENANT_ID, ASC], [t1.TABLET_ID, ASC], [t1.LS_ID, ASC], [t1.SVR_IP, ASC])
 14 - 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])
 15 - output([A.TENANT_ID], [A.TABLET_ID], [C.LS_ID], [C.SVR_IP]), filter(nil)
      equal_conds([A.TABLEGROUP_ID = TG.tablegroup_id], [A.TENANT_ID = TG.tenant_id]), other_conds(nil)
 16 - 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
 17 - output([A.TENANT_ID], [A.TABLET_ID], [C.LS_ID], [C.SVR_IP], [A.TABLEGROUP_ID]), filter(nil)
      equal_conds([A.TENANT_ID = D.tenant_id], [A.DATABASE_ID = D.database_id]), other_conds(nil)
 18 - 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
 19 - output([A.TENANT_ID], [A.TABLET_ID], [C.LS_ID], [C.SVR_IP], [A.DATABASE_ID], [A.TABLEGROUP_ID]), filter(nil)
      equal_conds([A.TENANT_ID = C.TENANT_ID], [A.TABLET_ID = B.TABLET_ID], [A.TENANT_ID = B.TENANT_ID]), other_conds(nil)
 20 - output([C.LS_ID], [C.SVR_IP], [C.TENANT_ID], [B.TABLET_ID], [B.TENANT_ID]), filter(nil)
      equal_conds([B.LS_ID = C.LS_ID]), other_conds(nil)
 21 - output([C.TENANT_ID], [C.LS_ID], [C.SVR_IP]), filter(nil)
      access([C.TENANT_ID], [C.LS_ID], [C.SVR_IP])
 22 - output([UNION([1])], [UNION([2])], [UNION([3])]), filter(nil)
 23 - output([__ALL_VIRTUAL_CORE_META_TABLE.tenant_id], [__ALL_VIRTUAL_CORE_META_TABLE.ls_id], [__ALL_VIRTUAL_CORE_META_TABLE.svr_ip]), filter(nil)
      access([__ALL_VIRTUAL_CORE_META_TABLE.tenant_id], [__ALL_VIRTUAL_CORE_META_TABLE.ls_id], [__ALL_VIRTUAL_CORE_META_TABLE.svr_ip]), 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], [__ALL_VIRTUAL_LS_META_TABLE.ls_id], [__ALL_VIRTUAL_LS_META_TABLE.svr_ip]), filter([__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]), partitions(p1)
      is_index_back=false, is_global_index=false, filter_before_indexback[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])
 25 - output([B.TABLET_ID], [B.TENANT_ID], [B.LS_ID]), filter(nil)
      access([B.TABLET_ID], [B.TENANT_ID], [B.LS_ID])
 26 - output([UNION([1])], [UNION([2])], [UNION([3])]), filter(nil)
 27 - 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
 28 - 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
 29 - 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
 30 - output([A.TENANT_ID], [A.DATABASE_ID], [A.TABLET_ID], [A.TABLEGROUP_ID]), filter(nil)
      access([A.TENANT_ID], [A.DATABASE_ID], [A.TABLET_ID], [A.TABLEGROUP_ID])
 31 - output([UNION([1])], [UNION([2])], [UNION([3])], [UNION([4])]), filter(nil)
 32 - 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])
      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], 
      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], [__ALL_VIRTUAL_TABLE.database_id], [__ALL_VIRTUAL_TABLE.tablet_id], [__ALL_VIRTUAL_TABLE.tablegroup_id]), filter([__ALL_VIRTUAL_TABLE.part_level 
      = 0], [__ALL_VIRTUAL_TABLE.tablet_id != 0])
      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], 
      range_key([__ALL_VIRTUAL_TABLE.tenant_id], [__ALL_VIRTUAL_TABLE.table_id]), range(MIN,MIN ; MAX,MAX)always true
 34 - 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)
      merge_directions([ASC], [ASC])
 35 - output([P.tenant_id], [P.table_id], [P.tablet_id]), filter(nil)
      access([P.tenant_id], [P.table_id], [P.tablet_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
 36 - output([T.tenant_id], [T.table_id], [T.database_id], [T.tablegroup_id]), filter([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], 
      range_key([T.tenant_id], [T.table_id]), range(MIN,MIN ; MAX,MAX)always true
 37 - 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])
 38 - 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])
 39 - 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
 40 - 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
 41 - output([T.tenant_id], [T.table_id], [T.database_id], [T.tablegroup_id]), filter([T.part_level = 2])
      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], 
      range_key([T.tenant_id], [T.table_id]), range(MIN,MIN ; MAX,MAX)always true

 |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.02 sec)