Additional Users
Create additional database users via dashboard or flyctl.
Attach apps
Attach a Fly.io app to the database, setting a connection URL secret and redeploying.
Cache Hit Ratio
Percentage of data requests served from memory versus disk.
Community Forum
Could you use more help?
Database Filtering
Optionally filter metrics by a specific database using the database dropdown.
DATABASE_URL secret
fly mpg attach sets a DATABASE_URL secret on your app automatically.
Default enabled extensions
plpgsql, pg_stat_monitor, and pgaudit are enabled by default and cannot be disabled.
Direct database URL
Use DIRECT_DATABASE_URL for migrations and session-scoped operations.
Explore Fly.io by features
Fly.io developer documentation
Get answers in your language
How does Fly.io work?
Metrics Dashboard
Real-time charts and gauges for system resources, connections, operations, storage, and replication.
Multi-schema and multi-database imports
Multi-schema and multi-database imports are supported.
Multiple databases and schemas
Multiple databases and schemas on a single cluster.
PGBouncer Pool Modes
Session and Transaction pool modes for PGBouncer connection pooling.
Vector (pgvector)
Third-party pgvector extension supported and enabled from the Extensions page.
PGVector extension
Optional third-party extension; currently only PGVector is supported.
Plan Changes
Change cluster plan at any time; machines update to new resources.
Pooled and direct URLs
Pooled URL via PgBouncer for apps; direct URL for migrations and LISTEN/NOTIFY.
PostGIS
Third-party PostGIS extension, enableable at cluster creation or from the Extensions page.
PostGIS extension
Third party PostGIS extension for geospatial data, if enabled at provisioning.
Proxy connection
fly mpg proxy forwards a local port to the remote database.
Connect with psql
fly mpg connect opens a direct psql session to the database.
Reader Role
Read-only access to all data in the cluster.
Ready to get started?
Replication Delay Metrics
Replication delay in bytes of WAL data and in seconds behind the primary.
Schema Admin Role
Full read/write access plus ability to modify database structure.
Support
Time Range Filtering
Select time ranges of 15 minutes, 1 hour, 6 hours, 24 hours, or 2 days.
Writer Role
Full read/write access to data without schema modification.