We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
Pavlo Golub: Professional PostgreSQL monitoring made easy
Discover Pavlo Golub's introduction to PgWatch, a user-friendly PostgreSQL monitoring tool, featuring easy installation, customizable dashboards, and auto-discovery of databases.
- PgWatch monitoring solution: Pavlo Golub introduces PgWatch, a monitoring tool for PostgreSQL databases, and highlights its features, such as easy installation, customizable dashboards, and auto-discovery of databases.
- Levels of monitoring: He divides monitoring approach into three levels: global database overview, operating system monitoring, and PostgreSQL metrics.
- PgWatch components: The tool consists of a gatherer, which reads configuration and stores metrics, and a Web UI for administration.
- Docker support: PgWatch is available in Docker format, making it easy to set up and run.
- Customization: Users can change dashboards, panels, and colors, and add custom metrics.
- Metrics storage: PgWatch uses TimescaleDB by default, but users can choose other storage options, such as Postgres or temporary storage.
- Alerting system: The tool does not have an integrated alerting system, but users can set up external alerting solutions.
- Query optimization: Analysis of slow queries can help optimize database performance.
- Community support: The tool has a community-driven dashboard collection and invites users to contribute to the project.
- Installation: The tool can be installed using Docker Compose or from sources.
- Key metrics: The tool monitors various PostgreSQL metrics, such as active connections, queries per second, and shared buffer percentage.
- Open-source extensions: PgWatch is built on top of PostgreSQL, which has dozens of extensions available for various monitoring tasks.
- Comparison to other tools: The tool is compared to other monitoring tools, such as Prometheus and Grafana, highlighting its strengths and weaknesses.
- Future development: The speaker invites users to contribute to the project and provides information on upcoming releases and enhancements.