initial_parts.sql

WITH
    'default' AS db_name,
    'wikistat' AS table_name,
    (
        SELECT uuid
        FROM system.tables
        WHERE (database = db_name) AND (name = table_name)
    ) AS table_id
SELECT
    formatReadableQuantity(countIf(event_type = 'NewPart')) AS parts,
    formatReadableQuantity(avgIf(rows, event_type = 'NewPart')) AS rows_avg,
    formatReadableQuantity(minIf(rows, event_type = 'NewPart')) AS rows_min,
    formatReadableQuantity(maxIf(rows, event_type = 'NewPart')) AS rows_max,
    formatReadableSize(avgIf(size_in_bytes, event_type = 'NewPart')) AS size_avg,
    formatReadableSize(minIf(size_in_bytes, event_type = 'NewPart')) AS size_min,
    formatReadableSize(maxIf(size_in_bytes, event_type = 'NewPart')) AS size_max,
    formatReadableQuantity(sumIf(rows, event_type = 'NewPart')) AS rows_total
FROM clusterAllReplicas(default, system.part_log)
WHERE table_uuid = table_id
SETTINGS skip_unavailable_shards = 1
FORMAT Vertical;