Skip to content

sql: add ability to get a hash value from a logical plan #63885

@Azhng

Description

@Azhng

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

Metadata

Metadata

Assignees

Labels

C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Team

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions