select
--database,
-- table,
sum(rows) as row ,
formatReadableSize(sum(bytes_on_disk)) as used_disk,
formatReadableSize(sum(data_uncompressed_bytes)) as before_compress,
formatReadableSize(sum(data_compressed_bytes)) as after_compress,
round(sum(data_compressed_bytes) / sum(data_uncompressed_bytes) * 100, 0) compress_rate
from system.parts
where partition = '2021-11-24'
--group by table,database
order by row desc
最后修改于 2021-11-25 18:42:05
如果觉得我的文章对你有用,请随意赞赏
扫一扫支付

