Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[YSQL] Support for auto analyzing the workloads and make recommendations #11865

Open
sushantrmishra opened this issue Mar 23, 2022 · 0 comments
Assignees
Labels
area/ysql Yugabyte SQL (YSQL) current-roadmap kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue roadmap-tracking-issue This issue tracks a major roadmap item, and usually appears in the roadmap list.

Comments

@sushantrmishra
Copy link

sushantrmishra commented Mar 23, 2022

Jira Link: DB-891

Description

This is primary tracking issue for performance advisor project. On high level we plan to add the support for the following.

  • Index suggestions:
  • Capture explain plan for slower queries
  • Recommendation to run Analyze on the table
  • Hot shard detection
  • Suggestion to install extension based on the use cases
@sushantrmishra sushantrmishra added the area/ysql Yugabyte SQL (YSQL) label Mar 23, 2022
@sushantrmishra sushantrmishra self-assigned this Mar 23, 2022
@sushantrmishra sushantrmishra added the roadmap-tracking-issue This issue tracks a major roadmap item, and usually appears in the roadmap list. label Mar 23, 2022
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 8, 2022
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/bug This issue is a bug labels Sep 18, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) current-roadmap kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue roadmap-tracking-issue This issue tracks a major roadmap item, and usually appears in the roadmap list.
Projects
None yet
Development

No branches or pull requests

3 participants