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.
query(String) — Query string.
exception(String) — Exception message.
exception_code(Int32) — Code of an exception.
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) — The
UserAgentheader passed in the HTTP request.
quota_key(String) — The “quota key” specified in the quotas setting (see
revision(UInt32) — ClickHouse revision.
thread_numbers(Array(UInt32)) — Number of threads 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
SELECT * FROM system.query_log LIMIT 1 \G
Row 1: ────── type: QueryStart event_date: 2020-09-11 event_time: 2020-09-11 10:08:17 event_time_microseconds: 2020-09-11 10:08:17.063321 query_start_time: 2020-09-11 10:08:17 query_start_time_microseconds: 2020-09-11 10:08:17.063321 query_duration_ms: 0 read_rows: 0 read_bytes: 0 written_rows: 0 written_bytes: 0 result_rows: 0 result_bytes: 0 memory_usage: 0 current_database: default query: INSERT INTO test1 VALUES exception_code: 0 exception: stack_trace: is_initial_query: 1 user: default query_id: 50a320fd-85a8-49b8-8761-98a86bcbacef address: ::ffff:127.0.0.1 port: 33452 initial_user: default initial_query_id: 50a320fd-85a8-49b8-8761-98a86bcbacef initial_address: ::ffff:127.0.0.1 initial_port: 33452 interface: 1 os_user: bharatnc client_hostname: tower client_name: ClickHouse client_revision: 54437 client_version_major: 20 client_version_minor: 7 client_version_patch: 2 http_method: 0 http_user_agent: quota_key: revision: 54440 thread_ids:  ProfileEvents.Names:  ProfileEvents.Values:  Settings.Names: ['use_uncompressed_cache','load_balancing','log_queries','max_memory_usage','allow_introspection_functions'] Settings.Values: ['0','random','1','10000000000','1']
Rating: 4 - 1 votesWas this content helpful?