-
Notifications
You must be signed in to change notification settings - Fork 4.1k
kv, sql: visualize current lock holders and waiters via sql #74834
Copy link
Copy link
Closed
Labels
C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-kvKV TeamKV Team
Description
Part of #67589.
In order to visualize the locks currently held by transactions in a database, as well as the transactions waiting on locks, we will need a virtual table that can call out to the KV interface to query locks (#74833) and display the results. This will be a crdb_internal table, called crdb_locks, that can be joined with existing tables such as cluster_transactions and cluster_queries to visualize what transactions are currently holding or blocked waiting for a particular lock.
Jira issue: CRDB-12288
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-kvKV TeamKV Team