SKILL47backend-data
Profiling PostgreSQL Query Performance
Diagnoses slow or uncertain PostgreSQL access paths from representative inputs and execution-plan evidence before changing indexes.
Primary benefit
Replaces index guesswork with measurable before-and-after evidence across plan shape, rows, buffers, and application access patterns.When to use
Use when a PostgreSQL query is slow, resource-heavy, regressed, or has uncertain index behavior and the cause needs to be measured before changing SQL, schema, or indexes.
When not to use
Do not use to pre-optimize unmeasured queries or to add speculative indexes before a concrete workload exists.
Use cases
Investigate a query latency regression with EXPLAIN evidence
Decide whether a composite or partial index matches a real access pattern
Example prompts
Use profiling-postgres-query-performance to diagnose this slow query from the plan before recommending any index.Install this skill
Choose the command for your operating system and run it from the repository root.
Bash
./install.sh --skill profiling-postgres-query-performancePowerShell
./install.ps1 --skill profiling-postgres-query-performanceChatGPT
Download Skill ZIPCompatibility
- Surfaces
- ChatGPT · Codex · Claude Code
- Operating systems
- Linux · macOS · Windows
- Install modes
- PluginFilesystem
Dependencies
Part of systems
Curated systems that canonically include this method.