Optimize PostgreSQL 17/18+ performance by tuning async I/O and analyzing query plans.
npx skills add https://github.com/oakoss/agent-skills --skill postgres-tuning
Please help me install this Agent Skill. Skill: postgres-tuning Source: https://github.com/oakoss/agent-skills/tree/main/skills/postgres-tuning Command: npx skills add https://github.com/oakoss/agent-skills --skill postgres-tuning
This Skill addresses slow query performance and inefficient database operations in PostgreSQL, helping you diagnose and resolve bottlenecks related to I/O, indexing, and configuration.
pg_stat_io and pg_stat_statements for in-depth analysis.Use the postgres-tuning skill to analyze slow queries and suggest index optimizations.
High-intent search queries and answers about installing and using this skill.
To analyze slow PostgreSQL queries, use EXPLAIN BUFFERS to review query plans and identify missing indexes. This approach diagnoses I/O bottlenecks and refines index strategies to improve overall database throughput.
The best way to resolve PostgreSQL I/O bottlenecks and database bloat is by tuning async I/O and managing autovacuum. Utilizing advanced monitoring views like pg_stat_io helps pinpoint inefficiencies and reduce latency.
This performance tuning approach specifically targets PostgreSQL 17 and 18+ versions. It leverages newer monitoring views like pg_stat_io and async I/O configuration parameters not available in older database releases.
pg_stat_statements aids PostgreSQL database optimization by providing in-depth analysis of query execution statistics. Combined with pg_stat_io, it helps diagnose inefficient database operations, slow queries, and configuration bottlenecks.
You should tune autovacuum to fix slow PostgreSQL query performance when experiencing database bloat and inefficient operations. Adjusting autovacuum configurations resolves maintenance bottlenecks and restores query execution speed.
rabbicseOptimize slow PostgreSQL and MySQL queries with EXPLAIN ANALYZE validation.
HieubkavAnalyze database indexes and query execution plans to recommend optimizations.
InteligentsensingsolutionsOptimize PostgreSQL performance with EXPLAIN ANALYZE, indexing, and connection pooling guidance.
JeffallanDiagnose slow queries and optimize indexes for PostgreSQL and MySQL.