search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.06k stars 3.8k forks source link

sql: display admission control wait time in EXPLAIN ANALYZE output #125633

Open rytaft opened 4 months ago

rytaft commented 4 months ago

We already display several sources of wait time in the EXPLAIN ANALYZE output (e.g., contention). It would be useful to display admission control queuing time as well to help identify the source of a slow query.

Jira issue: CRDB-39538 Epic CRDB-37757

DrewKimball commented 4 months ago

[triage] If we have a ctx object in scope wherever we're waiting, it should be a relatively simple change to notify admission control wait-time listeners in the trace.