Querying in ClickHouse CloudThe data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the
clusterAllReplicas function. See here for further details.Description
Contains logging entries. The logging level which goes to this table can be limited to thetext_log.level server setting.
Columns
hostname(LowCardinality(String)) — Hostname of the server executing the query.event_date(Date) — Date of the entry.event_time(DateTime) — Time of the entry.event_time_microseconds(DateTime64(6)) — Time of the entry with microseconds precision.thread_name(LowCardinality(String)) — Name of the thread from which the logging was done.thread_id(UInt64) — OS thread ID.level(Enum8(‘Fatal’ = 1, ‘Critical’ = 2, ‘Error’ = 3, ‘Warning’ = 4, ‘Notice’ = 5, ‘Information’ = 6, ‘Debug’ = 7, ‘Trace’ = 8, ‘Test’ = 9)) — Entry level. Possible values: 1 or ‘Fatal’, 2 or ‘Critical’, 3 or ‘Error’, 4 or ‘Warning’, 5 or ‘Notice’, 6 or ‘Information’, 7 or ‘Debug’, 8 or ‘Trace’.query_id(String) — ID of the query.logger_name(LowCardinality(String)) — Name of the logger (e.g., DDLWorker).message(String) — The message itself.revision(UInt32) — ClickHouse revision.source_file(LowCardinality(String)) — Source file from which the logging was done.source_line(UInt64) — Source line from which the logging was done.message_format_string(LowCardinality(String)) — A format string that was used to format the message.value1(String) — Argument 1 that was used to format the message.value2(String) — Argument 2 that was used to format the message.value3(String) — Argument 3 that was used to format the message.value4(String) — Argument 4 that was used to format the message.value5(String) — Argument 5 that was used to format the message.value6(String) — Argument 6 that was used to format the message.value7(String) — Argument 7 that was used to format the message.value8(String) — Argument 8 that was used to format the message.value9(String) — Argument 9 that was used to format the message.value10(String) — Argument 10 that was used to format the message.