PostgreSQL Index Analysis and Optimization

Summary

This skill provides a comprehensive workflow for PostgreSQL index optimisation, including identifying unused or duplicate indexes, detecting bloat, and recommending new indexes. It leverages HypoPG for hypothetical index testing to estimate performance impact without production overhead.