MonPG Documentation

pg_stat_statements — The Foundation

Required for everything in MonPG. How it works, how to verify it's loaded, what we read from it.

Extensions Overview — What MonPG Uses and Why

The nine PostgreSQL extensions MonPG reads from, what each unlocks in the product, and which provider ships which.

Migration from pganalyze

Switch from pganalyze to MonPG without downtime — both can run in parallel during cutover.

Plans & Pricing

Free, Pro, Business, Enterprise — what each includes and how to upgrade.

Data Handling — What MonPG Stores

Exactly which data flows to MonPG and how it's stored.

Grafana — Custom Dashboards from MonPG Metrics

Pull MonPG's time-series API into Grafana via the Infinity datasource.

Troubleshooting Common Issues

Disconnected servers, blank pages, missing data — the usual suspects and how to fix them.

Dashboard — At-a-Glance Overview

The one-page fleet summary. Active alerts, connection pressure, slowest queries, top size consumers.

Quickstart: First Database in 5 Minutes

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

Creating Alert Rules

Threshold, pattern, query-metric, and custom SQL rules — when to use each.

API Overview

REST API for programmatic access to MonPG data. All endpoints require an API key.

Self-Hosted Agent — Docker

Run the MonPG collector in Docker so credentials never leave your network.

Recommended GUC Settings

The baseline PostgreSQL configuration MonPG recommends and how to apply it on each provider.

Metrics — Time-Series Detail

Drill into any metric over any time range with full chart controls.

pgstattuple — Bloat Metrics

Install pgstattuple to light up table/index bloat percentages on the Tables and Indexes pages.

Troubleshooting AWS RDS

RDS-specific issues: Parameter Group changes not applying, CloudWatch IAM, security groups.

Users & Team Management

Invite teammates, assign roles, transfer ownership.

OpenTelemetry — Export MonPG Metrics as OTLP

Push MonPG's metrics into your existing observability stack (Honeycomb, Lightstep, etc.).

Invoices & Payment

Download invoices, change payment method, handle failed charges.

SOC 2 & Compliance Posture

Audits, certifications, sub-processors, breach notification.

Migration from Datadog DBM

Replace Datadog Database Monitoring with MonPG. Cost savings + better PG-specific tooling.

Self-Hosted Agent — Kubernetes (Helm)

Deploy the MonPG collector as a Deployment with a Helm chart.

Notification Channels — Slack, Email, PagerDuty, Webhooks

Wire alerts to where your team already pays attention.

API Authentication & Keys

Generate API keys, scope them, rotate them, revoke them.

Queries — Find What’s Slow or Eating I/O

The Queries page is how you find performance outliers. Columns explained + filtering tips.

Adding Additional Databases

Add a second or third database to MonPG without re-provisioning — covering multi-DB fan-out and RDS clusters.

Compare — Period-over-Period Query Diff

Diff this hour vs. previous hour, today vs. yesterday — find what regressed.

Troubleshooting Azure Flexible Server

Azure-specific issues: server parameter changes, azure.extensions allowlist, Event Hub Listen permission.

Organization Settings

Display name, default timezone, retention overrides, data export.

Self-Hosted Agent — systemd (Bare Metal / VM)

Run the collector as a systemd service on Ubuntu / Debian / RHEL / Rocky.

Data Residency & Encryption

Where your data lives geographically + how it's encrypted in flight and at rest.

Hosted vs. Self-Hosted Agent — Which to Choose

When to use MonPG's hosted collector vs. running the agent in your own infrastructure.

hypopg — Hypothetical Indexes

Install hypopg to let Index Advisor simulate indexes without creating them — true "would this help?" answers.

Migration from New Relic Infrastructure (Postgres integration)

Replace NR Postgres integration. Less generic, more PG-aware.

External Watchdog — Verify MonPG Itself

Quis custodiet ipsos custodes? Cron a check that ensures MonPG is collecting.

Query Advisor — Understand Slow Queries

How Query Advisor parses captured plans and what the bottleneck labels mean.

Stripe Customer Portal — Self-Serve Billing

Change plan, update card, download past invoices — all from Stripe's hosted portal.

