[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/operations/system-tables/opentelemetry_span_log.md)

Querying in ClickHouse Cloud

The data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the `clusterAllReplicas` function. See [here](/docs/operations/system-tables/overview#system-tables-in-clickhouse-cloud) for further details.

Contains information about [trace spans](https://opentracing.io/docs/overview/spans/) for executed queries.

Columns:

- `trace_id` ([UUID](/docs/sql-reference/data-types/uuid)) — ID of the trace for executed query.
- `span_id` ([UInt64](/docs/sql-reference/data-types/int-uint)) — ID of the `trace span`.
- `parent_span_id` ([UInt64](/docs/sql-reference/data-types/int-uint)) — ID of the parent `trace span`.
- `operation_name` ([String](/docs/sql-reference/data-types/string)) — The name of the operation.
- `kind` ([Enum8](/docs/sql-reference/data-types/enum)) — The [SpanKind](https://opentelemetry.io/docs/reference/specification/trace/api/#spankind) of the span.
  - `INTERNAL` — Indicates that the span represents an internal operation within an application.
  - `SERVER` — Indicates that the span covers server-side handling of a synchronous RPC or other remote request.
  - `CLIENT` — Indicates that the span describes a request to some remote service.
  - `PRODUCER` — Indicates that the span describes the initiators of an asynchronous request. This parent span will often end before the corresponding child CONSUMER span, possibly even before the child span starts.
  - `CONSUMER` - Indicates that the span describes a child of an asynchronous PRODUCER request.
- `start_time_us` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The start time of the `trace span` (in microseconds).
- `finish_time_us` ([UInt64](/docs/sql-reference/data-types/int-uint)) — The finish time of the `trace span` (in microseconds).
- `finish_date` ([Date](/docs/sql-reference/data-types/date)) — The finish date of the `trace span`.
- `status_code` ([Enum8](/docs/sql-reference/data-types/enum)) — The status code of the span.
- `status_message` ([String](/docs/sql-reference/data-types/string)) — Error message associated with the span, if any. Empty when status\_code is not ERROR.
- `attribute.names` ([Array](/docs/sql-reference/data-types/array)([String](/docs/sql-reference/data-types/string))) — [Attribute](https://opentelemetry.io/docs/go/instrumentation/#attributes) names depending on the `trace span`. They are filled in according to the recommendations in the [OpenTelemetry](https://opentelemetry.io/) standard.
- `attribute.values` ([Array](/docs/sql-reference/data-types/array)([String](/docs/sql-reference/data-types/string))) — Attribute values depending on the `trace span`. They are filled in according to the recommendations in the `OpenTelemetry` standard.

**Example**

Query:

```
SELECT * FROM system.opentelemetry_span_log LIMIT 1 FORMAT Vertical;
```

Result:

```
Row 1:
──────
trace_id:         cdab0847-0d62-61d5-4d38-dd65b19a1914
span_id:          701487461015578150
parent_span_id:   2991972114672045096
operation_name:   DB::Block DB::InterpreterSelectQuery::getSampleBlockImpl()
kind:             INTERNAL
start_time_us:    1612374594529090
finish_time_us:   1612374594529108
finish_date:      2021-02-03
attribute.names:  []
attribute.values: []
```

**See Also**

- [OpenTelemetry](/docs/operations/opentelemetry)

Was this page helpful?