| is_initial_query | UInt8 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Query type. Possible values: 1 — query was initiated by the client, 0 — query was initiated by another query as part of distributed query execution. | |
| distributed_depth | UInt64 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | How many times a query was forwarded between servers. | |
| event_time | DateTime | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Query starting time. | |
| read_rows | UInt64 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Total number of rows read from all tables and table functions participated in query. It includes usual subqueries, subqueries for IN and JOIN. For distributed queries read_rows includes the total number of rows read at all replicas. Each replica sends it’s read_rows value, and the server-initiator of the query summarizes all received and local values. The cache volumes do not affect this value. | |
| port | UInt16 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | The client port that was used to make the query. | |
| memory_usage | UInt64 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Memory consumption by the query. | |
| tables | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Names of the tables present in the query. | |
| client_version_minor | UInt32 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Minor version of the clickhouse-client or another TCP client. | |
| thread_ids | Array(UInt64) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Thread ids that are participating in query execution. These threads may not have run simultaneously. | |
| initial_query_start_time | DateTime | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Initial query starting time (for distributed query execution). | |
| Settings | Map(LowCardinality(String), LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Settings that were changed when the client ran the query. To enable logging changes to settings, set the log_query_settings parameter to 1. | |
| type | Enum8('QueryStart' = 1, 'QueryFinish' = 2, 'ExceptionBeforeStart' = 3, 'ExceptionWhileProcessing' = 4) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Type of an event that occurred when executing the query. | |
| result_bytes | UInt64 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | RAM volume in bytes used to store a query result. | |
| normalized_query_hash | UInt64 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Identical hash value without the values of literals for similar queries. | |
| used_table_functions | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Canonical names of table functions, which were used during query execution. | |
| query_id | String | 0.00 B | 0.00 B | 10.60 thousand | 0 | | ID of the query. | |
| written_bytes | UInt64 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | For INSERT queries, the number of written bytes (uncompressed). For other queries, the column value is 0. | |
| used_aggregate_function_combinators | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Canonical names of aggregate functions combinators, which were used during query execution. | |
| used_database_engines | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Canonical names of database engines, which were used during query execution. | |
| formatted_query | String | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Formatted query string. | |
| query_duration_ms | UInt64 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Duration of query execution in milliseconds. | |
| exception | String | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Exception message. | |
| http_referer | String | 0.00 B | 0.00 B | 10.60 thousand | 0 | | HTTP header Referer passed in the HTTP query (contains an absolute or partial address of the page making the query). | |
| current_database | LowCardinality(String) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Name of the current database. | |
| quota_key | String | 0.00 B | 0.00 B | 10.60 thousand | 0 | | The quota key specified in the quotas setting (see keyed). | |
| used_row_policies | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | The list of row policies names that were used during query execution. | |
| query_start_time | DateTime | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Start time of query execution. | |
| used_aggregate_functions | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Canonical names of aggregate functions, which were used during query execution. | |
| peak_threads_usage | UInt64 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Maximum count of simultaneous threads executing the query. | |
| transaction_id | Tuple(UInt64, UInt64, UUID) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | The identifier of the transaction in scope of which this query was executed. | |
| is_secure | UInt8 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | The flag whether a query was executed over a secure interface | |
| initial_query_start_time_microseconds | DateTime64(6) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Initial query starting time with microseconds precision (for distributed query execution). | |
| exception_code | Int32 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Code of an exception. | |
| client_version_major | UInt32 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Major version of the clickhouse-client or another TCP client. | |
| query | String | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Query string. | |
| http_user_agent | LowCardinality(String) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | HTTP header UserAgent passed in the HTTP query. | |
| used_formats | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Canonical names of formats, which were used during query execution. | |
| databases | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Names of the databases present in the query. | |
| http_method | UInt8 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | HTTP method that initiated the query. Possible values: 0 — The query was launched from the TCP interface, 1 — GET method was used, 2 — POST method was used. | |
| event_date | Date | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Query starting date. | |
| revision | UInt32 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | ClickHouse revision. | |
| written_rows | UInt64 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | For INSERT queries, the number of written rows. For other queries, the column value is 0. | |
| query_start_time_microseconds | DateTime64(6) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Start time of query execution with microsecond precision. | |
| initial_address | IPv6 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | IP address that the parent query was launched from. | |
| projections | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Names of the projections used during the query execution. | |
| interface | UInt8 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Interface that the query was initiated from. Possible values: 1 — TCP, 2 — HTTP. | |
| os_user | LowCardinality(String) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Operating system username who runs clickhouse-client. | |
| read_bytes | UInt64 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Total number of bytes read from all tables and table functions participated in query. It includes usual subqueries, subqueries for IN and JOIN. For distributed queries read_bytes includes the total number of rows read at all replicas. Each replica sends it’s read_bytes value, and the server-initiator of the query summarizes all received and local values. The cache volumes do not affect this value. | |
| log_comment | String | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Log comment. It can be set to arbitrary string no longer than max_query_size. An empty string if it is not defined. | |
| event_time_microseconds | DateTime64(6) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Query starting time with microseconds precision. | |
| columns | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Names of the columns present in the query. | |
| client_hostname | LowCardinality(String) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Hostname of the client machine where the clickhouse-client or another TCP client is run. | |
| initial_port | UInt16 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | The client port that was used to make the parent query. | |
| used_functions | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Canonical names of functions, which were used during query execution. | |
| partitions | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Names of the partitions present in the query. | |
| client_version_patch | UInt32 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Patch component of the clickhouse-client or another TCP client version. | |
| forwarded_for | String | 0.00 B | 0.00 B | 10.60 thousand | 0 | | HTTP header X-Forwarded-For passed in the HTTP query. | |
| asynchronous_read_counters | Map(LowCardinality(String), UInt64) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Metrics for asynchronous reading. | |
| initial_query_id | String | 0.00 B | 0.00 B | 10.60 thousand | 0 | | ID of the initial query (for distributed query execution). | |
| query_kind | LowCardinality(String) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Type of the query. | |
| used_storages | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Canonical names of storages, which were used during query execution. | |
| stack_trace | String | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Stack trace. An empty string, if the query was completed successfully. | |
| initial_user | LowCardinality(String) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Name of the user who ran the initial query (for distributed query execution). | |
| client_revision | UInt32 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Revision of the clickhouse-client or another TCP client. | |
| ProfileEvents | Map(LowCardinality(String), UInt64) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | ProfileEvents that measure different metrics. The description of them could be found in the table system.events | |
| views | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Names of the (materialized or live) views present in the query. | |
| query_cache_usage | Enum8('Unknown' = 0, 'None' = 1, 'Write' = 2, 'Read' = 3) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Usage of the query cache during query execution. Values: 'Unknown' = Status unknown, 'None' = The query result was neither written into nor read from the query cache, 'Write' = The query result was written into the query cache, 'Read' = The query result was read from the query cache. | |
| hostname | LowCardinality(String) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Hostname of the server executing the query. | |
| used_data_type_families | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Canonical names of data type families, which were used during query execution. | |
| address | IPv6 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | IP address that was used to make the query. | |
| client_name | LowCardinality(String) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | The clickhouse-client or another TCP client name. | |
| result_rows | UInt64 | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Number of rows in a result of the SELECT query, or a number of rows in the INSERT query. | |
| user | LowCardinality(String) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Name of the user who initiated the current query. | |
| used_dictionaries | Array(LowCardinality(String)) | 0.00 B | 0.00 B | 10.60 thousand | 0 | | Canonical names of dictionaries, which were used during query execution. |