Servers Endpoint

List, get, and manage monitored servers programmatically.

Databases Endpoint

List databases per server, toggle monitoring, get per-DB stats.

Troubleshooting Google Cloud SQL

Cloud SQL-specific issues: cloudsql.* flags, IAM service account, private IP.

Notification Channels Deep Dive

Per-channel formatting, delivery quirks, escalation patterns.

Self-Hosted Agent — Binary Install

Drop the collector binary on a host without Docker / systemd / Kubernetes.

Backup & Recovery (MonPG’s own)

How MonPG itself backs up your data + RTO / RPO commitments.

What to Expect in the First Hour

Why some pages are blank at first, when data lights up, and what initial interpretation to trust.

Index Advisor — Find Missing and Unused Indexes

Proposes indexes for queries that need them, flags indexes that aren't being used.

Alerts Endpoint

Query firing alerts, acknowledge, resolve — integrate with your incident response tooling.

pg_buffercache — Cache-Pressure Analysis

Install pg_buffercache to inspect shared_buffers — which relations are hot, how much is dirty, and when to size up.

Add a Database — AWS RDS for PostgreSQL

Step-by-step: connect an Amazon RDS PostgreSQL instance to MonPG, including security group + Parameter Group setup.

Self-Hosted Agent — Air-Gapped Install

Run the collector with no internet access — push metrics over your VPN to a MonPG bastion.

Troubleshooting Self-Hosted

Self-managed PostgreSQL issues: shared_preload_libraries, pg_hba.conf, helper function grants.

Per-Server Settings & Overrides

Override org defaults for one server: collection interval, retention, alert mute windows.

VACUUM Advisor — Bloat, Autovacuum Lag, Freeze Age

Find bloated tables, tune autovacuum per-table, and catch XID wraparound before it bites.

Metrics Endpoint

Time-series metric queries — shape your own dashboards in Grafana, Looker, or Excel.

pgaudit — Statement-Level Audit Logging

Enable pgaudit to send compliance-grade audit logs to MonPG Log Insights.

Log Insights Endpoint

Query log entries by category, severity, time window. Subscribe to log patterns.

Add a Database — AWS Aurora PostgreSQL

Aurora has a writer + readers; here's how to monitor each properly without double-counting metrics.

API Keys

Generate, scope, rotate, and revoke API keys.

Add a Database — Azure Database for PostgreSQL Flexible Server

Step-by-step for Azure Flex: server-level firewall, azure_pg_admin role, and azure.extensions allowlist.

auto_explain — Automatic Slow-Query Plan Capture

Enable auto_explain to automatically capture EXPLAIN output for every slow query. Essential for Query Advisor.

Schema Statistics — Size and Growth per Table

Per-table size breakdown, growth trends, and TOAST / index ratios.

Webhooks

Subscribe to alert events and push them to your endpoint in real time.

Reports Endpoint

Trigger ad-hoc reports + download scheduled report PDFs.

Add a Database — Google Cloud SQL for PostgreSQL

Cloud SQL onboarding: authorized networks, postgres user, cloudsql.* flags for SPL extensions.

Add a Database — Heroku Postgres

Heroku-specific quirks: tier matters, no SPL access, allowlist is different.

Connections — Backend Activity and Pool Pressure

See who's connected, what they're running, and whether you're about to hit max_connections.

Organizations Endpoint

Read your organization's settings, members, plan limits.

pg_wait_sampling — Wait-Event Drill-Down

Install pg_wait_sampling for sampled wait-event histories on the Queries and Backends pages.

Backends — Connection Activity Detail

Per-backend drill-down with PID, query, wait events, connection start time.

PgBouncer — Pooler Stats

If you front PostgreSQL with PgBouncer, MonPG surfaces its admin console stats.

Add a Database — Crunchy Bridge

Crunchy gives you a real superuser — the most flexible managed PG for monitoring purposes.

Sequences — Wraparound Risk & Ownership

Find sequences nearing INT4 wraparound + sequences without an owning column (orphans).

pg_cron — Scheduled Jobs

Cron-style scheduler inside PostgreSQL. App-owned; MonPG reads job history if installed.

