v.20.1New Feature

Added system.stack_trace table for server thread introspection

Added system.stack_trace table that allows to look at stack traces of all server threads. This is useful for developers to introspect server state. This fixes #7576. #8344 (alexey-milovidov)
Added the system.stack_trace table to view stack traces of all server threads in ClickHouse.

Why it matters

This feature allows developers and DBAs to introspect the current state of the ClickHouse server by examining stack traces of all active threads. It helps in debugging, performance analysis, and diagnosing issues by providing insight into thread execution at any given moment.

How to use it

Query the system.stack_trace table using a standard SELECT statement to retrieve stack trace information of all server threads. For example:
SELECT * FROM system.stack_trace;