v.1.1.54337New Feature

Added system.parts_columns Table for MergeTree Column Size Information

Official CH changelog text
Added the system.parts_columns table with information about column sizes in each data part of MergeTree tables.
Added the system.parts_columns table providing detailed information about column sizes for each data part in MergeTree tables.

Why it matters

This feature was created to give users insight into the storage size of individual columns within data parts of MergeTree tables. It helps identify large or inefficiently stored columns, enabling better storage optimization and performance tuning.

How to use it

Query the system.parts_columns table to retrieve size information per column per data part. For example, use 
SELECT * FROM system.parts_columns WHERE table = 'your_table'
to analyze column sizes and optimize storage.
PreviousNext