cli: unredacted debug zip query for transaction_contention_events table too slow #123964
Labels
C-bug
Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
T-observability
#118478 aimed to add the query texts for transactions in
crdb_internal.transaction_contention_events
to the debug zip. We've seen this query timeout for clusters experiencing a lot of contention. The join collecting the blocking transaction's query strings results in a full scan of the system.statement_statistics table and should be removed. We can investigate other options or queries that may preserve some of this information.Update May 16:
We'll do 3 things to improve upon what was added:
Jira issue: CRDB-38628
The text was updated successfully, but these errors were encountered: