v.23.2Improvement

Add columns to system.tables for parts, active_parts, and total_marks

Add parts, active_parts and total_marks columns to system.tables on issue. #46161 (attack204).
Added new columns parts, active_parts, and total_marks to the system.tables table.

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