Setting Up Database Monitoring for Supabase Cloud
Database Monitoring for Supabase Cloud provides visibility into your Supabase databases by exposing query performance metrics and query samples — without requiring a self-hosted Datadog Agent.
Prerequisites
- A Supabase project with a Postgres database.
- Your Supabase Project ID (found in your Supabase project settings).
- Your Supabase API key (found in your Supabase project settings under API).
- A Supabase Personal Access Token with access to the Management API.
Setup
- Navigate to the Supabase integration tile in Datadog.
- Click Add Account.
- Enter your Supabase Project ID and API Key.
- Select Enable Database Monitoring for query performance optimizations.
- Enter your Personal Access Token.
- Click Save.
Datadog connects to your Supabase project and begins collecting Database Monitoring telemetry. No Agent installation is required.
Each Supabase project must be configured separately. Adding new projects to a connected Supabase account does not automatically enable Database Monitoring.
Data collected
After you enable Database Monitoring, Datadog collects the following telemetry from your Supabase Cloud database:
Sourced from pg_stat_statements, collected every 5 seconds:
- Call count and rows processed
- Total and average execution time
- Shared and local buffer hit/read/dirty/write statistics
- Block I/O read and write time
- Temporary buffer read and write counts
Query samples
Sourced from pg_stat_activity, collected every 5 seconds:
- Active and idle query snapshots
- Obfuscated query text and query signatures
- Wait event types and event names
- Session state and backend type
- Blocking PIDs
- Connection aggregates grouped by application, state, user, and database
Collected every 5 minutes:
- PostgreSQL version
- Instance identifier and hostname
- Connection mode (direct or pooler)
Validate
After setup, navigate to the Database Monitoring page in Datadog to see your Supabase database queries and performance metrics.
Further reading
Additional helpful documentation, links, and articles: