v.24.7Improvement

Server Settings Now Display compiled_expression_cache_size and compiled_expression_cache_elements_size in system.server_settings

Server settings compiled_expression_cache_size and compiled_expression_cache_elements_size are now shown in system.server_settings. #65584 (Robert Schulze).
Server settings compiled_expression_cache_size and compiled_expression_cache_elements_size are now visible in the system.server_settings table.

Why it matters

This feature improves observability by allowing users to monitor and query the values of the compiled_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 the system.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')