log_query_* session settings - ClickHouse Documentation

These settings are available in system.settings and are autogenerated from source.

log_query_settings

Log query settings into the query_log and OpenTelemetry span log.

log_query_threads

Setting up query threads logging. Query threads log into the system.query_thread_log table. This setting has effect only when log_queries is true. Queries’ threads run by ClickHouse with this setup are logged according to the rules in the query_thread_log server configuration parameter. Possible values:

0 — Disabled.
1 — Enabled.

Example

log_query_threads=1

log_query_views

Setting up query views logging. When a query run by ClickHouse with this setting enabled has associated views (materialized or live views), they are logged in the query_views_log server configuration parameter. Example:

log_query_views=1

Last modified on July 24, 2026