v.25.6Improvement

Add two new ProfileEvents

Add two new ProfileEvents for index search algorithm observability: IndexBinarySearchAlgorithm and IndexGenericExclusionSearchAlgorithm. #80679 (Pablo Marcos).
Added two new ProfileEvents, IndexBinarySearchAlgorithm and IndexGenericExclusionSearchAlgorithm, to improve observability of index search algorithms in ClickHouse.

Why it matters

This feature provides detailed metrics about the usage of different index search algorithms, enabling users to better monitor and optimize query performance by understanding which algorithms are being utilized during index searches.

How to use it

Users can monitor the new ProfileEvents by querying the system.profile_events table or using monitoring tools that collect ProfileEvents data. The events IndexBinarySearchAlgorithm and IndexGenericExclusionSearchAlgorithm will track occurrences of their respective index search algorithms automatically once the update is applied.