skills.rest
resultakak
resultakakCOMMUNITY
Explore all skills by this author →
Website𝕏@resultakakGitHub

postgres-performance

Diagnose PostgreSQL performance issues using pg_stat_statements and EXPLAIN ANALYZE.

Updated May 11, 2026
Search Tags:#performance#monitoring#indexing#postgresql#query-analysis#explain-analyze#locking
One-click install
npx skills add https://github.com/resultakak/argos --skill postgres-performance-resultakak
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-performance
Source: https://github.com/resultakak/argos/tree/main/skills/postgres-performance
Command: npx skills add https://github.com/resultakak/argos --skill postgres-performance-resultakak

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL performance bottlenecks across slow queries, missing or misused indexes, locking, connection saturation, and migration risk.

Core Features & Use Cases

  • Query analysis: identify slow queries, long-running plans, and parameterization issues.
  • Index assessment: surface unused indexes, missing indexes, and suggest optimizations (partial/expression indexes).
  • Locking and connections: detect blockers, deadlocks, and high connection counts with remediation guidance.
  • Migration safety: validate changes before prod deployment and minimize lock impact.

Quick Start

Run a diagnostic pass against your Postgres instance to collect performance signals and recommended fixes.

Frequently Asked Questions about postgres-performance

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

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

Diagnose slow PostgreSQL queries by running EXPLAIN ANALYZE to verify execution plans and identify long-running operations, parameterization issues, and p99 latency bottlenecks.

Why does PostgreSQL locking cause connection saturation and how can I detect it?▼

PostgreSQL locking causes connection saturation when blockers and deadlocks stall active sessions. Detect them by querying pg_locks and pg_stat_activity to surface high connection counts and apply remediation guidance.

What's the best way to find missing indexes and unused indexes in PostgreSQL?▼

Find missing and unused PostgreSQL indexes by assessing pg_stat_user_indexes to surface index gaps and suggest optimizations like partial or expression indexes for improved query performance.

Do I need pg_stat_statements to monitor PostgreSQL performance issues?▼

Yes, pg_stat_statements is required to collect performance signals and identify slow queries, CPU saturation, and IO bottlenecks during a diagnostic pass against your PostgreSQL instance.

Can I validate PostgreSQL migration safety and lock impact in pre-deployment reviews?▼

Validate PostgreSQL migration safety in pre-deployment reviews by analyzing changes to minimize lock impact, verify plan stability with EXPLAIN ANALYZE, and reduce upgrade risk before production deployment.

What does pg_stat_activity show about PostgreSQL connection saturation?▼

pg_stat_activity shows active session states and long-running queries, allowing you to detect connection saturation, identify blocking queries, and generate evidence-backed remediation recommendations.

Related Skills

Explore More Software Engineering Skills→
Camilo8902Camilo8902

db-performance-watchlist

Monitor PostgreSQL performance via pg_stat_statements and pg_stat_activity.

Community
Advanced
enigmaicon-engenigmaicon-eng
1

database-optimizer

Analyze EXPLAIN execution plans to identify and validate PostgreSQL and MySQL database bottlenecks.

Community
Advanced
3balljugglerYu3balljugglerYu

supabase-postgres-best-practices

Optimize PostgreSQL query efficiency, schema design, and connection management in Supabase.

Community
Intermediate
jeremylongshorejeremylongshore
2.6k

monitoring-database-health

Monitor PostgreSQL and MySQL database health with real-time metrics and alerts.

Community
Advanced