Enum8) — Type of an event that occurred when executing the query. Values:
'QueryStart' = 1— Successful start of query execution.
'QueryFinish' = 2— Successful end of query execution.
'ExceptionBeforeStart' = 3— Exception before the start of query execution.
'ExceptionWhileProcessing' = 4— Exception during the query execution.
event_date(Date) — Query starting date.
event_time(DateTime) — Query starting time.
event_time_microseconds(DateTime) — Query starting time with microseconds precision.
query_start_time(DateTime) — Start time of query execution.
query_start_time_microseconds(DateTime64) — Start time of query execution with microsecond precision.
query_duration_ms(UInt64) — Duration of query execution in milliseconds.
read_rows(UInt64) — Total number of rows read from all tables and table functions participated in query. It includes usual subqueries, subqueries for
JOIN. For distributed queries
read_rowsincludes the total number of rows read at all replicas. Each replica sends it’s
read_rowsvalue, and the server-initiator of the query summarizes all received and local values. The cache volumes don’t affect this value.
read_bytes(UInt64) — Total number of bytes read from all tables and table functions participated in query. It includes usual subqueries, subqueries for
JOIN. For distributed queries
read_bytesincludes the total number of rows read at all replicas. Each replica sends it’s
read_bytesvalue, and the server-initiator of the query summarizes all received and local values. The cache volumes don’t affect this value.
written_rows(UInt64) — For
INSERTqueries, the number of written rows. For other queries, the column value is 0.
written_bytes(UInt64) — For
INSERTqueries, the number of written bytes. For other queries, the column value is 0.
result_rows(UInt64) — Number of rows in a result of the
SELECTquery, or a number of rows in the
result_bytes(UInt64) — RAM volume in bytes used to store a query result.
memory_usage(UInt64) — Memory consumption by the query.
current_database(String) — Name of the current database.
query(String) — Query string.
normalized_query_hash(UInt64) — Identical hash value without the values of literals for similar queries.
query_kind(LowCardinality(String)) — Type of the query.
databases(Array(LowCardinality(String))) — Names of the databases present in the query.
tables(Array(LowCardinality(String))) — Names of the tables present in the query.
columns(Array(LowCardinality(String))) — Names of the columns present in the query.
exception_code(Int32) — Code of an exception.
exception(String) — Exception message.
stack_trace(String) — Stack trace. An empty string, if the query was completed successfully.
is_initial_query(UInt8) — Query type. Possible values:
user(String) — Name of the user who initiated the current query.
query_id(String) — ID of the query.
address(IPv6) — IP address that was used to make the query.
port(UInt16) — The client port that was used to make the query.
initial_user(String) — Name of the user who ran the initial query (for distributed query execution).
initial_query_id(String) — ID of the initial query (for distributed query execution).
initial_address(IPv6) — IP address that the parent query was launched from.
initial_port(UInt16) — The client port that was used to make the parent query.
interface(UInt8) — Interface that the query was initiated from. Possible values:
os_user(String) — Operating system username who runs clickhouse-client.
client_hostname(String) — Hostname of the client machine where the clickhouse-client or another TCP client is run.
client_name(String) — The clickhouse-client or another TCP client name.
client_revision(UInt32) — Revision of the clickhouse-client or another TCP client.
client_version_major(UInt32) — Major version of the clickhouse-client or another TCP client.
client_version_minor(UInt32) — Minor version of the clickhouse-client or another TCP client.
client_version_patch(UInt32) — Patch component of the clickhouse-client or another TCP client version.
http_method(UInt8) — HTTP method that initiated the query. Possible values:
GETmethod was used.
POSTmethod was used.
http_user_agent(String) — HTTP header
UserAgentpassed in the HTTP query.
http_referer(String) — HTTP header
Refererpassed in the HTTP query (contains an absolute or partial address of the page making the query).
forwarded_for(String) — HTTP header
X-Forwarded-Forpassed in the HTTP query.
quota_key(String) — The
quota keyspecified in the quotas setting (see
revision(UInt32) — ClickHouse revision.
log_comment(String) — Log comment. It can be set to arbitrary string no longer than max_query_size. An empty string if it is not defined.
thread_ids(Array(UInt64)) — Thread ids that are participating in query execution.
ProfileEvents.Names(Array(String)) — Counters that measure different metrics. The description of them could be found in the table system.events
ProfileEvents.Values(Array(UInt64)) — Values of metrics that are listed in the
Settings.Names(Array(String)) — Names of settings that were changed when the client ran the query. To enable logging changes to settings, set the
log_query_settingsparameter to 1.
Settings.Values(Array(String)) — Values of settings that are listed in the
used_aggregate_functions(Array(String)) — Canonical names of
aggregate functions, which were used during query execution.
used_aggregate_function_combinators(Array(String)) — Canonical names of
aggregate functions combinators, which were used during query execution.
used_database_engines(Array(String)) — Canonical names of
database engines, which were used during query execution.
used_data_type_families(Array(String)) — Canonical names of
data type families, which were used during query execution.
used_dictionaries(Array(String)) — Canonical names of
dictionaries, which were used during query execution.
used_formats(Array(String)) — Canonical names of
formats, which were used during query execution.
used_functions(Array(String)) — Canonical names of
functions, which were used during query execution.
used_storages(Array(String)) — Canonical names of
storages, which were used during query execution.
used_table_functions(Array(String)) — Canonical names of
table functions, which were used during query execution.
SELECT * FROM system.query_log WHERE type = 'QueryFinish' AND (query LIKE '%toDate(\'2000-12-05\')%') ORDER BY query_start_time DESC LIMIT 1 FORMAT Vertical;
Row 1: ────── type: QueryFinish event_date: 2021-03-18 event_time: 2021-03-18 20:54:18 event_time_microseconds: 2021-03-18 20:54:18.676686 query_start_time: 2021-03-18 20:54:18 query_start_time_microseconds: 2021-03-18 20:54:18.673934 query_duration_ms: 2 read_rows: 100 read_bytes: 800 written_rows: 0 written_bytes: 0 result_rows: 2 result_bytes: 4858 memory_usage: 0 current_database: default query: SELECT uniqArray([1, 1, 2]), SUBSTRING('Hello, world', 7, 5), flatten([[[BIT_AND(123)]], [[mod(3, 2)], [CAST('1' AS INTEGER)]]]), week(toDate('2000-12-05')), CAST(arrayJoin([NULL, NULL]) AS Nullable(TEXT)), avgOrDefaultIf(number, number % 2), sumOrNull(number), toTypeName(sumOrNull(number)), countIf(toDate('2000-12-05') + number as d, toDayOfYear(d) % 2) FROM numbers(100) normalized_query_hash: 17858008518552525706 query_kind: Select databases: ['_table_function'] tables: ['_table_function.numbers'] columns: ['_table_function.numbers.number'] exception_code: 0 exception: stack_trace: is_initial_query: 1 user: default query_id: 58f3d392-0fa0-4663-ae1d-29917a1a9c9c address: ::ffff:127.0.0.1 port: 37486 initial_user: default initial_query_id: 58f3d392-0fa0-4663-ae1d-29917a1a9c9c initial_address: ::ffff:127.0.0.1 initial_port: 37486 interface: 1 os_user: sevirov client_hostname: clickhouse.ru-central1.internal client_name: ClickHouse client_revision: 54447 client_version_major: 21 client_version_minor: 4 client_version_patch: 1 http_method: 0 http_user_agent: http_referer: forwarded_for: quota_key: revision: 54449 log_comment: thread_ids: [587,11939] ProfileEvents.Names: ['Query','SelectQuery','ReadCompressedBytes','CompressedReadBufferBlocks','CompressedReadBufferBytes','IOBufferAllocs','IOBufferAllocBytes','ArenaAllocChunks','ArenaAllocBytes','FunctionExecute','TableFunctionExecute','NetworkSendElapsedMicroseconds','SelectedRows','SelectedBytes','ContextLock','RWLockAcquiredReadLocks','RealTimeMicroseconds','UserTimeMicroseconds','SystemTimeMicroseconds','SoftPageFaults','OSCPUVirtualTimeMicroseconds','OSWriteBytes'] ProfileEvents.Values: [1,1,36,1,10,2,1048680,1,4096,36,1,110,100,800,77,1,3137,1476,1101,8,2577,8192] Settings.Names: ['load_balancing','max_memory_usage'] Settings.Values: ['random','10000000000'] used_aggregate_functions: ['groupBitAnd','avg','sum','count','uniq'] used_aggregate_function_combinators: ['OrDefault','If','OrNull','Array'] used_database_engines:  used_data_type_families: ['String','Array','Int32','Nullable'] used_dictionaries:  used_formats:  used_functions: ['toWeek','CAST','arrayFlatten','toTypeName','toDayOfYear','addDays','array','toDate','modulo','substring','plus'] used_storages:  used_table_functions: ['numbers']
Rating: 5 - 1 votesWas this content helpful?