v.23.11Improvement

Show total_bytes and total_rows in system tables for RocksDB storage

Show total_bytes and total_rows in system tables for RocksDB storage. #56816 (Aleksandr Musorin).
Added total_bytes and total_rows columns to system tables for RocksDB storage engine in ClickHouse.

Why it matters

This feature provides detailed size and row count metrics for RocksDB tables directly within ClickHouse's system tables, enabling better monitoring and management of RocksDB storage usage.

How to use it

Users can query the relevant system tables, such as system.parts or other RocksDB-related system tables, to see total_bytes and total_rows for RocksDB tables without additional configuration.