版本: 4.2.5
CDB_OB_TABLET_REPLICAS没法筛选leader分区，是不是得用CDB_OB_TABLE_LOCATIONS ？
SELECT
database_name,
SVR_IP,
COUNT(DISTINCT PARTITION_NAME) AS partition_count,
COUNT(DISTINCT SUBPARTITION_NAME) AS subpartition_count
FROM CDB_OB_TABLE_LOCATIONS
WHERE role = ‘LEADER’
AND PARTITION_NAME IS NOT NULL
AND SUBPARTITION_NAME IS NOT NULL
GROUP BY database_name,svr_ip order by database_name;