v.21.11Improvements

Added new columns for data and secondary indices in system tables

Added columns data_compressed_bytes, data_uncompressed_bytes, marks_bytes into system.data_skipping_indices. Added columns secondary_indices_compressed_bytes, secondary_indices_uncompressed_bytes, secondary_indices_marks_bytes into system.parts. Closes #29697. #29896 (Maksim Kita).
Added new columns to system tables to provide detailed byte size metrics for data skipping indices and secondary indices.

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 the system.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.