skills.rest
Dbillionaer
DbillionaerCOMMUNITY
Explore all skills by this author →
GitHub

postgresql-optimization

Analyze slow SQL queries and recommend PostgreSQL indexes and configuration tuning.

1|1|Updated Feb 19, 2026
Search Tags:#indexing#database#postgresql#optimization#maintenance#sql#performance tuning
One-click install
npx skills add https://github.com/Dbillionaer/wholesaile --skill postgresql-optimization
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgresql-optimization
Source: https://github.com/Dbillionaer/wholesaile/tree/main/skills/postgresql-optimization
Command: npx skills add https://github.com/Dbillionaer/wholesaile --skill postgresql-optimization

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses performance bottlenecks in PostgreSQL databases by providing a structured workflow for query tuning, indexing, configuration, and maintenance.

Core Features & Use Cases

  • Query Optimization: Analyzes and rewrites slow SQL queries for improved execution speed.
  • Indexing Strategies: Identifies missing indexes and recommends optimal index types (B-tree, composite, partial).
  • Configuration Tuning: Adjusts key PostgreSQL parameters like shared_buffers, work_mem, and autovacuum for better resource utilization.
  • Maintenance & Monitoring: Schedules essential maintenance tasks like VACUUM and ANALYZE, and sets up monitoring dashboards.
  • Use Case: A web application experiences slow load times due to inefficient database queries. This Skill can be used to diagnose the slow queries, implement appropriate indexes, and tune the PostgreSQL configuration to significantly speed up response times.

Quick Start

Use the postgresql-optimization skill to assess PostgreSQL performance and identify slow queries.

Frequently Asked Questions about postgresql-optimization

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

FAQPage Schema
How do I optimize slow PostgreSQL queries in a web application?▼

PostgreSQL indexing strategies involve identifying missing indexes and recommending optimal index types like B-tree, composite, or partial indexes to accelerate query execution without increasing write overhead.

What PostgreSQL configuration parameters should I adjust for better performance?▼

PostgreSQL maintenance tasks require scheduling essential operations like VACUUM and ANALYZE to reclaim storage and update statistics, ensuring the query planner generates efficient execution paths.

What level of SQL expertise is needed for PostgreSQL performance tuning?▼

Yes, PostgreSQL configuration tuning can resolve resource utilization bottlenecks by adjusting memory allocation parameters like shared_buffers and work_mem, directly improving overall database throughput.

How do I set up monitoring and maintenance for a production PostgreSQL database?▼

Set up PostgreSQL monitoring by scheduling essential maintenance tasks like VACUUM and ANALYZE, and configuring monitoring dashboards to track performance metrics and prevent production degradation.

Related Skills

Explore More Software Engineering Skills→
GDSDNGDSDN
3

db-explain

Analyze PostgreSQL query plans with EXPLAIN ANALYZE to identify bottlenecks.

Community
Advanced
alsmadi99alsmadi99

postgres-pro

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

Community
Advanced
SamuelSahaSamuelSaha

PostgreSQL Mastery

Optimize PostgreSQL databases with query tuning, indexing, and replication strategies.

Community
Advanced
AratKruglikAratKruglik
150

postgresql-optimization

Optimize PostgreSQL queries, indexes, and configuration parameters.

Community
Advanced