Menü
Diagnose a slow Postgres query and add the right index using EXPLAIN ANALYZE.
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
Basierend auf der SOC-Berufsklassifikation
Find the commit that introduced a regression automatically with git bisect run.
Configure Jest for a TypeScript project — ts-jest, module mapping, and coverage thresholds.
Test React components with Testing Library — render, query by role, and assert on user-visible behavior.
Fix TypeScript ES module import errors by adding .js extensions to relative imports.
Migrate a Jest test suite to Vitest — config, globals, and mock API differences.
Comprehensive guide for creating high-quality skills for Claude. Use when building a new skill, writing a SKILL.md, designing skill frontmatter, planning skill structure, debugging trigger issues, or reviewing an existing skill for improvements. Covers standalone skills, MCP-enhanced skills, and skill-tree programmatic skills.
| name | postgres-index-tuning |
| description | Diagnose a slow Postgres query and add the right index using EXPLAIN ANALYZE. |
| version | 1.0.0 |
| tags | ["postgres","database","performance"] |
| status | active |
EXPLAIN (ANALYZE, BUFFERS) on the slow query; look for Seq Scan on large tables.CREATE INDEX CONCURRENTLY in production to avoid locks).EXPLAIN ANALYZE and confirm the planner switched to an Index Scan.pg_stat_user_indexes — they only slow writes.