Monitoring PostgreSQL with Percona Monitoring and Management (PMM)

1 . Monitoring PostgreSQL with Percona Monitoring and Management (PMM) Michael Coburn Percona 1 © 2019 Percona 

2 .Michael Coburn ▪ Product Manager for PMM (as well as for Percona Toolkit). ▪ At Percona for 6 years across multiple MySQL roles Principal Architect, Managing Consultant, Technical Account Manager 2 © 2019 Percona 

3 .What is PMM ▪ Free, Open Source database troubleshooting and performance optimization platform for MySQL, MongoDB, and PostgreSQL ▪ We also support: ProxySQL Amazon RDS MySQL & Aurora MySQL Remote MySQL & PostgreSQL instances ▪ Runs in your secure environment (this is not a SaaS product!) and on your equipment ▪ Secured with SSL between client and server 3 © 2019 Percona 

4 .Amazon RDS and Aurora PostgreSQL 4 © 2019 Percona 

5 .Add Instances 5 © 2019 Percona 

6 .List Instances 6 © 2019 Percona 

7 .Remote PostgreSQL For when you don't have shell, or run an unsupported platform (eg. PostgreSQL on Windows) 7 © 2019 Percona 

8 .Add Remote Instances 8 © 2019 Percona 

9 .Command Line 9 © 2019 Percona 

10 .Command Line ▪ yum -y install pmm-client ▪ pmm-admin config --server 1.2.3.4 ▪ pmm-admin add postgresql linux:metrics postgresql:metrics 10 © 2019 Percona 

11 .Dashboards 11 © 2019 Percona 

12 .PostgreSQL Overview 12 © 2019 Percona 

13 .Using Grafana Alerting 13 © 2019 Percona 

14 .Grafana Alerting ▪ Rules are added to graphs that react based on defined thresholds ▪ Alerts are sent to pre-defined Notification Channels You can have multiple channels defined 14 © 2019 Percona 

15 .Grafana Alerting 15 © 2019 Percona 

16 .Grafana Notification Channels ▪ Defines how you will learn about new alerts ▪ Over a dozen are available: Email Slack PagerDuty AlertManager ... 16 © 2019 Percona 

17 .What's on the Roadmap ▪ PostgreSQL Query Analytics ▪ Vacuum statistics ▪ Replica metrics 17 © 2019 Percona