PostgreSQL query & performance tuning — reading EXPLAIN / EXPLAIN ANALYZE plans, choosing and designing indexes, fixing planner row-estimate errors with statistics, and diagnosing MVCC bloat / VACUUM. Use when a query is slow, when reading an EXPLAIN/EXPLAIN ANALYZE plan (seq vs index vs bitmap scan, nested-loop/hash/merge join, "Rows Removed by Filter", estimate-vs-actual skew), when choosing an index type or columns to index (btree/GIN/GiST/SP-GiST/BRIN/hash, multicolumn/partial/expression/covering), when ANALYZE/extended statistics give bad estimates, when tables bloat or autovacuum lags, or when tuning planner GUCs (random_page_cost, work_mem, effective_cache_size, enable_*). This is performance tuning — for the psql client see psql, for writing SQL/DDL see postgres-sql, for server config/replication & autovacuum GUC tuning see postgres-admin, for installing perf extensions (pg_stat_statements, auto_explain) see postgres-extensions. Newer features are tagged inline (pgNN+); PG18 is stable, PG19 is beta.
How to install postgres-performance?
dashed/claude-marketplace/postgres-performance
$npx -y skills add dashed/claude-marketplace --skill postgres-performanceInstalls into the current project.
›Prefer a prompt? Paste this to your agent
Run `npx skills use "https://github.com/dashed/claude-marketplace" --skill "dashed/claude-marketplace/postgres-performance"` and follow the generated skill instructions now. Read its complete output, redirecting it to a temporary file first if necessary. Resolve relative paths from the supporting-files directory it provides.
Use the skills in "https://github.com/dashed/claude-marketplace" that are relevant to the current task. Run `npx skills add "https://github.com/dashed/claude-marketplace"` and select the relevant skills, then follow their instructions.
Related
6 picksType
- supabase-postgres-best-practicesPostgres performance optimization and best practices from Supabase.Jul 2026
- firebase-data-connect-basicsBuilds and deploys Firebase SQL Connect (aka Firebase Data Connect) backends with PostgreSQL securely.Jul 2026
- firebase-firestoreSets up, manages, queries, and configures Cloud Firestore databases (Standard/Enterprise edition), including data modeling, security rules, indexes, and SDK…Jul 2026
- prisma-database-setupGuides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.).Jul 2026
- prisma-client-apiPrisma Client API reference covering model queries, filters, operators, and client methods.Jul 2026
- prisma-cliPrisma ORM CLI commands reference covering init, generate, migrate, db, dev, studio, validate, format, debug, and mcp.Jul 2026
