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