skills.rest
duynhne
duynhneCOMMUNITY
Explore all skills by this author →
GitHub

postgres-expert

Analyze PostgreSQL slow queries with EXPLAIN ANALYZE and apply indexing strategies.

Updated Oct 17, 2025
Search Tags:#performance#indexing#postgresql#partitioning#replication#jsonb
One-click install
npx skills add https://github.com/duynhne/monitoring --skill postgres-expert-duynhne
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-expert
Source: https://github.com/duynhne/monitoring/tree/main/.agent/skills/postgres-expert
Command: npx skills add https://github.com/duynhne/monitoring --skill postgres-expert-duynhne

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL optimization and administration challenges hinder performance, reliability, and scalability in production databases.

Core Features & Use Cases

  • Query optimization: analyze slow queries with EXPLAIN ANALYZE, tune planner settings, and create effective indexes for complex schemas.
  • JSONB optimization: design and implement efficient indexing strategies for JSONB data, including path and expression indexes.
  • Partitioning & maintenance: implement partitioning, autovacuum tuning, and replication setup to handle growth and high-availability scenarios.
  • Use Case: A SaaS app with high-volume writes and JSON-heavy data can achieve consistent latency and simpler maintenance through advanced indexing, partitioning, and connection management.

Quick Start

Profile a slow query with EXPLAIN ANALYZE, then apply recommended indexing and autovacuum settings to improve performance.

Frequently Asked Questions about postgres-expert

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

FAQPage Schema
How do I optimize slow PostgreSQL queries in a complex production deployment?▼

Optimize slow PostgreSQL queries by profiling them with EXPLAIN ANALYZE, tuning planner settings, and creating effective indexes for complex schemas to resolve performance bottlenecks.

What is the best way to index JSONB data for high-volume write applications?▼

Index JSONB data efficiently by designing and implementing path and expression indexes to maintain consistent latency for high-volume write applications.

How do I set up PostgreSQL partitioning and replication for high availability?▼

Implement PostgreSQL partitioning and configure replication to handle database growth and manage high-availability scenarios across production systems.

When do I need to tune autovacuum settings for PostgreSQL maintenance?▼

Tune autovacuum settings when managing PostgreSQL growth and ensuring reliable maintenance, particularly in complex production deployments requiring best-practice configuration and monitoring.

Does this approach support connection management for scalable SaaS applications?▼

Yes, applying targeted connection management strategies across production systems supports scalable SaaS applications by achieving consistent latency and simpler maintenance.

Related Skills

Explore More Software Engineering Skills→
HieubkavHieubkav

database-performance

Analyze database indexes and query execution plans to recommend optimizations.

Community
Advanced
EstomEstom

postgres-pro

Optimize PostgreSQL queries, replication, and maintenance with EXPLAIN ANALYZE.

Community
Advanced
arbazkhan971arbazkhan971
26

postgres

Optimize PostgreSQL production performance with tuning, indexing, and replication guidance.

Community
Advanced
hotriluanhotriluan
3

databases

Design, query, and administer MongoDB and PostgreSQL databases.

Community
Intermediate