ClickHouse 集群可用容量查询 SQL 语句

使用以下 SQL 语句可以查询 ClickHouse 集群的可用容量：

SELECT database, table, engine, formatReadableSize(sum(bytes)) AS total_size, formatReadableSize(max(total_bytes)) AS max_size, formatReadableSize(max(free_bytes)) AS available_size FROM system.parts WHERE active AND database NOT IN ('system', 'default', 'mysql') GROUP BY database, table, engine ORDER BY available_size DESC

该语句会查询所有活跃的表格，并按可用容量从高到低排序。其中，formatReadableSize 函数将字节转换为易读的格式。