The index advisor that sees your entire cluster
Identifies unused, missing, duplicate, and low-usage indexes across primaries and replicas. Space-waste estimates and ready-to-execute SQL — all cluster-aware.
Other tools analyze a single server. Drop an 'unused' index and your read replicas break. Our index advisor aggregates usage across every instance so you never make that mistake.
Cluster-wide aggregation
Index usage stats are aggregated across every instance in your cluster — primary, replicas, and cascading standbys. One unified view, not per-server silos.
Usage sparklines
Historical usage trends for every index so you can distinguish "never used" from "used once a week for the critical batch job".
Unused index detection
Indexes that are genuinely unused across every instance in your cluster are flagged for removal — with DROP statements ready to execute.
Missing index opportunities
Sequential scan analysis identifies tables where indexes would make the biggest impact. Suggested CREATE INDEX statements included.
Duplicate index detection
Find indexes that overlap or fully duplicate each other. Reclaim storage and reduce write amplification by removing redundant indexes.
Space-waste estimates
See exactly how much disk space each unused or duplicate index wastes. Prioritize cleanup by the indexes burning the most storage.
Related capabilities
Health Scoring
75+ automated checks across 12 scoring domains
EXPLAIN Plan Advisor
Visual plan analysis, guided walkthroughs, and regression detection
XID Wraparound Protection
Blocker detection, recovery scripts, and runbooks
TimescaleDB Monitoring
The most complete TimescaleDB monitoring anywhere
pgvector Monitoring
First-class pgvector index and query monitoring
PostGIS Monitoring
Spatial data inventory, index health, and geometry checks
Incident Analysis
Manual incident reports with evidence, root cause, timeline, and remediation
Phantom Incidents
Always-on anomaly detection for problems you haven't thought to alert on
Query Tuning
Highest-impact queries, the best tuning candidates, and exactly what to do
Optional AI Analysis
Manual AI depth for incidents, query plans, tuning, and explanations
Data Collection Options
Shared managed, dedicated managed, or self-hosted collectors
Smart Alerting
Rate-of-change, compound conditions, and 11 prebuilt templates
Logical Replication
Slot, subscription, apply lag, and PG17 conflict monitoring
Setup Assistant
Extension detection, auto-install, and provider-specific guides
Collaborative Playbooks
Shared remediation plans with review workflow
Trend Insights
Priority trend analyzers with severity cards and sparklines
See it in action
Start free with one primary or standalone PostgreSQL instance and all its databases. Monitoring, alerts, query insights, index advice, team access and every non-AI feature included. No replicas. No credit card required. New Free connections get seven days of full collection, then reduced sampling. Free and Pro include 30 days of monitoring history.