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).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 duringINSERT 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.