v.20.5New Feature

Added move_ttl_info to system.parts for move TTL introspection

Added move_ttl_info to system.parts in order to provide introspection of move TTL functionality. #10591 (Vladimir Chebotarev).
Added the move_ttl_info column to the system.parts table to enable introspection of the move TTL functionality in ClickHouse.

Why it matters

The addition of move_ttl_info provides users with detailed information about the move TTLs applied to parts. This helps in monitoring and debugging TTL data movement operations, improving transparency and manageability of TTL-related processes.

How to use it

Users can query the system.parts table to access the move_ttl_info column and retrieve information about active or past move TTLs for data parts, for example:

SELECT name, move_ttl_info FROM system.parts WHERE database = 'your_database' AND table = 'your_table'