v.25.11Improvement

Add a new column statistics in system

Official CH changelog text
Add a new column statistics in system.columns, indicating the types of statistics built on this table. If a type of statistics is automatically created, it will show as (auto) in the suffix. #89086 (Han Fei).
Added a new statistics column in the system.columns table that shows the types of statistics collected on each table's columns, with an '(auto)' suffix indicating automatically created statistics.

Why it matters

This feature allows users to easily identify what kinds of statistics are available for table columns, improving transparency and helping optimize query performance by understanding which statistics are gathered, including those automatically created by ClickHouse.

How to use it

Query the system.columns table to see the new statistics column. For example, use:

sql<br>SELECT name, type, statistics FROM system.columns WHERE table = 'your_table_name'<br>

Related resources

PreviousNext