cockroachdb / cockroachdb/cockroach
sqlstats: track StmtCount in transaction stats
Open
C-enhancement
T-observability
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Currently the statement count can only be obtained for a transaction fingerprint via reading the length of the `stmtFingerprintIDs` arrayin the metadata column. This array is however capped by `sql.metrics.transaction_details.max_statement_ids` (default 1000).
We have seen workloads where transactions can have >1000 statements so we should track a txn fingerprint's stmt count independently.
Jira issue: CRDB-40202
Epic CRDB-39776
Contributor guide
Assessment
This issue has not been assessed yet.