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
如果觉得我的文章对你有用,请随意赞赏
扫一扫支付
上一篇