Skip to content

insights: surface suboptimal plans and failed executions#86458

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
matthewtodd:insights-suboptimal-plan-failed
Aug 19, 2022
Merged

insights: surface suboptimal plans and failed executions#86458
craig[bot] merged 1 commit intocockroachdb:masterfrom
matthewtodd:insights-suboptimal-plan-failed

Conversation

@matthewtodd
Copy link
Copy Markdown

Fixes #85827.

Release justification: Category 2: Bug fixes and low-risk updates to new
functionality.

Release note: None

@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

Copy link
Copy Markdown
Author

@matthewtodd matthewtodd left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Reviewable status: :shipit: complete! 0 of 0 LGTMs obtained


pkg/sql/sqlstats/insights/problems.go line 28 at r1 (raw file):

	}

	if stmt.Status == "failed" {

@j82w this makes me want to change Status to an enum. Okay if I do that here?

@matthewtodd matthewtodd requested a review from a team August 19, 2022 15:38
Fixes #85827.

We incidentally also pluralize `Statement.IndexRecommendations` and
make `Statement.Status` an enum.

Release justification: Category 2: Bug fixes and low-risk updates to new
functionality.

Release note: None
@matthewtodd matthewtodd requested a review from a team August 19, 2022 18:06
Copy link
Copy Markdown
Contributor

@maryliag maryliag left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

:lgtm:

Reviewed 6 of 6 files at r2, all commit messages.
Reviewable status: :shipit: complete! 1 of 0 LGTMs obtained (waiting on @maryliag)

@matthewtodd
Copy link
Copy Markdown
Author

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Aug 19, 2022

Build succeeded:

@craig craig bot merged commit 6a51183 into cockroachdb:master Aug 19, 2022
@matthewtodd matthewtodd deleted the insights-suboptimal-plan-failed branch August 19, 2022 21:28
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Add retry and full scan to insights concerns

3 participants