查看表的大小:
使用以下查询语句可以列出表及其占用的磁盘空间大小:
SELECT
table,
formatReadableSize(sum(bytes_on_disk)) AS size_on_disk
FROM system.parts
WHERE active
GROUP BY table
ORDER BY size_on_disk DESC
查看表的大小:
使用以下查询语句可以列出表及其占用的磁盘空间大小:
SELECT
table,
formatReadableSize(sum(bytes_on_disk)) AS size_on_disk
FROM system.parts
WHERE active
GROUP BY table
ORDER BY size_on_disk DESC