ClickHouse查询指定数据库表数据量和占用空间大小

select 
  table ,
  sum(rows) / 2,
  formatReadableSize(sum(bytes_on_disk)) AS size 
from system.parts_all 
where database = 'system' --数据库名称，自定义
group by table
order by size ASC;