profiling-transaction-fingerprints
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. Use when investigating transaction retry storms, analyzing commit latency trends, or understanding statement composition of problematic transactions without DB Console access.
- Version
- 1.0
- Compatibility
- Requires SQL access with VIEWACTIVITY or VIEWACTIVITYREDACTED cluster privilege. Uses crdb_internal.transaction_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-transaction-fingerprints/SKILL.md
- skills/profiling-transaction-fingerprints/cockroachdb-observability-and-diagnostics/profiling-statement-fingerprints/SKILL.md
- skills/profiling-transaction-fingerprints/cockroachdb-observability-and-diagnostics/triaging-live-sql-activity/SKILL.md
- skills/profiling-transaction-fingerprints/cockroachdb-observability-and-diagnostics/triaging-live-sql-activity/references/permissions.md
- skills/profiling-transaction-fingerprints/references/json-field-reference.md
- skills/profiling-transaction-fingerprints/references/metrics-and-units.md
- skills/profiling-transaction-fingerprints/references/sql-query-variations.md
Every link opens the file at its source, pinned to the revision this page describes.