v6.5.2tidb集群,ticdc同步主备集群当存在数据删除的情况下,主集群不回收空间,只有备集群回收空间

主集群查下regions到底哪个对象占用了,我遇到表分析历史数据占用几百G的问题,sql如下

select DB_NAME,TABLE_NAME,sum(APPROXIMATE_SIZE) from
(
select t.DB_NAME,t.TABLE_NAME,region_id,t.APPROXIMATE_SIZE from information_schema.TIKV_REGION_STATUS t
group by t.DB_NAMe,t.TABLE_NAME,region_id,t.APPROXIMATE_SIZE
) a
group by DB_NAME,TABLE_NAME
order by 3 desc