skills.rest
dieu-donnee
dieu-donneeCOMMUNITY
Explore all skills by this author →
GitHub

postgres-pro

Identify and optimize slow PostgreSQL queries using EXPLAIN ANALYZE and VACUUM tuning.

Updated Jan 9, 2026
Search Tags:#performance#database#postgresql#replication#extensions#jsonb#explain-analyze
One-click install
npx skills add https://github.com/dieu-donnee/luxtrax --skill postgres-pro-dieu-donnee
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/dieu-donnee/luxtrax/tree/main/.agent/skills/postgres-pro
Command: npx skills add https://github.com/dieu-donnee/luxtrax --skill postgres-pro-dieu-donnee

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL performance and reliability require careful tuning of queries, replication, and maintenance; this Skill provides guidance to identify bottlenecks, apply advanced features, and keep databases healthy.

Core Features & Use Cases

  • Performance tuning for slow queries using EXPLAIN ANALYZE, indexing strategies, and VACUUM tuning to reduce bloat.
  • Replication setup and monitoring for data durability and failover readiness, including streaming and logical replication configurations.
  • Extensions and maintenance guidance for PostgreSQL tooling (such as pg_stat_statements, uuid-ossp, pg_trgm) and routine health checks.

Quick Start

Run EXPLAIN ANALYZE on a slow query and apply targeted indexing, JSONB optimization, and VACUUM tuning to see immediate 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, run EXPLAIN ANALYZE to identify bottlenecks, then apply targeted indexing strategies and JSONB optimization. This Skill analyzes query plans and recommends targeted indexing to improve performance and reduce execution latency.

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

PostgreSQL replication setup for data durability involves configuring streaming and logical replication. This Skill provides guidance on replication setup and monitoring to ensure failover readiness and maintain reliable data synchronization across deployments.

How does VACUUM tuning reduce table bloat in PostgreSQL?▼

VACUUM tuning reduces table bloat by optimizing routine maintenance operations in PostgreSQL. This Skill provides guidance on adjusting VACUUM settings and performing health checks to minimize bloat and keep your database storage healthy.

Can I use PostgreSQL extensions like pg_stat_statements and pg_trgm for performance monitoring?▼

Yes, PostgreSQL extensions like pg_stat_statements, pg_trgm, and uuid-ossp can be used for performance monitoring and tooling. This Skill offers maintenance guidance for managing these extensions and performing routine database health checks.

When do I need JSONB storage optimization in PostgreSQL?▼

JSONB storage optimization is required when querying large JSON datasets causes performance bottlenecks in PostgreSQL. This Skill identifies slow JSONB operations and applies advanced indexing strategies to improve query speed and storage efficiency.

Related Skills

Explore More Software Engineering Skills→
JeffallanJeffallan
10.9k

database-optimizer

Diagnose slow queries and optimize indexes for PostgreSQL and MySQL.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

managing-database-replication

Configure master-slave replication and automatic failover for PostgreSQL and MySQL deployments.

Community
Advanced
Axel-DaMageAxel-DaMage
2

postgres-pro

Analyze PostgreSQL EXPLAIN output and manage JSONB, replication, and VACUUM tasks.

Community
Advanced
Mentor-WizardMentor-Wizard
10

postgresql-optimization

Analyze PostgreSQL queries with EXPLAIN ANALYZE and tune indexes and configuration.

Official
Advanced