v.25.11Improvement

Add new is_internal column to system

Official CH changelog text
Log internal queries (those executed internally by dictionaries, refreshable materialized views, etc) and add the new is_internal column to system.query_log. #83277 (Miсhael Stetsyuk).
Introduces logging for internal queries executed by components such as dictionaries and refreshable materialized views, and adds a new is_internal column to the system.query_log table.

Why it matters

This feature helps users distinguish and analyze queries that are run internally by ClickHouse services and processes. It improves observability and troubleshooting by explicitly marking internal queries within the query log.

How to use it

Users can now query the system.query_log system table and use the new is_internal boolean column to filter or identify internal queries. No additional configuration is required to enable this logging once upgraded.

Related resources

PreviousNext