slow

What problem does it solve?

This Skill performs a thorough, read-only performance audit to find slow queries, N+1s, uncached heavy counts, log-indicated anti-patterns, and gaps in query-budget test coverage so teams can prioritize impactful fixes without modifying code.

Core Features & Use Cases

• Automated Diagnostics: Run the repository's performance rake task, parse logs, and surface top slow queries and sequential scans.
• Anti-pattern Detection: Scan controllers, views, and components for N+1 patterns, service/db calls in views, UUID casting issues, and problematic SET LOCAL usage.
• Cross-reference & Prioritization: Correlate findings with historical "SYSTEM SLOW" GitHub issues and the Bullet allowlist to identify recurring problems and provide prioritized remediation recommendations.

Quick Start

Request a read-only comprehensive performance audit that runs the rake performance:audit, scans code and logs for anti-patterns, cross-references SYSTEM SLOW issues, and returns a prioritized PERFORMANCE GUARDIAN REPORT.