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.

Sign up for GitHub

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

Jump to bottom

sql/webui: apply explain analyze (debug)/diagnostics to transactions #50842

Open
awoods187 opened this issue Jun 30, 2020 · 1 comment
Open

sql/webui: apply explain analyze (debug)/diagnostics to transactions #50842

awoods187 opened this issue Jun 30, 2020 · 1 comment
Labels
A-sql-ui Why is my query slow? A-webui-queryperf C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
Projects
BACKLOG, NO NEW ISSUES: SQL Optimizer

Comments

@awoods187
Copy link
Contributor

awoods187 commented Jun 30, 2020 •
edited by cockroach-jira-scripts

Currently, we can run EXPLAIN ANALYZE(DEBUG) in the SQL shell or diagnostics in the WebUI on a per statement basis. We should be able to expand this to evaluate an entire transaction instead of just one statement.

We need to figure out a way to trigger this collection on a transaction. Can we trigger it before a transaction?

Jira issue: CRDB-4082
@blathers-crl blathers-crl bot added the C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. label Jun 30, 2020
@awoods187 awoods187 added A-sql-ui Why is my query slow? A-webui-queryperf C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) and removed C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. labels Jun 30, 2020
@awoods187 awoods187 added this to Triage in BACKLOG, NO NEW ISSUES: SQL Optimizer via automation Jun 30, 2020
@cockroachdb cockroachdb deleted a comment from blathers-crl bot Jun 30, 2020
@RaduBerinde RaduBerinde moved this from Triage to New features in BACKLOG, NO NEW ISSUES: SQL Optimizer Aug 5, 2020
@jlinder jlinder added the T-sql-queries SQL Queries Team label Jun 16, 2021
@github-actions
Copy link

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

@github-actions github-actions bot closed this as not planned Won't fix, can't repro, duplicate, stale Sep 25, 2023
BACKLOG, NO NEW ISSUES: SQL Optimizer automation moved this from New features to Done Sep 25, 2023
@yuzefovich yuzefovich reopened this May 2, 2024
BACKLOG, NO NEW ISSUES: SQL Optimizer automation moved this from Done to Triage May 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-sql-ui Why is my query slow? A-webui-queryperf C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
Projects
BACKLOG, NO NEW ISSUES: SQL Optimizer
Triage
SQL Queries
Status: Backlog
Milestone
No milestone
Development

No branches or pull requests
3 participants
@jlinder @yuzefovich @awoods187