supabase-observability

# Supabase Observability ## Overview Monitor Supabase projects end-to-end: Dashboard reports for API/database/auth metrics, `supabase inspect db` CLI for deep Postgres diagnostics, `pg_stat_statements` for query analytics, log drains for external aggregation, Edge Functions for custom metrics, and alerting on quota thresholds. ## Prerequisites - Supabase CLI installed (`npx supabase --version`) - Supabase project linked (`supabase link --project-ref <ref>`) - Pro plan or higher for log drain support and extended log retention - `@supabase/supabase-js` v2+ installed for application-level monitoring ## Instructions ### Step 1: Dashboard Reports and CLI Inspect Commands Supabase Dashboard provides built-in reports under **Dashboard > Reports**: | Report | What It Shows | |--------|---------------| | API Requests | Total requests, response times, error rates by endpoint | | Database | Active connections, query counts, replication lag | | Auth Usage | Signups, logins, provider breakdown, failed attempts | | Storage | Bandwidth, object counts, bucket usage | | Realtime | Active connections, messages per second, channel counts | For deeper Postgres diagnostics, use the CLI inspect commands: ```bash # Table sizes — find the largest tables npx supabase inspect db table-sizes --linked # Index usage — find unused indexes wasting space npx supabase inspect db index-usage --linked # Cache hit ratio — should be > 99% (below 95% means upgrade compute) npx supabase inspect db cache...