v.23.1New Feature

Added message_format_string column to system.text_log for enhanced log analytics

Official CH changelog text
Added a message_format_string column to system.text_log. The column contains a pattern that was used to format the message. #44543 (Alexander Tokmakov). This allows various analytics over the ClickHouse logs.
Added a message_format_string column to the system.text_log table that stores the pattern used to format each log message.

Why it matters

This feature enables more advanced and flexible analytics on ClickHouse logs by providing access to the original message format patterns, allowing users to perform pattern-based log analysis rather than working only with fully rendered log messages.

How to use it

Query the system.text_log table and include the new message_format_string column in your SELECT statements to retrieve the log message pattern string alongside other log details.

Related resources

PreviousNext