Monthly Archives: November 2020

clickhouse统计数据库大小

注意最后以后右边是两个分号   select 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, 0) “压缩率” from system.parts;;

Posted in clickhouse | Tagged | Leave a comment