v.23.2Improvement
Add columns to system.tables for parts, active_parts, and total_marks
Addparts,active_partsandtotal_markscolumns tosystem.tableson issue. #46161 (attack204).
Why it matters
These new columns provide detailed insight into the storage and indexing state of each table by showing the number of parts, the count of active parts, and the total marks. This enhances monitoring capabilities and helps users understand storage structure and performance characteristics directly from system tables.How to use it
Query thesystem.tables system table normally. The new columns parts, active_parts, and total_marks will be available for users without requiring any special configuration or settings.