Professional PostgreSQL monitoring made easy with pgwatch2
I’ve been interested with databases for the last 11 years, working last 7 years exclusively with PostgreSQL. And still I’m constantly surprised by it’s powerful set of features and the fast pace of development by the globally friendly community. On my spare time I enjoy playing soccer and travelling.
The talk firstly introduces all pertinent levels of database monitoring and then focuses on PostgreSQL and the means it provides. As the Postgres community has already developed a lot of tools in that area, some most popular approaches are explained, together with the problems that different approaches have. To overcome some of these problems a relatively new Open Source tool called "pgwatch2" is introduced and explained in detail to offer the simplest possibly 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 (InfluxDB) with the help of the TICK stack or Grafana.
- 2018 April 18 12:30 EDT
- 20 min
- PostgresConf US 2018
- Operations and Administration