v.25.11Improvement

Add input_headers option to EXPLAIN query

Official CH changelog text
Add input_headers option to EXPLAIN query to add input headers to steps. #88311 (János Benjamin Antal).
Added an input_headers option to the EXPLAIN query to include input headers in the query plan steps output.

Why it matters

The feature enhances the EXPLAIN command by allowing users to see the input headers (column names and types) that each step of a query receives. This helps in better understanding and debugging the query execution flow and intermediate results.

How to use it

Use the EXPLAIN query with the added input_headers option. For example:

EXPLAIN input_headers SELECT * FROM table

Related resources

PreviousNext