v.24.10New Feature

Real-time Metrics Table in ClickHouse Client with Space Bar Toggle

Official CH changelog text
If you press space bar during query runtime, the client will display a real-time table with detailed metrics. You can enable it globally with the new --progress-table option in clickhouse-client; a new --enable-progress-table-toggle is associated with the --progress-table option, and toggles the rendering of the progress table by pressing the control key (Space). #63689 (Maria Khristenko), #70423 (Julia Kartseva).
Introduces a real-time progress table in clickhouse-client that displays detailed query execution metrics when the space bar is pressed during query runtime.

Why it matters

This feature provides users with immediate, detailed insight into the progress and performance of running queries directly in the client, helping to monitor and diagnose query execution without interrupting or stopping the query.

How to use it

Enable the progress table globally by starting clickhouse-client with the --progress-table option. Use the --enable-progress-table-toggle alongside it to allow toggling the progress table display on and off during query execution by pressing the space bar.

Related resources

PreviousNext