-
Notifications
You must be signed in to change notification settings - Fork 4.1k
Query plan changes can be easily detected through our internal tables and the SQL CLI #67500
Copy link
Copy link
Closed
Labels
A-sql-cli-observabilityIssues related to surfacing SQL observability in SHOW, CRDB_INTERNAL, SYSTEM, etc.Issues related to surfacing SQL observability in SHOW, CRDB_INTERNAL, SYSTEM, etc.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 Console
Description
We're adding persisted statistics to allow developers to see trends in query performance over time using our internal tables and the DB console. We should augment these views with a way to allow developers to easily detect query plan changes over time.
For initial detection, we should introduce some hash or unique identifier for each plan. The developer should then be able to quickly view the plans themselves and understand what the specific change was.
Tracking plan hash item:
Epic: CRDB-6564
Jira issue: CRDB-8575
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-cli-observabilityIssues related to surfacing SQL observability in SHOW, CRDB_INTERNAL, SYSTEM, etc.Issues related to surfacing SQL observability in SHOW, CRDB_INTERNAL, SYSTEM, etc.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 Console