The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated text lives on GitHub repository alongside main ClickHouse codebase and waits for fellow native speakers to make it more human-readable.

    Help ClickHouse documentation by editing this page

    系统。query_thread_log

    开始记录:

    1. 在配置参数 query_thread_log 科。
    2. 设置 到1。

    数据的冲洗周期设置在 的参数 query_thread_log 服务器设置部分。 要强制冲洗，请使用 查询。

    列:

    • event_date (日期) — The date when the thread has finished execution of the query.
    • event_time () — The date and time when the thread has finished execution of the query.
    • query_start_time (日期时间) — Start time of query execution.
    • query_duration_ms () — Duration of query execution.
    • read_rows (UInt64) — Number of read rows.
    • read_bytes () — Number of read bytes.
    • written_rows (UInt64) — For INSERT 查询，写入的行数。 对于其他查询，列值为0。
    • written_bytes () — For INSERT 查询时，写入的字节数。 对于其他查询，列值为0。
    • memory_usage (Int64) — The difference between the amount of allocated and freed memory in context of this thread.
    • peak_memory_usage () — The maximum difference between the amount of allocated and freed memory in context of this thread.
    • thread_name (字符串) — Name of the thread.
    • thread_number () — Internal thread ID.
    • thread_id (Int32) — thread ID.
    • master_thread_id () — OS initial ID of initial thread.
    • query (字符串) — Query string.
    • is_initial_query () — Query type. Possible values:
      • 1 — Query was initiated by the client.
      • 0 — Query was initiated by another query for distributed query execution.
    • user (字符串) — Name of the user who initiated the current query.
    • query_id () — ID of the query.
    • address (IPv6) — IP address that was used to make the query.
    • port () — The client port that was used to make the query.
    • initial_user (字符串) — Name of the user who ran the initial query (for distributed query execution).
    • initial_query_id () — ID of the initial query (for distributed query execution).
    • initial_address (IPv6) — IP address that the parent query was launched from.
    • initial_port () — The client port that was used to make the parent query.
    • (字符串) — OS’s username who runs .
    • client_hostname (字符串) — Hostname of the client machine where the 或者运行另一个TCP客户端。
    • client_name (字符串) — The 或另一个TCP客户端名称。
    • client_revision (UInt32) — Revision of the 或另一个TCP客户端。
    • client_version_major (UInt32) — Major version of the 或另一个TCP客户端。
    • client_version_minor (UInt32) — Minor version of the 或另一个TCP客户端。
    • client_version_patch (UInt32) — Patch component of the 或另一个TCP客户端版本。
    • http_method (UInt8) — HTTP method that initiated the query. Possible values:
      • 0 — The query was launched from the TCP interface.
      • 1 — GET 方法被使用。
      • 2 — POST 方法被使用。
    • http_user_agent () — The UserAgent http请求中传递的标头。
    • quota_key (字符串) — The “quota key” 在指定 设置（见 keyed).
    • revision (UInt32) — ClickHouse revision.
    • ProfileEvents () — Counters that measure different metrics for this thread. The description of them could be found in the table 系统。活动.

    示例

    1. Row 1:
    2. ──────
    3. event_date:           2020-05-13
    4. event_time:           2020-05-13 14:02:28
    5. query_start_time:     2020-05-13 14:02:28
    6. query_duration_ms:    0
    7. read_rows:            1
    8. read_bytes:           1
    9. written_rows:         0
    10. written_bytes:        0
    11. memory_usage:         0
    13. thread_id:            28952
    14. master_thread_id:     28924
    15. query:                SELECT 1
    16. is_initial_query:     1
    17. user:                 default
    18. query_id:             5e834082-6f6d-4e34-b47b-cd1934f4002a
    19. address:              ::ffff:127.0.0.1
    20. port:                 57720
    21. initial_user:         default
    22. initial_query_id:     5e834082-6f6d-4e34-b47b-cd1934f4002a
    23. initial_address:      ::ffff:127.0.0.1
    24. initial_port:         57720
    25. interface:            1
    26. os_user:              bayonet
    27. client_hostname:      clickhouse.ru-central1.internal
    28. client_name:          ClickHouse client
    29. client_revision:      54434
    30. client_version_major: 20
    31. client_version_minor: 4
    32. client_version_patch: 1
    33. http_method:          0
    34. http_user_agent:
    35. quota_key:
    36. revision:             54434
    37. ProfileEvents:        {'Query':1,'SelectQuery':1,'ReadCompressedBytes':36,'CompressedReadBufferBlocks':1,'CompressedReadBufferBytes':10,'IOBufferAllocs':1,'IOBufferAllocBytes':89,'ContextLock':15,'RWLockAcquiredReadLocks':1}
    38. ...
    • — Description of the query_log 系统表，其中包含有关查询执行的公共信息。