Analyzes transaction fingerprints using aggregated statistics from crdb_internal.transaction_statistics to identify high-retry transactions, contention patterns, and commit latency issues. Provides historical transaction-level analysis to understand which statement combinations are causing retries, contention, or performance degradation.
Install
npx skills add cockroachdb/claude-plugin --skill profiling-transaction-fingerprintsnpx skills add cockroachdb/claude-plugin --skill profiling-transaction-fingerprints -a claude-code -gnpx skills add cockroachdb/claude-plugin --skill profiling-transaction-fingerprints -a codex -ggemini skills install https://github.com/cockroachdb/claude-plugin.git --path skills/cockroachdb-observability-and-diagnostics/profiling-transaction-fingerprintsgh skill install cockroachdb/claude-plugin profiling-transaction-fingerprintsgit clone --depth 1 https://github.com/cockroachdb/claude-plugin /tmp/cockroachdb__claude-plugin
mkdir -p ~/.claude/skills ~/.agents/skills
cp -R /tmp/cockroachdb__claude-plugin/skills/cockroachdb-observability-and-diagnostics/profiling-transaction-fingerprints ~/.claude/skills/profiling-transaction-fingerprints # Claude Code
cp -R /tmp/cockroachdb__claude-plugin/skills/cockroachdb-observability-and-diagnostics/profiling-transaction-fingerprints ~/.agents/skills/profiling-transaction-fingerprints # Codex, Cursor, Gemini CLI, Copilot, OpenCode