Page MenuHomePhabricator

Port postgresql metrics to Prometheus
Closed, ResolvedPublic

Description

Exporter: (in Debian testing/unstable too) https://github.com/wrouesnel/postgres_exporter

Event Timeline

akosiaris triaged this task as High priority.
fgiunchedi moved this task from Doing to Radar on the User-fgiunchedi board.

Change 392441 had a related patch set uploaded (by Dzahn; owner: Alexandros Kosiaris):
[operations/puppet@production] Add postgresql::prometheus class to postgresql users

https://gerrit.wikimedia.org/r/392441

Change 392441 merged by Alexandros Kosiaris:
[operations/puppet@production] Add prometheus::postgres_exporter class to users

https://gerrit.wikimedia.org/r/392441

Apart from netmon2001 who has some puppet issues, all other postgres dbs have now the reporter installed and seemingly working fine.

Let's create some graphs in grafana and close this.

Change 399380 had a related patch set uploaded (by Alexandros Kosiaris; owner: Alexandros Kosiaris):
[operations/puppet@production] Instruct prometheus to gather postgresql metrics

https://gerrit.wikimedia.org/r/399380

Change 399380 merged by Alexandros Kosiaris:
[operations/puppet@production] Instruct prometheus to gather postgresql metrics

https://gerrit.wikimedia.org/r/399380

And we got our first dashboard. https://grafana.wikimedia.org/dashboard/db/postgres?orgId=1. service owners are encouraged to adapt to their needs. I think this is finally resolved.