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