Which PostgreSQL versions are supported by this skill?

This skill is specifically optimized for PostgreSQL 16 and above to leverage modern performance features.

How does it handle sequential scans?

It identifies high-cost sequential scans through EXPLAIN analysis and recommends specific index types or query rewrites to resolve them.

Does it provide advice on server configuration?

Yes, the skill can suggest tuning parameters like shared_buffers and work_mem based on your specific performance metrics and hardware.

Are there any required extensions for this skill to work?

Yes, for full diagnostic capabilities including query history and statistics, the pg_stat_statements extension should be enabled.

Can this skill help with specialized data types like JSONB?

Yes, it includes patterns for advanced indexing such as GIN indexes with jsonb_path_ops for optimizing document-based queries.

PostgreSQL Performance Optimizer

Name: PostgreSQL Performance Optimizer
Author: pluginagentmarketplace

bypluginagentmarketplace

•

数据库管理

Optimizes PostgreSQL database performance through automated query analysis, advanced indexing strategies, and database configuration tuning.

The PostgreSQL Performance skill equips Claude with specialized expertise to diagnose and resolve complex database bottlenecks. It provides a systematic approach to interpreting EXPLAIN ANALYZE outputs, implementing high-performance indexing patterns like GIN and BRIN, and identifying system-level issues such as table bloat and cold caches. By leveraging diagnostic queries and industry-standard metrics, this skill helps developers reduce query latency and ensure production environments are running at peak efficiency.

主要功能

01Real-time diagnostic queries for slow logs and unused indexes

02Strategic index selection for B-tree, GIN, and BRIN types

03Automated table bloat detection and maintenance planning

04Deep query plan analysis using EXPLAIN (ANALYZE, BUFFERS)

05Database configuration tuning based on buffer hit and planning metrics

061 GitHub stars

使用场景

01Troubleshooting slow-running production queries to reduce execution time

02Optimizing storage and search for JSONB and time-series data sets

03Implementing proactive database maintenance and index cleanup

主要功能

01Real-time diagnostic queries for slow logs and unused indexes

02Strategic index selection for B-tree, GIN, and BRIN types

03Automated table bloat detection and maintenance planning

04Deep query plan analysis using EXPLAIN (ANALYZE, BUFFERS)

05Database configuration tuning based on buffer hit and planning metrics

061 GitHub stars

使用场景

01Troubleshooting slow-running production queries to reduce execution time

02Optimizing storage and search for JSONB and time-series data sets

03Implementing proactive database maintenance and index cleanup