Redgate Monitor and pgNow
summary
Covers two Redgate tools: pgNow, a free cross‑platform desktop preview that takes 10‑second snapshots of pg_stat_statements and pg_stat_activity to show deltas, live sessions, index usage and heuristic estimated plans (no parameters or auto_explain plans yet, no SSH tunneling in preview); and Redgate Monitor, a paid service with alert inheritance, baselining, visual explain plans, vacuum/index diagnostics and upcoming TimescaleDB-backed storage that claims ~10x query and retention gains. Expect concrete demos of current queries, alerts, vacuum thresholds and index scans rather than high‑level theory.
AI-written summary · about
chapters (13)
- 0:00Redgate and monitoring tools
- 3:54Postgres monitoring challenges
- 14:28Effective Postgres monitoring
- 20:48Redgate Monitor features
- 35:43Redgate Monitor alerts
- 38:55Future of Redgate Monitor
- 39:58PG Now free monitoring tool
- 41:00PG Now workload analysis
- 43:52PG Now live snapshots
- 45:40PG Now indexing analysis
- 47:05Postgres config recommendations
- 48:28Table vacuum config
- 49:09PG Now goals
related talks
20mManaging the Challenge of Monitoring Growing, Multi-platform Database Estates- 20mManaging the Challenge of Monitoring Growing, Multi-platform Database Estates
- 20mManaging the Challenge of Monitoring Growing, Multi-platform Database Estates
49mProfessional PostgreSQL monitoring made easy
25mpg_stat_monitor: A cool extension for better monitoring using PMM
51mPostgreSQL Query Performance Insights
50mPostgreSQL Query Performance Insights
51mHow to improve PostgreSQL Monitoring and ...