Superviser PostgreSQL
Transcript of Superviser PostgreSQL
![Page 1: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/1.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Superviser PostgreSQL
![Page 2: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/2.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
A propos de moi
▶ Damien Clochard ( @daamien )▶ COO de Dalibo▶ Président de l’association PostgreSQLFr▶ Créateur de PG Mag / PostgreSQL Dashboard▶ Dalibo Recrute ! ( DBA, Dev UX/UI, Chef de projet, … )
![Page 3: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/3.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Superviser ?
| sy.p��.vi.ze |
« Se placer au dessus pour voir, remarquer, prendre desmesures »
![Page 4: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/4.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Méthodologie
▶ 40 logiciels étudiés▶ 6 critères d’évaluation▶ Pas d’outils propriétaires▶ Pas d’outils dans le “cloud”
![Page 5: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/5.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Est-ce que tout va bien ?
![Page 6: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/6.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Zabbix
http://www.zabbix.com/
![Page 7: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/7.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
![Page 8: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/8.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
pg-monz
▶ Stabilité 3▶ Activité 3▶ Communauté 4▶ Documentation 3▶ Fonctionnalités 2▶ Simplicité 1
![Page 9: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/9.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Nagios
https://www.nagios.org/
![Page 10: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/10.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
![Page 11: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/11.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
check_postgres
▶ Stabilité : 4▶ Activité : 0▶ Communauté : 4▶ Documentation : 5▶ Fonctionnalités : 3▶ Simplicité : 3
![Page 12: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/12.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
check_pgactivity
▶ Stabilité : 5▶ Activité : 4▶ Communauté : 1▶ Documentation : 5▶ Fonctionnalités : 5▶ Simplicité : 5
![Page 14: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/14.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
![Page 15: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/15.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
OPM
▶ Stabilité : 4▶ Activité : 3▶ Communauté : 2▶ Documentation : 2▶ Fonctionnalités : 3▶ Simplicité : 3
![Page 16: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/16.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Mais aussi ….
▶ Shinken▶ Icinga▶ Naemon▶ …
![Page 17: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/17.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Que se passe-t’il sur ma base ?
![Page 18: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/18.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
pg_stat_activity
![Page 19: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/19.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
![Page 20: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/20.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
pg_activity
https://github.com/julmon/pg_activity
![Page 21: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/21.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
![Page 22: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/22.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
pg_activity
▶ Stabilité : 4▶ Activité : 3▶ Communauté : 1▶ Documentation : 4▶ Fonctionnalités : 5▶ Simplicité : 5
![Page 23: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/23.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Mais Aussi …
▶ pg_top▶ pg_view▶ pgstats▶ pgCenter▶ Pome▶ PostgreSQL Dashboard
![Page 24: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/24.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Que s’est-il passé hier ?
![Page 25: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/25.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
pg_stat_statements
![Page 26: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/26.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
![Page 27: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/27.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Munin
http://munin-monitoring.org/
![Page 28: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/28.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
![Page 29: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/29.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
pyMunin
▶ Stabilité : 4▶ Activité : 3▶ Communauté : 2▶ Documentation : 3▶ Fonctionnalités : 4▶ Simplicité : 4
![Page 30: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/30.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
pgBadger
http://dalibo.github.io/pgbadger/
![Page 31: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/31.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
![Page 32: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/32.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
pgBadger
▶ Stabilité : 4▶ Activité : 4▶ Communauté : 4▶ Documentation : 4▶ Fonctionnalités : 5▶ Simplicité : 5
![Page 33: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/33.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Mais aussi…
▶ pg_query_analyser▶ pgAudit▶ pgAudit
![Page 34: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/34.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Comment Optimiser ?
![Page 35: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/35.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
PoWA
http://dalibo.github.io/powa/
![Page 36: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/36.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
![Page 37: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/37.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
PoWA
▶ Stabilité : 4▶ Activité : 4▶ Communauté : 3▶ Documentation : 4▶ Fonctionnalités : 4▶ Simplicité : 3
![Page 38: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/38.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
pgObserver
http://zalando.github.io/PGObserver/
![Page 39: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/39.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
![Page 40: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/40.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
pgObserver
▶ Stabilité : 3▶ Activité : 4▶ Communauté : 2▶ Documentation : 2▶ Fonctionnalités : 3▶ Simplicité : 3
![Page 41: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/41.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
pgCluu
http://pgcluu.darold.net/
![Page 42: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/42.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
![Page 43: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/43.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
pgCluu
▶ Stabilité : 4▶ Activité : 4▶ Communauté : 4▶ Documentation : 4▶ Fonctionnalités : 4▶ Simplicité : 5
![Page 44: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/44.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Mais Aussi…
▶ pgHero▶ postgresql-metrics par Spotify▶ pgSnap
![Page 45: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/45.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Que Choisir ?
![Page 46: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/46.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Définir un socle
▶ Une vue d’ensemble▶ Un “top” en ligne de commande▶ Un analyseur de perf▶ Une historisation des métriques
![Page 47: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/47.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Rester à l’écoute
▶ Domaine ultra dynamique▶ Les auteurs ont besoin de feedback !▶ Attention aux coûts cachés !▶ « One tool to rule them all » ?
![Page 48: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/48.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Plus d’info
▶ Livre blanc à paraître▶ planet.postgresql.org▶ https://wiki.postgresql.org/wiki/Monitoring▶ Awesome PostgreSQL
![Page 49: Superviser PostgreSQL](https://reader034.fdocument.pub/reader034/viewer/2022051406/627d74fff6417f0be058d7b3/html5/thumbnails/49.jpg)
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
...
.
Merci !
▶ contact: [email protected]▶ Dalibo recrute un dev UI/UX !