triaging-live-sql-activity
Diagnoses live CockroachDB cluster performance issues by identifying long-running queries, busy sessions, and active transactions using SQL-only interfaces. Use when users report cluster slowness, high CPU, or need to find runaway queries and their source applications without DB Console access.
- Version
- 1.0
- Compatibility
- Requires SQL access with VIEWACTIVITY or VIEWACTIVITYREDACTED cluster privilege for cluster-wide visibility.
Pinned to revision 4e8964e24a5a, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/triaging-live-sql-activity/SKILL.md
- skills/triaging-live-sql-activity/cockroachdb-observability-and-diagnostics/monitoring-background-jobs/SKILL.md
- skills/triaging-live-sql-activity/cockroachdb-observability-and-diagnostics/profiling-statement-fingerprints/SKILL.md
- skills/triaging-live-sql-activity/cockroachdb-observability-and-diagnostics/profiling-transaction-fingerprints/SKILL.md
- skills/triaging-live-sql-activity/references/permissions.md
- skills/triaging-live-sql-activity/references/sql-queries.md
Every link opens the file at its source, pinned to the revision this page describes.