cockroachdb / cockroachdb/cockroach

crdb_internal.statement_statistics idle latency invalid for some internal queries

Open
#93,807 0 comments 0 reactions 0 assignees View on GitHub
A-sql-observability C-bug E-quick-win T-observability
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

**Describe the problem**
The crdb_internal.statement_statistics idle latency shows a value of `9223372036.854776` if the transaction fingerprint id is the default value. It seems to be using a max value for these scenarios.

Run the following query to see the value.
```sql
select statistics->'statistics'->'idleLat'->>'mean' as idleLate_mean, *
from crdb_internal.statement_statistics
```

Screen Shot 2022-12-16 at 3 12 05 PM

Jira issue: CRDB-22536

Epic CRDB-32139

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.