cockroachdb / cockroachdb/cockroach

sql: Tool tip update: statement contention metric only shows traced queries

Open
#96,453 6 comments 0 reactions 1 assignee Assigned to @kevin-v-ngo View on GitHub
A-sql-observability C-bug T-observability
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

The Metrics page in the console has a prominent SQL Statement Contention metric, described as "A moving average of the number of SQL statements executed per second that experienced contention across all nodes.".

The metric is based off tracing. Tracing is only enabled on a very small percentage of queries currently. The number being display is significantly less than the actual number of contention events that occur.

Screenshot 2023-02-02 at 1 38 18 PM

Jira issue: CRDB-24131

Epic CRDB-32130

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.