| ProfileEvents | Map(LowCardinality(String), UInt64) | 104.77 MiB | 763.83 MiB | 7.29 | 6.19 million | 129.38 | | ProfileEvents that measure different metrics. The description of them could be found in the table system.events |
| query_id | String | 60.64 MiB | 218.24 MiB | 3.6 | 6.19 million | 36.97 | | ID of the query. |
| initial_query_id | String | 60.64 MiB | 218.24 MiB | 3.6 | 6.19 million | 36.97 | | ID of the initial query (for distributed query execution). |
| query | String | 27.51 MiB | 1.46 GiB | 54.34 | 6.19 million | 253.2 | | Query string. |
| thread_ids | Array(UInt64) | 17.72 MiB | 124.13 MiB | 7.01 | 6.19 million | 21.03 | | Thread ids that are participating in query execution. These threads may not have run simultaneously. |
| event_time_microseconds | DateTime64(6) | 14.36 MiB | 47.19 MiB | 3.29 | 6.19 million | 7.99 | | Query starting time with microseconds precision. |
| initial_query_start_time_microseconds | DateTime64(6) | 11.97 MiB | 47.19 MiB | 3.94 | 6.19 million | 7.99 | | Initial query starting time with microseconds precision (for distributed query execution). |
| query_start_time_microseconds | DateTime64(6) | 11.97 MiB | 47.19 MiB | 3.94 | 6.19 million | 7.99 | | Start time of query execution with microsecond precision. |
| Settings | Map(LowCardinality(String), LowCardinality(String)) | 8.43 MiB | 291.43 MiB | 34.59 | 6.19 million | 49.36 | | Settings that were changed when the client ran the query. To enable logging changes to settings, set the log_query_settings parameter to 1. |
| port | UInt16 | 7.44 MiB | 11.80 MiB | 1.59 | 6.19 million | 2 | | The client port that was used to make the query. |
| initial_port | UInt16 | 7.44 MiB | 11.80 MiB | 1.59 | 6.19 million | 2 | | The client port that was used to make the parent query. |
| normalized_query_hash | UInt64 | 5.48 MiB | 47.19 MiB | 8.62 | 6.19 million | 7.99 | | Identical hash value without the values of literals for similar queries. |
| memory_usage | UInt64 | 5.25 MiB | 47.19 MiB | 8.99 | 6.19 million | 7.99 | | Memory consumption by the query. |
| columns | Array(LowCardinality(String)) | 4.97 MiB | 111.70 MiB | 22.46 | 6.19 million | 18.92 | | Names of the columns present in the query. |
| result_bytes | UInt64 | 3.72 MiB | 47.19 MiB | 12.67 | 6.19 million | 7.99 | | RAM volume in bytes used to store a query result. |
| read_bytes | UInt64 | 3.24 MiB | 47.19 MiB | 14.55 | 6.19 million | 7.99 | | 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. |
| tables | Array(LowCardinality(String)) | 2.96 MiB | 52.54 MiB | 17.72 | 6.19 million | 8.9 | | Names of the tables present in the query. |
| query_duration_ms | UInt64 | 2.53 MiB | 47.19 MiB | 18.65 | 6.19 million | 7.99 | | Duration of query execution in milliseconds. |
| read_rows | UInt64 | 2.47 MiB | 47.19 MiB | 19.13 | 6.19 million | 7.99 | | 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. |
| used_functions | Array(LowCardinality(String)) | 2.45 MiB | 54.47 MiB | 22.2 | 6.19 million | 9.23 | | Canonical names of functions, which were used during query execution. |
| result_rows | UInt64 | 2.25 MiB | 47.19 MiB | 21.01 | 6.19 million | 7.99 | | Number of rows in a result of the SELECT query, or a number of rows in the INSERT query. |
| asynchronous_read_counters | Map(LowCardinality(String), UInt64) | 2.21 MiB | 73.19 MiB | 33.05 | 6.19 million | 12.4 | | Metrics for asynchronous reading. |
| peak_threads_usage | UInt64 | 2.06 MiB | 47.19 MiB | 22.9 | 6.19 million | 7.99 | | Maximum count of simultaneous threads executing the query. |
| used_privileges | Array(LowCardinality(String)) | 2.06 MiB | 59.03 MiB | 28.72 | 6.19 million | 10 | | Privileges which were successfully checked during query execution. |
| databases | Array(LowCardinality(String)) | 1.92 MiB | 50.78 MiB | 26.52 | 6.19 million | 8.6 | | Names of the databases present in the query. |
| used_formats | Array(LowCardinality(String)) | 1.41 MiB | 49.46 MiB | 34.97 | 6.19 million | 8.38 | | Canonical names of formats, which were used during query execution. |
| address | IPv6 | 1.25 MiB | 94.38 MiB | 75.54 | 6.19 million | 15.99 | | IP address that was used to make the query. |
| initial_address | IPv6 | 1.25 MiB | 94.38 MiB | 75.54 | 6.19 million | 15.99 | | IP address that the parent query was launched from. |
| query_cache_usage | Enum8('Unknown' = 0, 'None' = 1, 'Write' = 2, 'Read' = 3) | 1.20 MiB | 5.90 MiB | 4.9 | 6.19 million | 1 | | 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. |
| used_data_type_families | Array(LowCardinality(String)) | 1021.48 KiB | 49.04 MiB | 49.16 | 6.19 million | 8.31 | | Canonical names of data type families, which were used during query execution. |
| type | Enum8('QueryStart' = 1, 'QueryFinish' = 2, 'ExceptionBeforeStart' = 3, 'ExceptionWhileProcessing' = 4) | 935.99 KiB | 5.90 MiB | 6.45 | 6.19 million | 1 | | Type of an event that occurred when executing the query. |
| used_aggregate_functions | Array(LowCardinality(String)) | 918.66 KiB | 47.98 MiB | 53.49 | 6.19 million | 8.13 | | Canonical names of aggregate functions, which were used during query execution. |
| partitions | Array(LowCardinality(String)) | 885.68 KiB | 53.22 MiB | 61.53 | 6.19 million | 9.01 | | Names of the partitions present in the query. |
| initial_query_start_time | DateTime | 803.98 KiB | 23.59 MiB | 30.05 | 6.19 million | 4 | | Initial query starting time (for distributed query execution). |
| query_start_time | DateTime | 802.99 KiB | 23.59 MiB | 30.09 | 6.19 million | 4 | | Start time of query execution. |
| forwarded_for | String | 793.20 KiB | 52.25 MiB | 67.46 | 6.19 million | 8.85 | | HTTP header X-Forwarded-For passed in the HTTP query. |
| event_time | DateTime | 764.41 KiB | 23.59 MiB | 31.61 | 6.19 million | 4 | | Query starting time. |
| stack_trace | String | 652.42 KiB | 231.82 MiB | 363.84 | 6.19 million | 39.27 | | Stack trace. An empty string, if the query was completed successfully. |
| written_bytes | UInt64 | 574.47 KiB | 24.39 MiB | 43.47 | 6.19 million | 4.13 | | For INSERT queries, the number of written bytes (uncompressed). For other queries, the column value is 0. |
| client_revision | UInt32 | 440.69 KiB | 16.62 MiB | 38.63 | 6.19 million | 2.82 | | Revision of the clickhouse-client or another TCP client. |
| client_version_minor | UInt32 | 417.93 KiB | 16.62 MiB | 40.73 | 6.19 million | 2.82 | | Minor version of the clickhouse-client or another TCP client. |
| client_version_major | UInt32 | 416.03 KiB | 16.62 MiB | 40.92 | 6.19 million | 2.82 | | Major version of the clickhouse-client or another TCP client. |
| client_version_patch | UInt32 | 412.87 KiB | 16.62 MiB | 41.23 | 6.19 million | 2.82 | | Patch component of the clickhouse-client or another TCP client version. |
| written_rows | UInt64 | 358.87 KiB | 24.39 MiB | 69.59 | 6.19 million | 4.13 | | For INSERT queries, the number of written rows. For other queries, the column value is 0. |
| initial_user | LowCardinality(String) | 346.42 KiB | 5.91 MiB | 17.48 | 6.19 million | 1 | | Name of the user who ran the initial query (for distributed query execution). |
| user | LowCardinality(String) | 346.42 KiB | 5.91 MiB | 17.48 | 6.19 million | 1 | | Name of the user who initiated the current query. |
| http_user_agent | LowCardinality(String) | 344.28 KiB | 5.92 MiB | 17.6 | 6.19 million | 1 | | HTTP header UserAgent passed in the HTTP query. |
| query_kind | LowCardinality(String) | 334.48 KiB | 5.91 MiB | 18.1 | 6.19 million | 1 | | Type of the query. |
| http_method | UInt8 | 306.21 KiB | 5.90 MiB | 19.73 | 6.19 million | 1 | | 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. |
| interface | UInt8 | 306.19 KiB | 5.90 MiB | 19.73 | 6.19 million | 1 | | Interface that the query was initiated from. Possible values: 1 — TCP, 2 — HTTP. |
| current_database | LowCardinality(String) | 254.46 KiB | 5.91 MiB | 23.79 | 6.19 million | 1 | | Name of the current database. |
| client_hostname | LowCardinality(String) | 227.63 KiB | 5.91 MiB | 26.59 | 6.19 million | 1 | | Hostname of the client machine where the clickhouse-client or another TCP client is run. |
| os_user | LowCardinality(String) | 227.54 KiB | 5.91 MiB | 26.6 | 6.19 million | 1 | | Operating system username who runs clickhouse-client. |
| client_name | LowCardinality(String) | 227.16 KiB | 5.91 MiB | 26.65 | 6.19 million | 1 | | The clickhouse-client or another TCP client name. |
| exception | String | 146.08 KiB | 19.89 MiB | 139.43 | 6.19 million | 3.37 | | Exception message. |
| used_table_functions | Array(LowCardinality(String)) | 145.52 KiB | 47.28 MiB | 332.71 | 6.19 million | 8.01 | | Canonical names of table functions, which were used during query execution. |
| used_aggregate_function_combinators | Array(LowCardinality(String)) | 56.59 KiB | 47.20 MiB | 854.22 | 6.19 million | 8 | | Canonical names of aggregate functions combinators, which were used during query execution. |
| exception_code | Int32 | 46.99 KiB | 2.45 MiB | 53.41 | 6.19 million | 0.42 | | Code of an exception. |
| used_storages | Array(LowCardinality(String)) | 46.27 KiB | 47.20 MiB | 1044.42 | 6.19 million | 7.99 | | Canonical names of storages, which were used during query execution. |
| missing_privileges | Array(LowCardinality(String)) | 33.62 KiB | 47.19 MiB | 1437.19 | 6.19 million | 7.99 | | Privileges that are missing during query execution. |
| used_database_engines | Array(LowCardinality(String)) | 32.54 KiB | 47.19 MiB | 1484.9 | 6.19 million | 7.99 | | Canonical names of database engines, which were used during query execution. |
| projections | Array(LowCardinality(String)) | 32.53 KiB | 47.19 MiB | 1485.57 | 6.19 million | 7.99 | | Names of the projections used during the query execution. |
| views | Array(LowCardinality(String)) | 32.29 KiB | 47.19 MiB | 1496.22 | 6.19 million | 7.99 | | Names of the (materialized or live) views present in the query. |
| used_row_policies | Array(LowCardinality(String)) | 32.29 KiB | 47.19 MiB | 1496.22 | 6.19 million | 7.99 | | The list of row policies names that were used during query execution. |
| used_dictionaries | Array(LowCardinality(String)) | 32.29 KiB | 47.19 MiB | 1496.22 | 6.19 million | 7.99 | | Canonical names of dictionaries, which were used during query execution. |
| revision | UInt32 | 16.81 KiB | 23.59 MiB | 1437.11 | 6.19 million | 4 | | ClickHouse revision. |
| event_date | Date | 9.09 KiB | 11.80 MiB | 1329.24 | 6.19 million | 2 | | Query starting date. |
| hostname | LowCardinality(String) | 8.27 KiB | 5.91 MiB | 732.36 | 6.19 million | 1 | | Hostname of the server executing the query. |
| transaction_id | Tuple(UInt64, UInt64, UUID) | 5.17 KiB | 21.75 KiB | 4.21 | 6.19 million | 0 | | The identifier of the transaction in scope of which this query was executed. |
| is_initial_query | UInt8 | 4.47 KiB | 5.90 MiB | 1351.9 | 6.19 million | 1 | | Query type. Possible values: 1 — query was initiated by the client, 0 — query was initiated by another query as part of distributed query execution. |
| http_referer | String | 1.84 KiB | 7.67 KiB | 4.17 | 6.19 million | 0 | | HTTP header Referer passed in the HTTP query (contains an absolute or partial address of the page making the query). |
| is_secure | UInt8 | 1.72 KiB | 7.25 KiB | 4.21 | 6.19 million | 0 | | The flag whether a query was executed over a secure interface |
| formatted_query | String | 1.72 KiB | 7.25 KiB | 4.21 | 6.19 million | 0 | | Formatted query string. |
| quota_key | String | 1.72 KiB | 7.25 KiB | 4.21 | 6.19 million | 0 | | The quota key specified in the quotas setting (see keyed). |
| distributed_depth | UInt64 | 1.72 KiB | 7.25 KiB | 4.21 | 6.19 million | 0 | | How many times a query was forwarded between servers. |
| log_comment | String | 1.72 KiB | 7.25 KiB | 4.21 | 6.19 million | 0 | | Log comment. It can be set to arbitrary string no longer than max_query_size. An empty string if it is not defined. |
