v.25.6Improvement

Add search algorithm section to EXPLAIN output

Official CH changelog text
Add search algorithm section to EXPLAIN output when using it with indexes = 1. If shows either "binary search" or "generic exclusion search". #80881 (Pablo Marcos).
Adds a search algorithm section to the EXPLAIN query output when used with indexes = 1, showing either "binary search" or "generic exclusion search".

Why it matters

This feature improves query introspection by providing more detailed information about the search algorithm applied during index usage. It helps users understand how ClickHouse executes index-based searches, aiding in performance tuning and debugging.

How to use it

Run EXPLAIN on your query with the setting indexes = 1 enabled. The output will include a new section that specifies the search algorithm used, such as "binary search" or "generic exclusion search".

Related resources

PreviousNext