Skip to content

insights: add more txn insights #107318

@michae2

Description

@michae2

Similar to #93076, there are yet more pieces of information about SQL transactions that would be nice to have in txn insights:

  • isolation level (from connExecutor.state.isolationLevel)
  • Quality of Service level (for admission control) (might have to be plumbed through from txn.AdmissionHeader().Priority?)
  • as of time, if using AS OF SYSTEM TIME (from connExecutor.state.getReadTimestamp() or at least connExecutor.state.isHistorical)
  • whether the transaction is read-only (from connExecutor.state.readOnly)

Jira issue: CRDB-29986

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)E-quick-winLikely to be a quick win for someone experienced.T-sql-queriesSQL Queries Team

    Type

    No type

    Projects

    Status

    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions