Performance and maintenance
for PostgreSQL
Find costly queries, evaluate indexes before you build them, and reclaim disk space after large deletes. pgQueryOps brings these workflows into one PostgreSQL extension and dashboard.
- PostgreSQL versions
- 15–18
- Deployment
- Self-hosted
- Interfaces
- SQL + HTTPS
Explore pgQueryOps
Start with an observed workload, then investigate a slow plan, test an index idea, or schedule maintenance with evidence.
Workload monitoring
Find query shapes that account for the most execution time. Review call counts, timing and captured workload coverage for each target.
Index advisor
Review index candidates from observed queries. Inspect invalid, duplicate, covered and potentially unused indexes before making changes.
What-if simulation
Compare estimated plans with a hypothetical index or with an existing index hidden from the planner for that comparison.
Before and after measurements
Measure the same SELECT around an approved index build. Review observed median and p95 timings alongside the separate planner estimate.
Performance history
Record execution plans and sampled waits. Compare a changed plan with an approved reference to investigate a regression.
Incident center
Review persistent evidence of slow plan changes, long lock waits and sustained connection pressure in one queue.
Live diagnostics
Trace blocked sessions to their blockers, inspect sequential scan progress, and review private backend memory on Linux.
Space reclamation
Reuse free space within a table to compact its files without a full table copy. Preview space requirements and track a resumable job.
Query rules
Redirect eligible SELECT statements or add a predicate for selected roles with an explicitly enabled rule.
Check your first target
Install the matching extension and gateway, then connect to a target database to check its version and capture status.
Follow the quick startSELECT extversion
FROM pg_catalog.pg_extension
WHERE extname = 'pg_queryops';
SELECT queryops.pg_queryops_status();Start with one database
Set up a viewer for the first target, review its workload, then add the permissions needed for simulations or approved maintenance.
Read about target access