profiling-statement-fingerprints
OfficialIdentify slow statements from historical stats.
Authorcockroachlabs
Version1.0.0
Installs0
System Documentation
What problem does it solve?
The skill ranks and analyzes historical SQL fingerprints using crdb_internal.statement_statistics to identify slow, resource-intensive, or error-prone queries when DB Console access is not available.
Core Features & Use Cases
- Analyze latency, CPU, contention, and admission waits across time buckets to surface slow fingerprints.
- Detect plan instability by identifying multiple plan_hash values for the same fingerprint over time.
- Provides workflows for slowness triage, contention analysis, admission control debugging, and memory/disk spill investigations.
Quick Start
Run profiling-statement-fingerprints for a 24-hour window to surface slow fingerprints and optimization opportunities.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: profiling-statement-fingerprints Download link: https://github.com/cockroachlabs/cockroachdb-skills/archive/main.zip#profiling-statement-fingerprints Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.