Slackbot
11/22/2022, 4:05 PMSrikanth Chekuri
11/22/2022, 4:35 PMSELECT
database,
formatReadableSize(sum(data_compressed_bytes) AS size) AS compressed,
formatReadableSize(sum(data_uncompressed_bytes) AS usize) AS uncompressed,
round(usize / size, 2) AS compr_rate,
sum(rows) AS rows,
count() AS part_count
FROM system.parts
WHERE (active = 1) AND (database LIKE '%')
GROUP BY
database
ORDER BY size DESC;