Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

log_query_* session settings

View as MarkdownEdit this pageReport an issueSet up docs MCP

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

log_query_settings

Type
Bool
Default
1

Log query settings into the query_log and OpenTelemetry span log.

log_query_threads

Type
Bool
Default
0

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

Type
Bool
Default
1

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
Navigation