-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: add ability to get a hash value from a logical plan #63885
Copy link
Copy link
Closed
Labels
C-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)T-sql-queriesSQL Queries TeamSQL Queries Team
Description
Currently, @cockroachdb/sql-observability are working towards adding the ability to compare historical query plans for a given statement.
We want to be able to quickly tell if the plan for a given statement has changed in a specified interval. Ideally, we should be able to do this without comparing the entire plan structure.
Since we already anonymized statements by removing constants in the statement, two plans with the same structure but different scan contraint values should produce the same hash.
Epic: CRDB-8631
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-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)T-sql-queriesSQL Queries TeamSQL Queries Team
Type
Projects
Status
Done