KB / Memory / project-chmonitor-ttl-partitions
chmonitor TTL & Partitions inventory
System TTL page lists table inventory plus part-health charts; never select system.tables.ttl
System view TTL & Partitions (/ttl-partition-health) shows:
- Inventory table: full_table, engine, partition_key, ttl_expression, partitions, active_parts, parts_per_partition, bytes_on_disk
- Charts: part health and parts per table
This is a System monitor, not a Tools utility (project-chmonitor-tools-sidebar).
system.tables has no ttl column. Inventory SQL must never select system.tables.ttl — that 500s and the UI shows a silent Retry.
Hub: project-clickhouse-monitoring.
Why: inventory failed live when the query invented a column; charts still worked.
How to apply: keep inventory and charts as separate queries; fail loud on inventory errors; do not select system.tables.ttl.