SELECT partition, name, table FROM system.parts WHERE active

ss

SELECT * FROM system.parts WHERE active limit 1

ss

SELECT
    name,
    type,
    formatReadableSize(data_compressed_bytes) AS compressed,
    formatReadableSize(data_uncompressed_bytes) AS uncompressed,
    data_uncompressed_bytes / data_compressed_bytes AS ratio,
    compression_codec
FROM system.columns
WHERE (database = 'traffic') AND (table = 'raw')
ORDER BY data_compressed_bytes DESC

ALTER TABLE <database>.<table> MODIFY COLUMN <column> CODEC(Delta(4), ZSTD(10))

Changes are applied lazily: only for new data and while merging. A trick to rewrite column data on disk:

ALTER TABLE <database>.<table> UPDATE <column> = <column> WHERE 1

Процедура выполняется в фоне, чтобы проверить статус:

select * from system.mutations