Skip to content

ui: add blocking information for active queries/txns in WAITING state #79131

@xinhaoz

Description

@xinhaoz

Figma: https://www.figma.com/file/xdmwvnFQd6KkO9RJ0XLDH0/22.1_SQL-obsrv_query-performance?node-id=6152%3A136586

On the active transaction details page, update UI to show:

  • blocked database, table, schema, index and row
  • time spent waiting
  • add table for transactions waiting for currently_viewed_txn shown txn
  • add table for transactions that currently_viewed_txn is waiting for

On the active stmt details page, update UI to show:

  • blocked table and row
  • add table for statements that currently_viewed_stmt is waiting for

Jira issue: CRDB-14590

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-observabilityRelated to observability of the SQL layerC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions