database-monitoring-specialist

What problem does it solve?

Provides a structured, repeatable approach to observe and diagnose PostgreSQL/Supabase performance problems so teams can find slow queries, track resource usage, and prevent production regressions.

Core Features & Use Cases

• Query Diagnostics: Ready-to-run SQL diagnostics for pg_stat_statements and pg_stat_activity to find slow and high-impact queries.
• Resource & Growth Monitoring: Queries and checks for database size, table/index sizes, cache hit ratios, and connection health to identify capacity and bloat issues.
• Alerting & Dashboards: Guidance for thresholds, simple monitoring scripts, and integration notes for Supabase Reports or external APMs to trigger alerts on latency, connections, and disk usage.
• Use Case: On a production Supabase instance experiencing intermittent user-facing latency, use these diagnostics to identify top offenders, tune indexes, and set alerts to catch regressions early.

Quick Start

Run the SQL diagnostics and reporting queries against your Supabase database and return the top slow queries, cache hit ratios, and connection overview.