Announcing version 1.3.0 of the pgwatch2 PostgreSQL monitoring tool

Announcing version 1.3.0 of the pgwatch2 PostgreSQL monitoring tool

Pgwatch2 is an Open Source monitoring tool focusing on dashboards and alerts
provided by Grafana, one of the most popular tools in the area. Software is
designed to be easily installable (Docker) and extensible, by being able to
define new metrics and dashboards dynamically with zero programming.

This update is the biggest feature pack to date and offers advancements
especially for Enteprise and long-term deployments.

Most important features in this release are:

- Support for non-root Docker setups (OpenShift).
- Separate sub-component Dockerfiles and Docker Hub images for more advanced
orchestrated (Kubernetes/OpenShift/Docker Swarm) setups
- HA and load balancing for the metrics storage - 2 mirrored InfluxDBs option.
- More robust metrics storage handling - long term storage failure can't bring
the gatherer daemon down anymore, older metrics dropped in ringbuffer style.
- Better security/access control via env. variables
- Documentation for custom setups

4 new preset dashboards. For screenshots see:
https://github.com/cybertec-postgresql/pgwatch2/tree/master/screenshots

- New dashboard - "Top N time consuming/frequent/slowest queries" added. Based
on pg_stat_statements extension.
- New dashboard - AWS CloudWatch overview. One can now easily monitor/alert on
both on-prem and AWS managed DBs.
- New dashboard - PgBouncer stats. Visualizes PgBouncer "SHOW STATS" output.
- New dashboard - "Biggest relations treemap". Visual highlighting of biggest
tables/indexes.

Other improvements:
- Various usability and security improvements for the Web UI. For example now
possible to hide component logs.
- "Change detection" feature doesn't expect monitoring role to be superuser.
- README updates.

For a complete list of changes, read the changelog here:
https://github.com/cybertec-postgresql/pgwatch2/blob/master/CHANGELOG.md <https://github.com/cybertec-postgresql/pgwatch2/blob/master/CHANGELOG.md>

Pgwatch2 1.3.0 is available on Docker Hub (cybertec/pgwatch2) and for
custom installations instructions can be found from the Github README.

https://github.com/cybertec-postgresql/pgwatch2 <https://github.com/cybertec-postgresql/pgwatch2>

Pgwatch2 is also covered by Cybertec's 24/7 PostgreSQL Support:
https://www.cybertec-postgresql.com/en/services/support/ <https://www.cybertec-postgresql.com/en/services/support/>

Hans-Jürgen Schönig
CEO
Cybertec Schönig & Schönig GmbH

--
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Web: https://www.cybertec-postgresql.com <https://www.cybertec-postgresql.com/>