分区统计

SELECT a.*, b.tenant_name, c.zone FROM ( 
  SELECT COUNT(1) cnt, svr_ip, tenant_id FROM __all_virtual_partition_info GROUP BY svr_ip, tenant_id ORDER BY 1 desc
) a,
  __all_tenant b,
  __all_server c
WHERE
  a.tenant_id = b.tenant_id
  AND c.svr_ip = a.svr_ip
order by
  cnt desc;

select zone,p.svr_ip,count(*) as partition_count from __all_virtual_partition_info p 
join __all_server s on p.svr_ip=s.svr_ip group by zone,p.svr_ip order by zone,p.svr_ip

select * from oceanbase.__all_virtual_sys_parameter_stat where name like '%partition_cnt%'