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

[DocDB] Use statement start time to compute wait time of waiters in pg_locks #20288

Closed
1 task done
robertsami opened this issue Dec 12, 2023 · 0 comments
Closed
1 task done
Labels
area/docdb YugabyteDB core features kind/bug This issue is a bug priority/medium Medium priority issue status/awaiting-triage Issue awaiting triage

Comments

@robertsami
Copy link
Contributor

robertsami commented Dec 12, 2023

Jira Link: DB-9250

Description

The query layer tracks a statement start time for each running statement. We have previously used the time at which a waiter enters the wait queue to display a "wait_time" to users of pg_locks.

However, this is unreliable due to the reasons detailed in the following issues:
#17009
#16286
#16389

A more reliable approach would be to use the pg statement start time provided by the query layer in the WriteQueryRPC it sends to docdb

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

  • I confirm this issue does not contain any sensitive information.
@robertsami robertsami added area/docdb YugabyteDB core features status/awaiting-triage Issue awaiting triage labels Dec 12, 2023
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Dec 12, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/docdb YugabyteDB core features kind/bug This issue is a bug priority/medium Medium priority issue status/awaiting-triage Issue awaiting triage
Projects
Status: Done
Development

No branches or pull requests

2 participants