Tag: database-performance
PostgreSQL Slow Query Diagnosis
Provides a systematic workflow for diagnosing and optimising slow PostgreSQL queries by analysing execution plans, index opportunities, and table statistics. It utilises pgtuner-mcp tools to identify resource-intensive queries and recommend…
PostgreSQL I/O Performance Deep-Dive
A structured workflow for investigating PostgreSQL I/O performance, covering buffer pool efficiency, table and index hotspots, and checkpoint performance. It correlates I/O patterns with query workloads to diagnose disk bottlenecks and conf…
PostgreSQL Index Analysis and Optimization
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…
Convex Application Performance Audit
Diagnose and optimise Convex application performance by addressing read amplification, OCC conflicts, and subscription costs. The workflow provides structured auditing for hot-path reads, write contention, and function execution limits.