发布

  • [OPIK-6968] [BE] perf: filter trace_threads join in getMinimalThreadInfoByIds (#7158)

    frostbyte_neo 发布于 2026-06-19 07:24:37 +00:00

    The LEFT JOIN to trace_threads in getMinimalThreadInfoByIds had no
    workspace/project/thread predicate on the joined side, so every call built
    its join hash table from the entire trace_threads table regardless of how
    few thread_ids were requested. Push the existing
    workspace_id/project_id/thread_ids filter into the joined subquery so it
    reads only the matching rows. Output is unchanged (filtering by the join
    keys cannot drop matches).

    Co-authored-by: Claude Opus 4.8 (1M context) noreply@anthropic.com

    下载附件