skills.rest
rnavarych
rnavarychCOMMUNITY
Explore all skills by this author →
GitHub

postgres-deep

Analyzes PostgreSQL slow queries and recommends indexing and tuning strategies.

14|3|Updated Feb 22, 2026
Search Tags:#query optimization#indexing#postgresql#sql#performance tuning#pgbouncer
One-click install
npx skills add https://github.com/rnavarych/alpha-engineer --skill postgres-deep
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-deep
Source: https://github.com/rnavarych/alpha-engineer/tree/main/plugins/billy-milligan/skills/shared/postgres-deep
Command: npx skills add https://github.com/rnavarych/alpha-engineer --skill postgres-deep

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill helps you diagnose and resolve PostgreSQL performance bottlenecks, from slow queries to connection issues, ensuring your database runs efficiently.

Core Features & Use Cases

  • Query Optimization: Analyze EXPLAIN ANALYZE output and pg_stat_statements to identify and fix slow queries.
  • Indexing Strategies: Understand and implement optimal B-tree, GIN, GiST, and BRIN indexes, including partial and covering indexes.
  • Connection Pooling: Configure and monitor PgBouncer for efficient connection management.
  • Use Case: Your application's reporting dashboard is running slowly. Use this Skill to analyze the slowest queries, identify missing indexes, and tune your PostgreSQL configuration for faster data retrieval.

Quick Start

Use the postgres-deep skill to analyze the top 10 slowest queries in your database.

Frequently Asked Questions about postgres-deep

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow PostgreSQL queries using EXPLAIN ANALYZE?▼

Find slow PostgreSQL queries by querying the pg_stat_statements extension to track execution statistics. This Skill analyzes the top slowest queries to identify performance bottlenecks and apply optimization strategies for high-throughput workloads.

What's the best way to configure PgBouncer for PostgreSQL connection pooling?▼

Use partial and covering PostgreSQL indexes to optimize queries that filter on specific subsets of data or retrieve additional columns without table access. This Skill helps implement advanced indexing strategies to speed up data retrieval.

When should I use GIN, GiST, or BRIN indexes in PostgreSQL?▼

Diagnose PostgreSQL performance bottlenecks by analyzing EXPLAIN ANALYZE plans and pg_stat_statements data to locate slow queries. This Skill provides in-depth analysis to resolve connection issues and tune configurations for faster data retrieval.

How do I tune PostgreSQL performance for high-throughput OLTP workloads?▼

Tune PostgreSQL performance for high-throughput OLTP workloads by optimizing indexing strategies and configuring connection pooling with PgBouncer. This Skill addresses scenarios requiring performance tuning to ensure efficient database operations under heavy transaction loads.

Related Skills

Explore More Software Engineering Skills→
bobmatnycbobmatnyc
20

PostgreSQL Performance Optimization

Analyze PostgreSQL 15+ queries, indexes, and configuration using EXPLAIN ANALYZE.

Community
Advanced
lapc506lapc506
4

Database Reliability

Automate PostgreSQL replication, failover, pooling, and backup management.

Community
Advanced
Lautaro073Lautaro073

sql-optimization-patterns

Identify and optimize inefficient SQL queries across PostgreSQL and MySQL.

Community
Advanced
rnavarychrnavarych
14

role-database:newsql-distributed

Compare 12 NewSQL and distributed SQL databases for consistency and sharding.

Community
Advanced