v.25.9Improvement

Limit query plan description

Official CH changelog text
Limit query plan description in the EXPLAIN query. Do not calculate the description for queries other than EXPLAIN. Added a setting query_plan_max_step_description_length. #86741 (Nikolai Kochetov).
Introduces a limit on the length of the query plan step description in EXPLAIN queries via the new setting query_plan_max_step_description_length.

Why it matters

This feature prevents excessive calculation and output size of query plan descriptions by restricting their length only for EXPLAIN queries. It optimizes performance and readability, avoiding unnecessary overhead for other query types.

How to use it

Set the query_plan_max_step_description_length setting to the desired maximum length of each step description in EXPLAIN query outputs. This setting controls how much detail is included when you run an EXPLAIN statement.

Related resources

PreviousNext