pgwatch: From Zero to Hero!
In this hands-on workshop, attendees will learn how to set up and operate pgwatch, a powerful open-source monitoring system designed specifically for PostgreSQL. Starting from a clean environment, we will go step-by-step through deploying pgwatch, connecting monitored databases, and exploring built-in Grafana dashboards. Participants will also learn best practices for managing pgwatch efficiently in production environments—covering configuration, data retention, and performance considerations.
In this hands-on workshop, attendees will learn how to set up and operate pgwatch, a powerful open-source monitoring system designed specifically for PostgreSQL. Starting from a clean environment, we will go step-by-step through deploying pgwatch, connecting monitored databases, and exploring built-in Grafana dashboards. Participants will also learn best practices for managing pgwatch efficiently in production environments—covering configuration, data retention, and performance considerations.
Key topics covered:
- Introduction to pgwatch architecture and components
- Installing pgwatch from scratch (Docker or native setup)
- Connecting PostgreSQL instances and collecting metrics
- Understanding key metrics and visualizations in Grafana
- Managing multiple clusters and optimizing data storage
- Practical tips for troubleshooting and maintenance
Expected outcomes: By the end of the session, participants will have a fully functional monitoring setup for PostgreSQL and the knowledge to adapt pgwatch to their own environments.
Prerequisites:
- Basic familiarity with PostgreSQL administration
- Laptop with Docker or a PostgreSQL environment available (any OS is fine — pgwatch is cross-platform)