v.22.12Improvement

Allow Collection of Profile Events in system.trace_log for Performance Analysis

Official CH changelog text
Allow to collect profile events with trace_type = 'ProfileEvent' to system.trace_log on each increment with current stack, profile event name and value of the increment. It can be enabled by the setting trace_profile_events and used to investigate performance of queries. #43639 (Anton Popov).
Adds the ability to collect profile events with trace_type = 'ProfileEvent' into system.trace_log on each increment, including the current stack, profile event name, and the increment value.

Why it matters

This feature enables detailed tracking of profile events to help users investigate and analyze the performance of queries by capturing incremental changes along with context such as the call stack and event details.

How to use it

Enable the feature by setting trace_profile_events to 1. Once enabled, profile event increments will be logged into system.trace_log automatically.

Related resources

PreviousNext