Checkout the slides

Objective: From this topic, DBA should know how to approach if they are looking for testing, reproducing issues, Health checks, and monitoring for PostgreSQL.

Talk abstract:

• Introduction: The significance of testing and monitoring tools and why DBA needs them. 
• Obstacles: Testing environment Provisioning, Time-consuming, and Monetary cost.
• Solution:  Utilizing opensource tools and virtualization options for quick setups and tests: Docker, Lxc, Vagrant, etc.
• The best and fastest way to setup complex PostgreSQL setups like PostgreSQL replication, Patroni Cluster, and Kubernetes Operator environment for PostgreSQL using an opensource tool called  Anydbver(Developed and Maintained by Percona engineer) https://github.com/ihanick/anydbver 
• Things to monitor for good performance,  Current vs. Historical data analysis
• Monitoring Tools: pg_gather(https://github.com/jobinau/pg_gather), PMM  [with use cases and examples]