Getting Started

Quickstart: First Database in 5 Minutes

Sign up, connect your PostgreSQL via the hosted collector, and see your first metrics in under 5 minutes.

MonPG hosted onboarding wizard — environment picker

Five minutes is realistic if your database is reachable from the public internet and you have admin credentials at hand. In practice the slow part isn't the wizard. It's finding which Parameter Group your RDS instance uses, or remembering which Azure subscription owns the Service Principal you'll need for log access later. Pin those down first.

Prerequisites

  • A PostgreSQL user that can run CREATE ROLE and CREATE EXTENSION pg_stat_statements. On managed PG this is the master user you set when you created the instance — postgres on RDS, the "server admin" on Azure Flex, postgres on Cloud SQL.
  • The database reachable over the public internet, or the willingness to run our agent inside your network.
  • Five minutes of focused time, plus a couple of minutes to find your Parameter Group / subscription / cluster identifiers.

We use the admin password once to provision a read-only role and then forget it. There's no place we store it. (Yes, really. The wrap key is in Azure Key Vault and the bootstrap path doesn't write the admin password anywhere.)

If your database is not on the public internet

If your DB lives behind a strict firewall and you don't want to open ingress to 20.107.185.112/29, the hosted flow won't work for you. Skip ahead to the agent setup page. The agent runs inside your network and pushes metrics to us over HTTPS; credentials never leave.

Provisioning the monitor role

  1. Go to app.monpg.app and click Sign Up.
  2. On the Setup screen, pick your provider. The flow that comes next adapts to what you picked but the shape is the same.
  3. Enter the host plus admin password.
  4. Click Test connection. We probe the cluster — provider detection, extension inventory, current GUC values, discovered databases, whether pg_stat_statements is actually preloaded.
  5. Review the consent surface. This screen tells you exactly what we'll do, what we won't (no GUC changes, no SPL changes, no restart), and the rollback script if you change your mind in two weeks. Read it before clicking Provision. We've put effort into making it specific rather than generic.
  6. Click Provision monitor role.

What happens after Provision

You're redirected to the dashboard. The first metric snapshot lands within about thirty seconds. The Queries page populates within a minute. Some pages stay blank longer because they need real data to work against:

  • Query Advisor — needs slow queries to capture.
  • Index Advisor — needs queries that would benefit from indexes.
  • VACUUM Advisor — needs pgstattuple for accurate bloat.

The first hour walkthrough covers exactly what to expect.

If something looks wrong

If a widget is blank or you see "Disconnected" in the header after a few minutes, the cause is almost always a missing security group rule. Jump to troubleshooting.