v.21.11Improvements
Added new columns for data and secondary indices in system tables
Added columnsdata_compressed_bytes,data_uncompressed_bytes,marks_bytesintosystem.data_skipping_indices. Added columnssecondary_indices_compressed_bytes,secondary_indices_uncompressed_bytes,secondary_indices_marks_bytesintosystem.parts. Closes #29697. #29896 (Maksim Kita).
Why it matters
This feature enhances observability by exposing compressed and uncompressed byte size statistics for data skipping indices and secondary indices. It helps users understand the storage footprint of these indices, enabling better performance tuning and resource management.How to use it
Users can query thesystem.data_skipping_indices table to access data_compressed_bytes, data_uncompressed_bytes, and marks_bytes. Similarly, users can query the system.parts table to get secondary_indices_compressed_bytes, secondary_indices_uncompressed_bytes, and secondary_indices_marks_bytes. No additional configuration is required.