v.23.9Improvement

Added ContextLockWaitMicroseconds Profile Event

Added ContextLockWaitMicroseconds profile event. #55029 (Maksim Kita).
Added a new profile event ContextLockWaitMicroseconds to ClickHouse.

Why it matters

This feature tracks and exposes the time spent waiting for context locks within ClickHouse, enabling users to diagnose and monitor contention or delays related to context locking. It provides valuable insights for performance tuning and debugging.

How to use it

Users can monitor the ContextLockWaitMicroseconds profile event through ClickHouse's existing profiling and metrics tools to measure the time spent waiting on context locks. No additional configuration is required to enable this event once updated.