Add total_bytes_with_inactive to system.tables for inactive parts count

Why it matters

This feature addresses the need for users to monitor and account for the disk space used not only by active parts but also inactive parts within ClickHouse tables. It provides better visibility into total storage consumption, helping in capacity planning and maintenance.

How to use it

Query the system.tables system table and reference the new total_bytes_with_inactive column to get the combined size of active and inactive parts for each table.