v.20.1Improvement

Added lifetime column to system.dictionaries table

Added lifetime column to system.dictionaries table. #6820 #7727 (kekekekule)
Added a lifetime column to the system.dictionaries table to provide information about dictionary element TTL (time to live).

Why it matters

This feature allows users to see the configured lifetime of dictionary elements directly from the system.dictionaries table, helping to understand dictionary caching and expiration settings for better management and debugging.

How to use it

Query the system.dictionaries table using SELECT lifetime FROM system.dictionaries to view the lifetime value of each dictionary. No additional configuration is required to enable this feature.