Monitoring v1.0 roadmap
1. [ ] Testing (minimum: correctness of exporter code against various PG versions)
2. [ ] Host stats (minimum: self-hosted)
3. [ ] Process stats (minimum: self-hosted)
4. [ ] Gaps with old pgwatch postgres.ai edition
- [ ] dashboard no.1 improvements
- [ ] IO timing
- [ ] replication lags
- [ ] primary vs replica top bar
- [ ] DB size
- [ ] polish graph titles
- [ ] system catalog size -- which dashboard?
- [ ] table / tuple stats + seqscans
6. [ ] Gaps with old checkup tool
- TODO – list
8. [ ] More ways of installation (minimum: via console.postgres.ai)
9. [ ] :question: suggest why graph has no data
10. [ ] More on dashboard no.1
- [x] checkpointer&bgwriter
- [ ] [autovauum]vacuum timeline
- [ ] get rid of all "TODO"
- [ ] WAL archive lag
- [ ] planning stats high-level
- [ ] :question: SLRU stats `pg_stat_slru` (or different dashboard?) // minimum: collect metrics
- [ ] :question: `pg_stat_io` (or different dashboard?) // minimum: collect metrics
- [ ] deadlocks
- [ ] xmin horizon
- [ ] OID consumption
- [ ] tuple stats, high-level (`pg_stat_database`)
- [ ] in general, high level stats from `pg_stat_database` - review what we're missing and consider adding (especially various errors)
11. [ ] DB by default
12. [ ] node autodiscovery (especially patroni)
13. [ ] pg_wait_sampling
14. [ ] pg_stat_kcache
15. [ ] Locks and block chains
16. [ ] self-analysis: disk space used/free, what else?
17. [ ] RETENTION period (default + configurable)
18. [ ] bloat (table and index) - estimated and Boguk rate
---
## Acceptance Criteria
- All items in the v1.0 roadmap checklist are implemented or explicitly deferred with justification
- Core features delivered: testing framework, host stats, process stats, pgwatch parity dashboards
- IO timing, replication lags, DB size, table/tuple stats, checkpointer/bgwriter panels are live
- At least one additional installation method (via console.postgres.ai) is available
- Retention period is configurable with a sensible default
## Definition of Done
- All checked items in the roadmap are deployed and verified
- Monitoring v1.0 is released with a changelog
- Outstanding items are tracked as separate follow-up issues
- Demo environment reflects the v1.0 feature set
issue