Locks — See Blocked Queries and Lock Waits

Find the blocker when a query hangs. Lock graph + wait event decoded.

Users Endpoint

Profile details, preferences, session info for the API key's user.

Add a Database — Aiven for PostgreSQL

Aiven onboarding: pg.* advanced parameters, aiven-gatekeeper extension constraints.

pgvector — Vector Similarity Search

Stores embeddings + nearest-neighbor index. App-owned; MonPG reads index health.

PostGIS — Geospatial Types & Indexes

Spatial types + GIST indexes. App-owned; MonPG monitors index size and bloat.

TimescaleDB — Time-Series Tables

Hypertables, continuous aggregates, compression. MonPG reads chunk health if installed.

pg_partman — Partition Management

Native PostgreSQL partition automation. MonPG monitors partition lag.

Backups — Backup History & PITR Health

Backup recency, WAL archiver status, point-in-time recovery window.

Add a Database — Self-Managed PostgreSQL

Bare metal / VM / container PostgreSQL: pg_hba.conf, manual monitor role creation, and (usually) agent mode.

Vector Database Monitoring Overview

How to monitor vector search systems in production: pgvector health, filtered recall, embedding churn, index size, latency, and source-of-truth sync.

System — Host-Level Metrics (CPU, RAM, Disk)

Cloud provider host metrics + buffer cache breakdown + filesystem usage.

pgvector Production Setup Checklist

A practical pgvector setup checklist covering schema design, HNSW indexes, metadata filters, query shape, maintenance, and rollout safety.

Configuration — Current GUC Values + Diff

Browse every GUC in your cluster, see what differs from default, what would benefit from tuning.

RAG Retrieval Quality Runbook

A production runbook for RAG retrieval quality: golden queries, recall checks, citation coverage, stale chunks, ACL filters, and no-hit behavior.

Agent Troubleshooting

Token errors, network failures, SSL issues, missing metrics — diagnostic walkthrough.

Replication — Lag, Slots, and Standby Health

Monitor streaming replicas, logical slots, and WAL backup pressure.

Dedicated Vector Store Sync Checklist

How to keep PostgreSQL as the source of truth while syncing documents, permissions, deletes, and embedding versions to a dedicated…

Annotations — Mark Deploys, Migrations, Incidents

Pin events on charts so you can correlate "what changed" with "when did it get worse".

Workbooks — Saved Query Collections + Notes

Curate queries you investigate often, attach notes, share with team.

Log Insights — Errors, Patterns, and Categorization

PostgreSQL log analysis: top error patterns, query error correlation, log-pattern alerts.

Log Insights on AWS RDS — CloudWatch IAM Setup

IAM role + permissions to let MonPG read your RDS instance logs from CloudWatch.

Log Insights on Azure Flex — Diagnostic Settings + Event Hub

Configure Azure Diagnostic Settings to stream PostgreSQL logs into MonPG via Event Hub.

Log Insights on Cloud SQL — Service Account + Logging Viewer

Grant a Google Cloud service account access to your instance's logs.

Log Insights on Self-Managed PostgreSQL

Tail your postgresql.log file via the collector — no external log pipeline needed.

Capacity — Growth Projections

Linear regression on storage, connections, query rate. Forecasts when you'll hit the next limit.

Reports — Scheduled PDFs and CSV Exports

Schedule weekly / monthly PDF summaries or export raw data for your own BI tool.

PostgreSQL Performance Triage Runbook

A first-15-minutes PostgreSQL performance runbook using pg_stat_activity, pg_stat_statements, waits, locks, temp files, autovacuum, and recent-change checks.

EXPLAIN Plan Review Checklist

A practical checklist for reviewing PostgreSQL EXPLAIN ANALYZE BUFFERS output: row estimates, loops, filters, buffers, temp files, joins, and sort…

Autovacuum Performance Checklist

How to identify autovacuum-related performance problems: dead tuples, stale statistics, old transactions, table churn, bloat, and per-table tuning.

pg_stat_statements Workflow

How to use pg_stat_statements as a production tuning queue: total time, mean time, variance, calls, I/O, temp blocks, resets, and…