-
Notifications
You must be signed in to change notification settings - Fork 4.1k
Persisted statistics are surfaced in the DB console #68089
Copy link
Copy link
Closed
Labels
A-sql-console-generalSQL Observability issues on the DB console spanning multiple areas. Includes Cockroach Cloud ConsoleSQL Observability issues on the DB console spanning multiple areas. Includes Cockroach Cloud ConsoleC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Description
This issue builds on top of persisted statistics by enriching the DB console UX. Rather than the last hour, we will now surface persisted statistics which has a default 1-hour aggregation interval (configurable). We round to the nearest hour for each interval (if the cluster starts at 6:16, the first aggregation window is 6:00). The retention period is sql.stats.cleanup.max_row_limit where the initial default is 10K. High-level improvements:
- The transactions and statements pages should be updated to accommodate persisted statistics
- Persisted statistics also surface changes in the query plan (via a hash and JSON plan tree). We should accommodate this experience in the statements page for query plan regression detection.
- Given a longer retention period, we should see if/how we can now correlate the time-series SQL metrics with the statements and transactions pages
V1:
- The user can specify a time range (start and end time) that will surface all intervals (and their fingerprints) within the specified range on the statements and transactions pages.
- The user can reset stats which will clear/truncate both in-memory and persisted stats.
Epic: CRDB-394
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-console-generalSQL Observability issues on the DB console spanning multiple areas. Includes Cockroach Cloud ConsoleSQL Observability issues on the DB console spanning multiple areas. Includes Cockroach Cloud ConsoleC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)