Professional PostgreSQL Monitoring Made Easy

PostgreSQL Ukraine (Speaker)

The talk firstly introduces all pertinent levels of database monitoring and then focuses on PostgreSQL and the means it provides. The meaning and importance of key metrics will be explained. As the Postgres community has already developed a lot of tools in that area, some popular common options will be highlighted together with the problems that different monitoring approaches have.

To overcome some of these problems, an open-source tool from Cybertec, called pgwatch, is introduced and explained in detail to offer the simplest possible entry into exhaustive Postgres monitoring.

Also discussed will be advanced topics like anomaly detection and alerting, which can be easily implemented on top of the underlying data tier (TimescaleDB) with the help of the TICK stack or Grafana.