Log Messages Logged to system.text_log on Server Startup

Why it matters

This feature provides users with persistent and structured access to server startup log messages directly within ClickHouse, enabling easier troubleshooting and monitoring without relying solely on external log files.

How to use it

Users can query the system.text_log system table using standard SQL queries, for example:

sql<br>SELECT * FROM system.text_log<br>WHERE event_time >= now() - INTERVAL 1 HOUR<br>ORDER BY event_time DESC<br>;

to inspect recent log messages generated from the server startup.