Prakhar Gurunani
10/10/2024, 1:41 PMHerb He
10/10/2024, 2:31 PMclickhouse client
to open the clickhouse query console and run this to list top storage tables
SELECT
database,
table,
sum(bytes) AS total_bytes,
formatReadableSize(sum(bytes)) AS total_size
FROM system.parts
GROUP BY
database,
table
ORDER BY total_bytes DESC
LIMIT 100