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).
Why it matters
This feature provides users with accurate size and row count information forSet 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 thesystem.tables system table and retrieve total_rows and total_bytes columns for tables using the Set and Join engines without any additional configuration.