TraceQL
At ClickHouse® database speed

SELECT trace_id, max(timestamp_ns) AS bound_ts
FROM trace_spans
PREWHERE service = 'checkout'
WHERE timestamp_ns >= {start} AND timestamp_ns < {end}
GROUP BY trace_id
ORDER BY bound_ts DESC, trace_id ASC
LIMIT 20

SELECT
  toUnixTimestamp64Milli(toStartOfInterval(
    fromUnixTimestamp64Nano(timestamp_ns), INTERVAL 60000 MILLISECOND
  )) AS t,
  service AS g0,
  uniqExact(trace_id, span_id) AS n
FROM trace_spans
WHERE timestamp_ns >= {start} AND timestamp_ns < {end}
  AND duration_ns > 1000000000
GROUP BY t, g0
ORDER BY t ASC, g0

SELECT t, attribute_key, attribute_value,
  countIf(is_selected = 0) AS baseline_count,
  countIf(is_selected = 1) AS selected_count
FROM (
  SELECT t, is_selected, kv.1 AS attribute_key, kv.2 AS attribute_value
  FROM (
    SELECT t, is_selected, arrayJoin([
      ('name', span_name), ('status', span_status),
      ('resource.service.name', service),
      ('rootServiceName', root_service)
    ]) AS kv
    FROM (
      SELECT t, trace_id, span_id, any(name) AS span_name,
        any(status_code) AS span_status, any(service) AS service,
        max((trace_id, span_id) IN (
          SELECT trace_id, span_id FROM trace_attrs_idx
          WHERE key = 'http.status_code' AND val = '500'
            AND scope = 'span' AND date BETWEEN {d0} AND {d1}
        )) AS is_selected
      FROM trace_spans PREWHERE service = 'checkout'
      WHERE timestamp_ns >= {start} AND timestamp_ns < {end}
      GROUP BY t, trace_id, span_id
    ) AS cohort
    LEFT JOIN ({root_span_projection}) AS roots USING (trace_id)
  )
  UNION ALL
  SELECT cohort.t, cohort.is_selected,
    concat(attrs.scope, '.', attrs.key), attrs.val
  FROM ({deduplicated_cohort}) AS cohort
  INNER JOIN (
    SELECT DISTINCT trace_id, span_id, scope, key, val
    FROM trace_attrs_idx WHERE date BETWEEN {d0} AND {d1}
  ) AS attrs USING (trace_id, span_id)
)
GROUP BY t, attribute_key, attribute_value
ORDER BY t ASC, attribute_key, attribute_value