auditing-table-statistics
OfficialAudit table statistics for accurate query plans.
Authorcockroachlabs
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Audits optimizer table statistics to detect staleness, missing coverage, and data quality issues, helping diagnose poor query performance and plan changes. This skill surfaces when statistics are outdated or incomplete and guides remediation with targeted CREATE STATISTICS commands.
Core Features & Use Cases
- Detects stale table statistics and missing column histograms to improve cardinality estimates.
- Highlights drift between actual row counts and cached statistics, enabling targeted refresh.
- Provides workflows for post-bulk-load validation, performance triage, and routine health checks.
- Generates ready-to-run remediation commands (CREATE STATISTICS) and monitors auto-collection status.
Quick Start
Run a statistics audit on target tables to surface stale or missing statistics and refresh them with CREATE STATISTICS as needed.
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: auditing-table-statistics Download link: https://github.com/cockroachlabs/cockroachdb-skills/archive/main.zip#auditing-table-statistics 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.