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: add SHOW QUERIES for TRANSACTION ID <> #52826

Closed
awoods187 opened this issue Aug 14, 2020 · 1 comment
Closed

sql: add SHOW QUERIES for TRANSACTION ID <> #52826

awoods187 opened this issue Aug 14, 2020 · 1 comment
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) no-issue-activity X-stale

Comments

@awoods187
Copy link
Contributor

awoods187 commented Aug 14, 2020 •
edited by cockroach-jira-scripts
Loading

Now that we will have SHOW TRANSACTIONS via #51902 (review), I think we should allow for the more easy combining of SHOW TRANSACTIONS and SHOW QUERIES. I'm envisioning someone seeing a long-running transaction via SHOW TRANSACTIONS and wanting to know what queries its already run as well as what query it is currently executing.

Hence, I'm suggesting adding:

SHOW QUERIES for TRANSACTION ID <>

Jira issue: CRDB-3909
@awoods187 awoods187 added the C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) label Aug 14, 2020
@awoods187 awoods187 mentioned this issue Aug 14, 2020
Merged
@github-actions
Copy link

github-actions bot commented Sep 7, 2023

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 18, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) no-issue-activity X-stale
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@awoods187