profiling-statement-fingerprints
Ranks and analyzes statement fingerprints using aggregated SQL statistics from crdb_internal.statement_statistics to identify slow, resource-intensive, or error-prone query patterns. Use when investigating historical performance trends, identifying optimization opportunities, or diagnosing recurring slowness without DB Console access.
- Version
- 1.0
- Compatibility
- Requires SQL access with VIEWACTIVITY or VIEWACTIVITYREDACTED cluster privilege. Uses crdb_internal.statement_statistics (production-safe). Execution statistics fields are sampled and may be sparse.
Pinned to revision 4e8964e24a5a, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/profiling-statement-fingerprints/SKILL.md
- skills/profiling-statement-fingerprints/cockroachdb-observability-and-diagnostics/monitoring-background-jobs/SKILL.md
- skills/profiling-statement-fingerprints/cockroachdb-observability-and-diagnostics/profiling-transaction-fingerprints/SKILL.md
- skills/profiling-statement-fingerprints/cockroachdb-observability-and-diagnostics/triaging-live-sql-activity/SKILL.md
- skills/profiling-statement-fingerprints/cockroachdb-observability-and-diagnostics/triaging-live-sql-activity/references/permissions.md
- skills/profiling-statement-fingerprints/references/json-field-reference.md
- skills/profiling-statement-fingerprints/references/metrics-and-units.md
- skills/profiling-statement-fingerprints/references/sql-query-variations.md
Every link opens the file at its source, pinned to the revision this page describes.