skills.rest
Design-System-ET
Design-System-ETOFFICIAL
Explore all skills by this author →
GitHub

postgres-pro

Analyze PostgreSQL execution plans and optimize indexing strategies.

Updated Jun 16, 2026
Search Tags:#performance#indexing#database#postgresql#optimization#sql#vacuum
One-click install
npx skills add https://github.com/Design-System-ET/genexus-dev-opencode --skill postgres-pro-design-system-et
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/Design-System-ET/genexus-dev-opencode/tree/main/skills/postgres-pro
Command: npx skills add https://github.com/Design-System-ET/genexus-dev-opencode --skill postgres-pro-design-system-et

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill addresses database performance bottlenecks, inefficient query execution, and maintenance overhead by providing expert-level guidance on PostgreSQL tuning and administration.

Core Features & Use Cases

  • Performance Analysis: Deep-dive into query execution plans using EXPLAIN ANALYZE to identify and resolve slow operations.
  • Advanced Maintenance: Automates the management of VACUUM, index bloat, and statistics to ensure long-term database stability.
  • Feature Implementation: Provides ready-to-use patterns for JSONB indexing, replication setup, and advanced extensions like PostGIS or pgvector.

Quick Start

Invoke the postgres-pro skill to analyze the slow query execution plan for the orders table and suggest an optimized indexing strategy.

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 execution plans?▼

PostgreSQL performance optimization involves using EXPLAIN ANALYZE to identify slow operations in the execution plan and applying a targeted indexing strategy to resolve query bottlenecks.

What's the best way to automate PostgreSQL maintenance and reduce index bloat?▼

The best way to reduce index bloat in PostgreSQL is to automate advanced maintenance routines, specifically managing VACUUM and statistics, to ensure long-term database stability and performance.

How does PostgreSQL handle JSONB indexing for high-load production environments?▼

PostgreSQL handles JSONB indexing in high-load production environments by providing ready-to-use implementation patterns that ensure efficient querying and storage of JSONB spatial data.

Can I use PostgreSQL for replication management and spatial data with PostGIS?▼

Yes, you can use PostgreSQL for replication management and spatial data by implementing advanced extensions like PostGIS, utilizing provided patterns for setup and spatial data handling.

When do I need to tune PostgreSQL vacuum routines for database health monitoring?▼

You need to tune PostgreSQL vacuum routines when addressing maintenance overhead and database health monitoring, ensuring bloat reduction and long-term stability in high-load production contexts.

Related Skills

Explore More Software Engineering Skills→
GDSDNGDSDN
3

db-explain

Analyze PostgreSQL query plans with EXPLAIN ANALYZE to identify bottlenecks.

Community
Advanced
jcastillotxjcastillotx

mariadb-best-practices

Standardize MariaDB queries, security, and schema design across deployments and Galera clusters.

Community
Basic
incidentfoxincidentfox
654

jaeger-analysis

Analyze Jaeger traces to identify latency issues and errors across services.

Official
Intermediate
chef0111chef0111
1

databases

Manage MongoDB and PostgreSQL databases with schema design, CRUD, indexing, and migrations.

Community
Advanced