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: expose contention time for write operators #106266

Closed
cucaroach opened this issue Jul 6, 2023 · 0 comments · Fixed by #106354
Closed

sql: expose contention time for write operators #106266

cucaroach opened this issue Jul 6, 2023 · 0 comments · Fixed by #106354
Assignees
@yuzefovich
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team

Comments

@cucaroach
Copy link
Contributor

cucaroach commented Jul 6, 2023 •
edited by cockroach-jira-scripts
Loading

KV contention time is only reported for the read "scan" operators, we should also expose contention time for insert/update/delete operators. Inspired by https://github.com/cockroachlabs/support/issues/2434

Jira issue: CRDB-29472
@cucaroach cucaroach added the C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) label Jul 6, 2023
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Jul 6, 2023
@yuzefovich yuzefovich self-assigned this Jul 6, 2023
@yuzefovich yuzefovich mentioned this issue Jul 7, 2023
Merged
@craig craig bot closed this as completed in afe228e Jul 7, 2023
@blathers-crl blathers-crl bot mentioned this issue Jul 7, 2023
Merged
@mgartner mgartner moved this to Done in SQL Queries Jul 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@yuzefovich yuzefovich

Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
Projects
SQL Queries
Archived in project
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

sql: report contention on writes in EXPLAIN ANALYZE yuzefovich/cockroach
2 participants
@yuzefovich @cucaroach