【Clickhouse】常用运维语句

1. 获取所有表行数、数据大小、压缩率

SELECT
    table AS `表名`,
    sum(rows) AS `总行数`,
    formatReadableSize(sum(data_uncompressed_bytes)) AS `原始大小`,
    formatReadableSize(sum(data_compressed_bytes)) AS `压缩大小`,
    round((sum(data_compressed_bytes) / sum(data_uncompressed_bytes)) * 100, 2) AS `压缩率`
FROM system.parts
where database='database'
GROUP BY table
order by `总行数` desc;