v.24.7Improvement
Server Settings Now Display compiled_expression_cache_size and compiled_expression_cache_elements_size in system.server_settings
Server settingscompiled_expression_cache_sizeandcompiled_expression_cache_elements_sizeare now shown insystem.server_settings. #65584 (Robert Schulze).
Why it matters
This feature improves observability by allowing users to monitor and query the values of thecompiled_expression_cache_size and compiled_expression_cache_elements_size settings directly from the system.server_settings system table, enhancing transparency and easier debugging of query compilation behaviors.How to use it
Users can query thesystem.server_settings table to see the current values of compiled_expression_cache_size and compiled_expression_cache_elements_size settings with a simple SQL query such as:SELECT name, value FROM system.server_settings WHERE name IN ('compiled_expression_cache_size', 'compiled_expression_cache_elements_size')