Monitor Platform-Wide Supabase Health and Usage Metrics
The Global Administrator requires a unified view of Supabase platform health covering: database query performance (slow queries, index utilization), API request volume and error rates, Realtime connection counts, Edge Function invocation rates and errors, and storage utilization. This monitoring is essential for a platform serving multiple organizations with potentially overlapping peak usage periods, and for detecting unusual access patterns that may indicate security incidents.
User Story
Acceptance Criteria
- Given multiple organizations are actively using the platform, when the admin views Supabase dashboard metrics, then aggregate and per-project usage statistics are visible
- Given a slow database query is occurring frequently, when the admin reviews the pg_stat_statements data, then the problematic query is identifiable with execution time and frequency
- Given API error rates spike above a threshold, when the admin checks request logs, then error types (400, 401, 403, 500) are broken down with request paths to identify the source
- Given database connection pool limits are being approached, when the admin reviews connection metrics, then current usage vs limits is visible with time-series history
- Given an Edge Function is failing repeatedly, when the admin checks function invocation logs, then error messages, stack traces, and affected organization contexts are accessible
Business Value
Platform monitoring enables proactive operations rather than reactive incident response. For a multi-organization SaaS platform, an undetected performance degradation in Supabase affects all organizations simultaneously. The global admin's pain point of 'no unified view of platform health across all member organizations' is directly addressed by platform-level observability, enabling the admin to detect and resolve issues before organizations report them.
Components
- Supabase Platform infrastructure
- Edge Functions infrastructure
- Real-time Subscription Service service