PostgreSQL Monitoring Day with Zabbix & Postgres Pro
Event Information
About this Event
Agenda
18:00 - Event opening
Ivan Panchenko, Deputy CEO, Postgres Pro
Alexei Vladishev, Zabbix Founder and CEO
18:20 - Setting up Zabbix Agent 2 for PostgreSQL monitoring and revealing how it works by Daria Vilkova, Software Engineer (Postgres Professional)
When Zabbix announced the availability of its new Agent 2 written in Golang, we at PostgresPro decided to take advantage of its extensibility and develop a PostgreSQL monitoring module for Agent 2. The PostgreSQL monitoring plugin for Zabbix Agent 2 enables an easy setup of the basic monitoring for your database, including triggers, graphics, and screens. It collects more than 95 metrics. The plugin employs github.com/jackc/pgx PG driver and the toolkit for Go. One installation of Zabbix Agent 2 makes it possible to monitor several PostgreSQL instances. In this presentation, we will discuss the monitoring module internals and walk through how it operates. We will also provide a few tips on how to set up this plugin. We will also introduce the new version of the PostgreSQL monitoring plugin and look into creating custom metrics - this feature will become available with plugin v.2 and increase the number of accessible metrics even more.
18:40 - New Monitoring-Related Features in PostgreSQL 13 by Anastasia Lubennikova, Sr. Database Developer (Postgres Professional), PostgreSQL contributor
Every monitoring solution is built to collect a certain number of metrics from the monitored system. In fact, you are always limited by the information the system lets you collect. PostgreSQL DBMS provides a lot of metrics reflecting its internal state, running queries, and background processes. Each release brings the community more monitoring-related features. This talk covers monitoring enhancements coming with PostgreSQL 13: query sampling, improved WAL usage statistics, pg_basebackup progress reporting, etc. Some of these metrics may appear in future releases of monitoring plugins, or you may use them in your custom scripts or when formulating custom requests to the database.
19:00 - Coffee break
19:10 - How to deploy Zabbix on PostgreSQL with Timescale DB plugin by Dmitry Lamberts, Head of Technical Support, Zabbix, Latvia
PostgresSQL is one of the supported database engines for Zabbix, that is used both, to store all configuration data and history that turns Postgres in the very high load Database engine. TimescaleDB is a great extension to Postgres that empowers Zabbix with native partitioning functionality and data compression that saves a lot of disk space for our users.
19:30 - Workshop: Final Tuning of PostgreSQL for Zabbix with Artūrs Lontons, Technical Support Engineer, Zabbix, Latvia
Optimizing Zabbix consists of not only changing Zabbix internal parameters but also configuring your DB backed accordingly. In this workshop, we will take a look at how different Zabbix parameters affect the DB configuration requirements. In addition, we will be performing a general PostgreSQL Fine-Tuning for Zabbix workloads.
To successfully participate in the workshop Zabbix 5.2 with Postgresql DB backend is required.
20:00 - Q&A session with ALL speakers