v26.10.1

New features

• ZooKeeper browser (system.zookeeper) with integration into the replicas view (0a965bd)
• Per-host summary rows in --cluster mode (toggled with 1): usage bars on the capacity scale, running queries column, resizable with [/] or by dragging the separator (#299, e0c04aa, 05e7a9a)
• Per-query actions: metric log with charts and threads (query_thread_log) (242a036)
• Live ProfileEvents popup (per-interval rates) for running queries (8b65edf)
• KILL QUERY for all queries selected with Space (single KILL QUERY ... IN (...) statement) (b483c9b)
• Queries filter (/): predicates with Tab/Shift-Tab completion, normalized_query field, quoted empty values (s.workload!='') (#298, #301)
• ProfileEvents.<Name>/Settings.<name> columns and filter fields (pe.<Name>, s.<name>) in the queries views; column and pe.<Name> predicates in the / filter of SQL views (#300)
• part_log: ProfileEvents and configurable columns (views.part_log.columns) (#300, d29aa05)
• Settings dialog: one tab per view, column fields with completion (#300)
• Config: views.*.order_by=<column> [asc|desc], aliases in views.*.columns (foobar as x), clickhouse.settings instead of URL parameters, named view instances listed in the Views menu (F2/fuzzy) (#301)
• Reorder table columns by dragging the header (persisted in query_columns) (1b5bbf3)
• Show query: less-style search (/, ?, n, N) (#301)
• Perfetto export: ProfileEvent stack traces as an events flamegraph, ProfileEvents and Settings as nested annotations on query slices, all query_thread_log ProfileEvents instead of the top 10 (f8ac6f9, 7dd8c17, 8563eaa)
• Readline bindings in edit fields (Ctrl-W/U/K/A/E, Alt-B/F, Ctrl-Left/Right) (b2fd2e3, 69d00e1)

Improvements

• r refreshes only the focused view (b934808)
• Query ProfileEvents summed over initial_query_id across hosts, so the initial row of a distributed query carries the whole cluster's counters (f1ecbd4)
• system.asynchronous_metrics key_values Map support (ClickHouse 26.8+) (43000b6)
• toValidUTF8() for server-provided strings (normalized query, Settings values, exceptions, text_log messages) (7c16208)

Bug fixes

• Time-frame seeking: T/t were identical and never accumulated (#297, #296)
• CPU accounting on cgroup-limited servers (CGroupUserTime/CGroupSystemTime when CGroupMaxCPU is set), used cores no longer exceed the limit (cee4d53)
• cpu/io_wait/cpu_wait of finished queries showed seconds×100 under a % label instead of average utilization (0e047c7)
• Tables view hid tables without background schedule tasks (inner JOIN → LEFT JOIN) (37edfb4)
• Duplicated log lines and lost/delayed wakeups in the background runner (92a53d4, #301)
• Hostname stripping inconsistency across log batches (213390f)
• Dialogs with scrollable content (e.g. server warnings) required Tab before Enter (87140e6)
• Summary net/disk rates precision (b7df974)
• Settings search for end landed on the time interval instead of the column (aacd44a)
• Sort indicator for very long columns; queries view no longer sorts by a column the table does not have (#301)

Commits

• 37edfb4: Use LEFT JOIN with background_schedule_pool in the tables view (Azat Khuzhin)
• f8ac6f9: Include ProfileEvent stack traces (events flamegraph) in the Perfetto export (Azat Khuzhin)
• e460f46: Adjust the cast-quirk test for ProfileEvent samples in the Perfetto export (Azat Khuzhin)
• 43000b6: Handle key_values Map in system.asynchronous_metrics (26.8+) (Azat Khuzhin)
• 0b36a3f: Fix time-frame seeking: T/t were identical and never accumulated (Azat Khuzhin) #297
• bb493bd: Make RelativeDateTime an enum: Absolute/Offset/Now (Azat Khuzhin) #297
• e7226e2: Fix time-frame seeking: T/t were identical and never accumulated (and refactor RelativeDateTime) (#297) (Azat Khuzhin) #297
• 87140e6: Fix dialogs with scrollable content requiring Tab before Enter (e.g. server warnings) (Azat Khuzhin)
• b2fd2e3: Add readline bindings to EditView (Ctrl-W/U/K/A/E, Alt-B/F) (Azat Khuzhin)
• Ctrl-Left/Right move by words (as Alt-B/F) (Azat Khuzhin)
• 753bbe9: Make log_name a wide column in background schedule pool logs (Azat Khuzhin)
• 7c8cb34: Remove "huge bunch of ideas" from README (not too much left) (Azat Khuzhin)
• 213390f: Fix hostname stripping inconsistency across log batches (Azat Khuzhin)
• 0e047c7: Show average utilization for cpu/io_wait/cpu_wait of finished queries (Azat Khuzhin)
• b7df974: Fix summary net/disk rates precision and uptime=0 panic (Azat Khuzhin)
• 8b65edf: Make the query profile events popup live (per-interval rates) for running queries (Azat Khuzhin)
• 242a036: Add per-query metric log (with charts) and threads (query_thread_log) actions (Azat Khuzhin)
• b483c9b: KILL all queries selected with (one KILL QUERY ... IN (...) statement) (Azat Khuzhin)
• 1b5bbf3: Reorder table columns by dragging the header (persisted in query_columns) (Azat Khuzhin)
• 0a965bd: Add ZooKeeper browser (system.zookeeper) with replicas integration (Azat Khuzhin)
• b7ed8cf: Queries filter predicates with Tab completion and instant/server render (Azat Khuzhin) #298
• d2cf088: Per-host summary rows in --cluster mode (system.asynchronous_metrics GROUP BY host), toggled with 1 (Azat Khuzhin) #299
• bc5d2ff: Resize the per-host summary table with [ ] or by dragging its separator (Azat Khuzhin) #299
• 138ec2e: Per-host summary rows in --cluster mode, toggled with 1 (#299) (Azat Khuzhin) #299
• 7c16208: toValidUTF8() for user-controlled strings: normalized query, Settings values, exceptions, text_log messages (Azat Khuzhin)
• 4389f2b: Fix clippy lints (sort_by_key, collapsible match, checked_div) (Azat Khuzhin)
• 92a53d4: Fix duplicated log lines (Azat Khuzhin)
• f1ecbd4: Sum query ProfileEvents over initial_query_id across hosts (Azat Khuzhin)
• e0c04aa: Usage bars and running queries in the per-host summary rows (Azat Khuzhin)
• 05e7a9a: Order the per-host summary rows by name (Azat Khuzhin)
• cee4d53: Fix CPU CPU accounting when the server is cgroup-limited (Azat Khuzhin)
• 7dd8c17: Attach ProfileEvents and Settings as nested annotations to perfetto query slices (Azat Khuzhin)
• 8563eaa: Nest all query_thread_log ProfileEvents instead of the top 10 (Azat Khuzhin)
• aacd44a: Fix settings search landing on the time-interval "end" instead of the column (Azat Khuzhin)
• d29aa05: Add ProfileEvents for part_log (Azat Khuzhin)
• 2a8ad98: Add readonly support for edit view (Azat Khuzhin)
• 8bd9261: Wrap long connection URL in the settings view (Azat Khuzhin)
• beff458: Add Tabs widget (Azat Khuzhin) #300
• highlight the focused field #300 (Azat Khuzhin)
• c63ebd5: Queries views: ProfileEvents./Settings. columns and filter fields (Azat Khuzhin) #300
• configurable columns (views.part_log.columns) #300 (Azat Khuzhin)
• 6f32992: SQL views: column and pe. predicates in the / filter (Azat Khuzhin) #300
• 44bec03: Settings dialog: tabs, a tab per view, completed column fields (Azat Khuzhin) #300
• 33a3485: Extended columns (ProfileEvents/Settings) with filtering (#300) (Azat Khuzhin) #300
• 31725af: Allow aliases in views.*.columns (foobar as x) (Azat Khuzhin) #301
• 1349858: Fix sort indicator for very long columns in the table (Azat Khuzhin) #301
• d7675e2: Queries view: never sort by a column the table does not have (no header indicator) (Azat Khuzhin) #301
• 6c0bd59: Fix possible lost/delayed wakeup in background runner (Azat Khuzhin) #301
• eda3ea0: Add ability to filter by normalized_query (Azat Khuzhin) #301
• 9246f72: Add ability to specify order of a table in config (views.*.order_by= [asc|desc]) (Azat Khuzhin) #301
• bd9bd72: Views menu: named view instances from the config (F2/fuzzy) (Azat Khuzhin) #301
• e1cdd10: Show query: less-style search (/ ? n N) (Azat Khuzhin) #301
• 0fad244: Queries filter: quoted empty value (s.workload!='') (Azat Khuzhin) #301
• 83612de: Support explicit list of settings in config (via clickhouse.settings) (Azat Khuzhin) #301
• refresh only the focused view (Azat Khuzhin)
• 4259dcf: Drop % for rendering time related columns (Azat Khuzhin)
• ad83cc5: cargo update (Azat Khuzhin) #302
• a28e107: v26.10.1 (Azat Khuzhin)