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

    系统。trace_log

    包含采样查询探查器收集的堆栈跟踪。

    ClickHouse创建此表时 trace_log 服务器配置部分被设置。 也是 和 query_profiler_cpu_time_period_ns 应设置设置。

    列:

    • event_date () — Date of sampling moment.

    • event_time (日期时间) — Timestamp of the sampling moment.

    • timestamp_ns () — Timestamp of the sampling moment in nanoseconds.

    • 通过以下方式连接到服务器 clickhouse-client，你看到的字符串类似于 . 该字段包含 revision，但不是 version 的服务器。

    • timer_type (枚举8) — Timer type:

      • CPU 表示CPU时间。

    • thread_number () — Thread identifier.

    • query_id (字符串) — Query identifier that can be used to get details about a query that was running from the 系统表.

    示例

    1. Row 1:
    2. event_date:    2019-11-15
    3. event_time:    2019-11-15 15:09:38
    4. revision:      54428
    5. timer_type:    Real
    6. thread_number: 48
    7. trace:         [94222141367858,94222152240175,94222152325351,94222152329944,94222152330796,94222151449980,94222144088167,94222151682763,94222144088167,94222151682763,94222144088167,94222144058283,94222144059248,94222091840750,94222091842302,94222091831228,94222189631488,140509950166747,140509942945935]