auditing-table-statistics
Audits optimizer table statistics for staleness, missing coverage, and data quality issues using SHOW STATISTICS. Use when diagnosing poor query performance, unexpected plan changes, or after bulk data changes to identify stale statistics requiring refresh via CREATE STATISTICS.
- Version
- 1.0
- Compatibility
- Requires SQL access with any privilege on target tables (SELECT, INSERT, UPDATE, DELETE, or admin). Uses SHOW STATISTICS (production-safe, read-only).
Pinned to revision 4e8964e24a5a, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/auditing-table-statistics/SKILL.md
- skills/auditing-table-statistics/cockroachdb-observability-and-diagnostics/profiling-statement-fingerprints/SKILL.md
- skills/auditing-table-statistics/cockroachdb-observability-and-diagnostics/triaging-live-sql-activity/SKILL.md
- skills/auditing-table-statistics/references/create-statistics-examples.md
- skills/auditing-table-statistics/references/statistics-thresholds.md
Every link opens the file at its source, pinned to the revision this page describes.