v.23.7Improvement
Add primary_key_size column to system.parts table
Add columnprimary_key_sizetosystem.partstable to show compressed primary key size on disk. Closes #51400. #51496 (Yarik Briukhovetskyi).
Why it matters
This feature helps users monitor and analyze the disk space used specifically by the compressed primary keys within table parts, enabling better storage management and performance tuning.How to use it
Query thesystem.parts table and include the primary_key_size column in your SELECT statement to view the compressed primary key size for each part, for example:SELECT part, primary_key_size FROM system.parts;