Show total_rows and total_bytes for temporary tables in system.tables

Why it matters

This feature enhances visibility into temporary tables by exposing their total_rows and total_bytes metrics in the system.tables system table. It helps users monitor the size and row count of temporary tables, improving resource tracking and query optimization.

How to use it

Users can query the system.tables table as usual. The total_rows and total_bytes columns will now include data for temporary tables without requiring any special configuration.