cockroachdb / cockroachdb/cockroach

sql: improve observability into apply join iterations

Open
#151,087 1 comment 0 reactions 0 assignees View on GitHub
A-sql-explain C-enhancement T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Our observability into apply join iterations is limited: we show - probably incomplete - execution statistics in `plan.txt` as well as we include the DistSQL diagrams into the trace. We should improve things here, for example, we could ensure that at least SQL and KV nodes touched by each iteration are reported on `plan.txt` for the main query.

This [slack](https://cockroachlabs.slack.com/archives/C04U1BTF8/p1753918744758289) thread can show an example bundle with incomplete information.

Jira issue: CRDB-53079

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.