cockroachdb / cockroachdb/cockroach
sql: statement_statistics and transaction_statistic adds query to wrong time frame
Open
A-cluster-observability
C-bug
T-observability
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
The system.statement_statistics and system.transaction_statistics information can be added to the later aggregated hour for a window up to 10 minutes based on when the flush occurs.
An example:
1. Statistics flush occurs at 3:54pm
1. Execute query at 3:55pm
1. Execute same query at 4:02pm
1. Statistics flush occurs at 4:04pm
1. Statement_statistics contains 1 row showing 2 executions with an agg_ts of 4pm
Jira issue: CRDB-28444
Contributor guide
Assessment
This issue has not been assessed yet.