skills.rest
alsmadi99
alsmadi99COMMUNITY
Explore all skills by this author →
WebsiteGitHub

postgres-pro

Guide PostgreSQL performance tuning through EXPLAIN ANALYZE and pg_stat monitoring workflows.

Updated Jun 9, 2026
Search Tags:#performance#monitoring#postgresql#replication#extensions#explain-analyze#vacuum
One-click install
npx skills add https://github.com/alsmadi99/dotfiles --skill postgres-pro-alsmadi99
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/alsmadi99/dotfiles/tree/main/claude/skills/postgres-pro
Command: npx skills add https://github.com/alsmadi99/dotfiles --skill postgres-pro-alsmadi99

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

PostgreSQL performance, replication configuration, and advanced feature management can be complex and error-prone; this skill consolidates best practices, workflows, and reference guidance to streamline tuning, monitoring, and maintenance.

Core Features & Use Cases

  • Performance optimization: explain analyze, indexing strategies, and query tuning.
  • Replication and high availability: streaming and logical replication setup and monitoring.
  • Maintenance and extensions: VACUUM tuning, pg_stat_statements usage, and extensions management.

Quick Start

Analyze a representative slow query and apply tuning steps to achieve measurable improvements.

Frequently Asked Questions about postgres-pro

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

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

To optimize slow PostgreSQL queries, use EXPLAIN ANALYZE to identify execution bottlenecks, then apply indexing strategies and query tuning workflows to achieve measurable performance improvements in production databases.

What is the best way to configure PostgreSQL streaming and logical replication?▼

Configuring PostgreSQL replication involves setting up streaming and logical replication workflows, then applying continuous monitoring to ensure high availability and reliable data synchronization across production database environments.

How do I tune PostgreSQL VACUUM maintenance for production databases?▼

Tuning PostgreSQL VACUUM requires adjusting maintenance settings based on pg_stat monitoring data, ensuring efficient dead tuple cleanup and preventing bloat in high-volume production database environments.

When do I need pg_stat_statements for PostgreSQL performance monitoring?▼

You need pg_stat_statements for PostgreSQL performance monitoring when tracking query execution statistics to identify slow queries, analyze workload patterns, and guide structured tuning across production database instances.

Can I use JSONB operations to improve PostgreSQL query performance?▼

JSONB operations in PostgreSQL require specific indexing strategies like GIN indexes to improve query performance, ensuring efficient data retrieval when analyzing and tuning complex document-based database workloads.

What are the limitations of PostgreSQL extensions management in production?▼

PostgreSQL extensions management requires careful compatibility checks and version control to avoid conflicts, ensuring stable performance when deploying pg_stat_statements and other monitoring tools across production database environments.

Related Skills

Explore More Software Engineering Skills→
duwscanduwscan

postgres-pro

Analyze PostgreSQL query execution plans and design indexes.

Community
Advanced
EstomEstom

postgres-pro

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

Community
Advanced
dabblersportdabblersport

supabase-postgres-best-practices

Optimize PostgreSQL query execution, connection pooling, and schema architecture.

Community
Advanced
gemini-cli-extensionsgemini-cli-extensions
42

cloud-sql-postgres-health

Audit Cloud SQL for PostgreSQL instance health and performance bottlenecks.

Official
Intermediate