v.24.2Improvement

New Profile Events for Tracking Time Spent on INSERT Calculations

New profile events added to observe the time spent on calculating PK/projections/secondary indices during INSERT-s. #59436 (Nikita Taranov).
Introduces new profile events to monitor the time spent calculating primary keys, projections, and secondary indices during INSERT operations in ClickHouse.

Why it matters

This feature provides detailed insights into the performance costs associated with calculating primary keys, projections, and secondary indices during data insertion. It helps users identify bottlenecks and optimize the insert workflow for better efficiency.

How to use it

Users can observe these new profile events during INSERT queries by enabling profiling or using system tables that capture profile events. No explicit configuration is required to activate these measurements; they are integrated into ClickHouse's profiling infrastructure.