Closed systay closed 3 days ago
Hello reviewers! :wave: Please follow this checklist when reviewing this Pull Request.
release notes (needs details)
label if users need to know about this change.-
), and have a clear help text.Jobs
should be named in order to mark it as required
.required
, the maintainer team must be notified._vt
tables and RPCs need to be backward compatible.vtctl
command output order should be stable and awk
-able.Attention: Patch coverage is 94.02985%
with 4 lines
in your changes missing coverage. Please review.
Project coverage is 69.45%. Comparing base (
969e018
) to head (ac6138e
).
Files with missing lines | Patch % | Lines |
---|---|---|
go/vt/vtgate/planbuilder/operators/keys.go | 93.75% | 3 Missing :warning: |
go/vt/vtgate/planbuilder/vexplain.go | 94.11% | 1 Missing :warning: |
:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.
Description:
This PR introduces a new VEXPLAIN type called KEYS, designed to assist developers and database administrators in making informed decisions about sharding keys. The VEXPLAIN KEYS command provides a concise summary of the query structure, highlighting columns used in joins, filters, and grouping operations.
Key features:
The output focuses on the structural elements of the query that are most relevant to sharding decisions, without executing the query or providing execution statistics.
Example usage:
This output provides valuable insights for sharding decisions:
By analyzing this information across multiple queries, developers can make more informed decisions about sharding strategies, potentially improving query performance and data distribution.
Related Issue(s)
https://github.com/vitessio/vitess/pull/16768 Docs: https://github.com/vitessio/website/pull/1853
Checklist