LogoClawIndex
CasesSkillsAbout
LogoClawIndex

triaging-live-sql-activity - Diagnose live CockroachDB SQL activity

Diagnoses live CockroachDB performance issues by finding long-running queries, busy sessions, active transactions, and their source applications through SQL.

Tags

Updated: 2026-09-28
CockroachDBSQLlive activityperformance triagequery monitoringtransaction monitoring

Capabilities

Identify long-running queriesCorrelate sessions and applicationsInspect transaction retry countsFilter by application, user, client

Typical Inputs

CockroachDB SQL connectionCluster visibility privilegesOptional duration thresholds

Typical Outputs

Live query findingsActive session findingsLong-running transaction findings

What this skill does

  • Identify long-running queries
  • Correlate sessions and applications
  • Inspect transaction retry counts
  • Filter by application, user, client
  • Generate cancellation SQL
  • Cancel runaway queries or sessions

Inputs

  • CockroachDB SQL connection
  • Cluster visibility privileges
  • Optional duration thresholds
  • Optional application, user, or client filters
  • Optional query or session identifiers

Outputs

  • Live query findings
  • Active session findings
  • Long-running transaction findings
  • Application and client correlations
  • Cancellation SQL statements
  • Query or session cancellation status

Requirements

  • CockroachDB SQL access
  • VIEWACTIVITY or VIEWACTIVITYREDACTED for cluster-wide visibility
  • Basic SQL execution knowledge
  • CANCELQUERY or CANCELSESSION for cancellation operations

Source

  • Spec: SKILL.md

ClawIndex

OpenClaw Skills & Use Case Index

ClawIndex is an ecosystem-driven index of OpenClaw skills and real-world use cases.

Index

Skills·
Cases

Meta

About·
Disclaimer·
Email·
GitHub
© 2026 ClawIndex All Rights Reserved.