Get Clickhouse table size
SELECT table,
sum(bytes) AS sizeb,
formatReadableSize(sum(bytes)) AS size,
min(min_date) AS min_date,
max(max_date) AS max_date
FROM system.parts
GROUP BY table
ORDER BY sizeb DESC;
Read other posts