Presented by:

Mina github

Kaarel Moppel

Cybertec

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.

No video of the event yet, sorry!
Download the Slides

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.

Date:
2018 April 18 12:30
Duration:
20 min
Room:
Enterprise
Conference:
PostgresConf US 2018
Language:
English
Track:
Operations and Administration
Difficulty:
Easy