| ProfileEvents | Map(LowCardinality(String), UInt64) | 132.90 MiB | 965.26 MiB | 7.26 | 7.70 million | 131.38 | | ProfileEvents that measure different metrics. The description of them could be found in the table system.events |
| query_id | String | 75.39 MiB | 271.48 MiB | 3.6 | 7.70 million | 36.95 | | ID of the query. |
| initial_query_id | String | 75.39 MiB | 271.48 MiB | 3.6 | 7.70 million | 36.95 | | ID of the initial query (for distributed query execution). |
| query | String | 35.93 MiB | 1.94 GiB | 55.22 | 7.70 million | 270.06 | | Query string. |
| thread_ids | Array(UInt64) | 21.18 MiB | 150.56 MiB | 7.11 | 7.70 million | 20.49 | | Thread ids that are participating in query execution. These threads may not have run simultaneously. |
| event_time_microseconds | DateTime64(6) | 17.78 MiB | 58.70 MiB | 3.3 | 7.70 million | 7.99 | | Query starting time with microseconds precision. |
| initial_query_start_time_microseconds | DateTime64(6) | 14.80 MiB | 58.70 MiB | 3.97 | 7.70 million | 7.99 | | Initial query starting time with microseconds precision (for distributed query execution). |
| query_start_time_microseconds | DateTime64(6) | 14.80 MiB | 58.70 MiB | 3.97 | 7.70 million | 7.99 | | Start time of query execution with microsecond precision. |
| Settings | Map(LowCardinality(String), LowCardinality(String)) | 10.47 MiB | 366.32 MiB | 34.98 | 7.70 million | 49.86 | | 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 | 9.19 MiB | 14.67 MiB | 1.6 | 7.70 million | 2 | | The client port that was used to make the query. |
| initial_port | UInt16 | 9.19 MiB | 14.67 MiB | 1.6 | 7.70 million | 2 | | The client port that was used to make the parent query. |
| normalized_query_hash | UInt64 | 6.93 MiB | 58.70 MiB | 8.47 | 7.70 million | 7.99 | | Identical hash value without the values of literals for similar queries. |
| memory_usage | UInt64 | 6.74 MiB | 58.70 MiB | 8.71 | 7.70 million | 7.99 | | Memory consumption by the query. |
| columns | Array(LowCardinality(String)) | 6.68 MiB | 152.48 MiB | 22.84 | 7.70 million | 20.75 | | Names of the columns present in the query. |
| result_bytes | UInt64 | 4.76 MiB | 58.70 MiB | 12.34 | 7.70 million | 7.99 | | RAM volume in bytes used to store a query result. |
| read_bytes | UInt64 | 4.18 MiB | 58.70 MiB | 14.05 | 7.70 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)) | 3.81 MiB | 65.92 MiB | 17.28 | 7.70 million | 8.97 | | Names of the tables present in the query. |
| read_rows | UInt64 | 3.16 MiB | 58.70 MiB | 18.58 | 7.70 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. |
| query_duration_ms | UInt64 | 3.12 MiB | 58.70 MiB | 18.81 | 7.70 million | 7.99 | | Duration of query execution in milliseconds. |
| used_functions | Array(LowCardinality(String)) | 3.05 MiB | 68.08 MiB | 22.35 | 7.70 million | 9.27 | | Canonical names of functions, which were used during query execution. |
| result_rows | UInt64 | 2.86 MiB | 58.70 MiB | 20.53 | 7.70 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.77 MiB | 91.18 MiB | 32.94 | 7.70 million | 12.41 | | Metrics for asynchronous reading. |
| peak_threads_usage | UInt64 | 2.54 MiB | 58.70 MiB | 23.12 | 7.70 million | 7.99 | | Maximum count of simultaneous threads executing the query. |
| used_privileges | Array(LowCardinality(String)) | 2.48 MiB | 74.31 MiB | 29.91 | 7.70 million | 10.11 | | Privileges which were successfully checked during query execution. |
| databases | Array(LowCardinality(String)) | 2.43 MiB | 63.08 MiB | 25.95 | 7.70 million | 8.59 | | Names of the databases present in the query. |
| used_formats | Array(LowCardinality(String)) | 1.79 MiB | 61.57 MiB | 34.34 | 7.70 million | 8.38 | | Canonical names of formats, which were used during query execution. |
| query_cache_usage | Enum8('Unknown' = 0, 'None' = 1, 'Write' = 2, 'Read' = 3) | 1.54 MiB | 7.34 MiB | 4.75 | 7.70 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. |
| address | IPv6 | 1.54 MiB | 117.40 MiB | 76.42 | 7.70 million | 15.98 | | IP address that was used to make the query. |
| initial_address | IPv6 | 1.54 MiB | 117.40 MiB | 76.42 | 7.70 million | 15.98 | | IP address that the parent query was launched from. |
| used_data_type_families | Array(LowCardinality(String)) | 1.24 MiB | 60.98 MiB | 49.3 | 7.70 million | 8.3 | | Canonical names of data type families, which were used during query execution. |
| type | Enum8('QueryStart' = 1, 'QueryFinish' = 2, 'ExceptionBeforeStart' = 3, 'ExceptionWhileProcessing' = 4) | 1.17 MiB | 7.34 MiB | 6.28 | 7.70 million | 1 | | Type of an event that occurred when executing the query. |
| used_aggregate_functions | Array(LowCardinality(String)) | 1.14 MiB | 59.71 MiB | 52.15 | 7.70 million | 8.13 | | Canonical names of aggregate functions, which were used during query execution. |
| partitions | Array(LowCardinality(String)) | 1.12 MiB | 67.35 MiB | 59.96 | 7.70 million | 9.17 | | Names of the partitions present in the query. |
| forwarded_for | String | 966.04 KiB | 68.51 MiB | 72.62 | 7.70 million | 9.32 | | HTTP header X-Forwarded-For passed in the HTTP query. |
| initial_query_start_time | DateTime | 963.57 KiB | 29.35 MiB | 31.19 | 7.70 million | 3.99 | | Initial query starting time (for distributed query execution). |
| query_start_time | DateTime | 962.59 KiB | 29.35 MiB | 31.22 | 7.70 million | 3.99 | | Start time of query execution. |
| event_time | DateTime | 925.30 KiB | 29.35 MiB | 32.48 | 7.70 million | 3.99 | | Query starting time. |
| stack_trace | String | 653.97 KiB | 231.86 MiB | 363.05 | 7.70 million | 31.56 | | Stack trace. An empty string, if the query was completed successfully. |
| written_bytes | UInt64 | 641.08 KiB | 24.96 MiB | 39.88 | 7.70 million | 3.4 | | For INSERT queries, the number of written bytes (uncompressed). For other queries, the column value is 0. |
| client_revision | UInt32 | 467.91 KiB | 16.95 MiB | 37.09 | 7.70 million | 2.31 | | Revision of the clickhouse-client or another TCP client. |
| client_version_minor | UInt32 | 445.15 KiB | 16.95 MiB | 38.98 | 7.70 million | 2.31 | | Minor version of the clickhouse-client or another TCP client. |
| client_version_major | UInt32 | 443.25 KiB | 16.95 MiB | 39.15 | 7.70 million | 2.31 | | Major version of the clickhouse-client or another TCP client. |
| client_version_patch | UInt32 | 440.09 KiB | 16.95 MiB | 39.43 | 7.70 million | 2.31 | | Patch component of the clickhouse-client or another TCP client version. |
| initial_user | LowCardinality(String) | 427.02 KiB | 7.35 MiB | 17.63 | 7.70 million | 1 | | Name of the user who ran the initial query (for distributed query execution). |
| user | LowCardinality(String) | 427.01 KiB | 7.35 MiB | 17.63 | 7.70 million | 1 | | Name of the user who initiated the current query. |
| http_user_agent | LowCardinality(String) | 426.51 KiB | 7.36 MiB | 17.66 | 7.70 million | 1 | | HTTP header UserAgent passed in the HTTP query. |
| query_kind | LowCardinality(String) | 412.57 KiB | 7.35 MiB | 18.25 | 7.70 million | 1 | | Type of the query. |
| written_rows | UInt64 | 408.15 KiB | 24.96 MiB | 62.63 | 7.70 million | 3.4 | | For INSERT queries, the number of written rows. For other queries, the column value is 0. |
| http_method | UInt8 | 379.82 KiB | 7.34 MiB | 19.78 | 7.70 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 | 379.81 KiB | 7.34 MiB | 19.78 | 7.70 million | 1 | | Interface that the query was initiated from. Possible values: 1 — TCP, 2 — HTTP. |
| current_database | LowCardinality(String) | 325.16 KiB | 7.35 MiB | 23.16 | 7.70 million | 1 | | Name of the current database. |
| client_hostname | LowCardinality(String) | 286.13 KiB | 7.35 MiB | 26.32 | 7.70 million | 1 | | Hostname of the client machine where the clickhouse-client or another TCP client is run. |
| os_user | LowCardinality(String) | 286.06 KiB | 7.35 MiB | 26.32 | 7.70 million | 1 | | Operating system username who runs clickhouse-client. |
| client_name | LowCardinality(String) | 285.58 KiB | 7.35 MiB | 26.37 | 7.70 million | 1 | | The clickhouse-client or another TCP client name. |
| used_table_functions | Array(LowCardinality(String)) | 166.83 KiB | 58.80 MiB | 360.92 | 7.70 million | 8 | | Canonical names of table functions, which were used during query execution. |
| exception | String | 146.00 KiB | 19.90 MiB | 139.54 | 7.70 million | 2.71 | | Exception message. |
| used_aggregate_function_combinators | Array(LowCardinality(String)) | 65.77 KiB | 58.72 MiB | 914.14 | 7.70 million | 7.99 | | Canonical names of aggregate functions combinators, which were used during query execution. |
| used_storages | Array(LowCardinality(String)) | 60.99 KiB | 58.71 MiB | 985.69 | 7.70 million | 7.99 | | Canonical names of storages, which were used during query execution. |
| exception_code | Int32 | 47.13 KiB | 2.45 MiB | 53.3 | 7.70 million | 0.33 | | Code of an exception. |
| missing_privileges | Array(LowCardinality(String)) | 41.10 KiB | 58.70 MiB | 1462.44 | 7.70 million | 7.99 | | Privileges that are missing during query execution. |
| used_database_engines | Array(LowCardinality(String)) | 40.02 KiB | 58.70 MiB | 1501.91 | 7.70 million | 7.99 | | Canonical names of database engines, which were used during query execution. |
| projections | Array(LowCardinality(String)) | 40.01 KiB | 58.70 MiB | 1502.46 | 7.70 million | 7.99 | | Names of the projections used during the query execution. |
| views | Array(LowCardinality(String)) | 39.77 KiB | 58.70 MiB | 1511.2 | 7.70 million | 7.99 | | Names of the (materialized or live) views present in the query. |
| used_row_policies | Array(LowCardinality(String)) | 39.77 KiB | 58.70 MiB | 1511.2 | 7.70 million | 7.99 | | The list of row policies names that were used during query execution. |
| used_dictionaries | Array(LowCardinality(String)) | 39.77 KiB | 58.70 MiB | 1511.2 | 7.70 million | 7.99 | | Canonical names of dictionaries, which were used during query execution. |
| revision | UInt32 | 20.71 KiB | 29.35 MiB | 1451.16 | 7.70 million | 3.99 | | ClickHouse revision. |
| event_date | Date | 11.09 KiB | 14.67 MiB | 1354.64 | 7.70 million | 2 | | Query starting date. |
| hostname | LowCardinality(String) | 9.78 KiB | 7.35 MiB | 769.74 | 7.70 million | 1 | | Hostname of the server executing the query. |
| is_initial_query | UInt8 | 5.43 KiB | 7.34 MiB | 1383.01 | 7.70 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. |
| transaction_id | Tuple(UInt64, UInt64, UUID) | 5.12 KiB | 26.95 KiB | 5.27 | 7.70 million | 0 | | The identifier of the transaction in scope of which this query was executed. |
| http_referer | String | 1.82 KiB | 9.40 KiB | 5.16 | 7.70 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.71 KiB | 8.98 KiB | 5.27 | 7.70 million | 0 | | The flag whether a query was executed over a secure interface |
| formatted_query | String | 1.71 KiB | 8.98 KiB | 5.27 | 7.70 million | 0 | | Formatted query string. |
| quota_key | String | 1.71 KiB | 8.98 KiB | 5.27 | 7.70 million | 0 | | The quota key specified in the quotas setting (see keyed). |
| distributed_depth | UInt64 | 1.71 KiB | 8.98 KiB | 5.27 | 7.70 million | 0 | | How many times a query was forwarded between servers. |
| log_comment | String | 1.71 KiB | 8.98 KiB | 5.27 | 7.70 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. |
