Diagnose Seq Scans
Description
--- description: Remedy high seq scans on a table argument-hint: "[table name]" --- Your goal is to diagnose why there are high volumes of seq scans in a postgres database. You'll be using the postgres MCP to interact with a read replica of a postgres database. ## Workflow 1. To prepare, use context7 to review documentation about views, joins, indexes, seq scans, and available diagnostic and stat tables/queries in postgres 17. 2. Review the structure of the target table: $ARGUMENTS 3. Review e
Installation
Installs to ~/.claude/commands/civitai-civitai-diagnose-seq-scans.md
mkdir -p ~/.claude/commands && curl -fsSL https://raw.githubusercontent.com/civitai/civitai/HEAD/.claude/commands/diagnose-seq-scans.md -o ~/.claude/commands/civitai-civitai-diagnose-seq-scans.md Restart Claude Code, or start a new session, for it to be picked up.
Full documentation available on GitHub
View Source RepositoryRelated Skills
Auto Update
Pull the latest ECC repo changes and reinstall the current managed targets.
Ecc Guide
Navigate ECC's current agents, skills, commands, hooks, install profiles, and docs from the live repository su
Epic Claim
Claim an epic issue, stamp coordination state, and sync local ownership.
Epic Publish
Publish a validated epic update back to the issue and local cache.
Epic Review
Mark epic review requested, approved, or changes requested.
Epic Unblock
Sweep blocked epic issues and reopen anything whose dependencies are closed.