v.20.11Improvement

Add total_rows/total_bytes support for Set/Join table engines

Add total_rows/total_bytes (from system.tables) support for Set/Join table engines. #16306 (Azat Khuzhin).
Added support for total_rows and total_bytes metrics from system.tables to Set and Join table engines in ClickHouse.

Why it matters

This feature provides users with accurate size and row count information for Set and Join tables through the system.tables system table, improving monitoring, troubleshooting, and performance analysis of queries involving these table engines.

How to use it

After upgrading to the version including this feature, users can query the system.tables system table and retrieve total_rows and total_bytes columns for tables using the Set and Join engines without any additional configuration.