clickhouse_parts.sql

gistfile1.txt

SELECT
    table,
    partition_id,
    count(name) AS parts,
    formatReadableSize(sum(bytes_on_disk)) AS size
FROM system.parts
WHERE (table = 'qw_3_requests_quotes') AND active AND (toUInt32(partition_id) < 20231001)
GROUP BY
    table,
    partition_id
    WITH TOTALS
ORDER BY
    table ASC,
    partition_id ASC