1 个回答
也是从system.parts表里面查看,示例如下:
SELECT
partition 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, 0) AS `压缩率`
FROM system.parts
WHERE (database IN (${数据库名})) AND (table IN (${表名})) AND (partition LIKE ${分区名})
GROUP BY partition
ORDER BY partition ASC
发布于:1年前 (2024-02-29) IP属地:未知
我来回答
您需要 登录 后回答此问题!