runbooks
postgres_exporter
runbooks | postgres_exporter | |
---|---|---|
16 | 15 | |
- | 2,549 | |
- | 1.9% | |
- | 7.9 | |
- | 10 days ago | |
Go | ||
- | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
runbooks
-
Monitoring system health, Logs and scheduled jobs
There are also good patterns for monitoring the status of jobs.
-
Jenkins build time in Prometheus
Check out this job monitoring pattern.
-
Alert Reference Documentation
For a freely available resource, I found GitLab’s Runvbooks a good example to strive towards. But this is the output of a large team and several years. My advice is to just start with something simple.
-
Gitlab is ALWAYS down
It's a weighted combination of all services. The SLA weightings for all service areas are defined in the gitlab.com service catalog.
- An impatient SRE's guide to deleting alerts
-
Any simple ways to record the duration of arbitrary processes?
Take a look at this pushgateway-based job monitoring pattern.
- Gitlab S-1
-
To use Gitlab Dashboards - How to use grafonnet with jsonnet to produce a json file that I can use with Grafana
I want to use the GitLab dashboards here in my local Grafana environment - https://gitlab.com/gitlab-com/runbooks/-/tree/master/dashboards
-
Looking for Grafana dashboards to help us monitor our GitLab services running in Kubernetes
Also, take a look at the code https://gitlab.com/gitlab-com/runbooks
-
Is a runbook what I’m looking for?
GitLab puts everything in a git repo in markdown. A single repo that contains a few different things. All of the production alerts are sourced from there. This makes it possible to review alerts and runbook changes in the same code review.
postgres_exporter
-
💻 7 Open-Source DevTools That Save Time You Didn't Know to Exist ⌛🚀
🌟 Support on GitHub Website: http://prometheus.io/community
-
Tools to inspect/audit Postgres DBs
An easy way forward would be to export it as a metric through something like https://github.com/prometheus-community/postgres_exporter and then set up an alert on the metric reporting >= 1.
-
How to integrate coroot-pg-agent with prometheus
We use postgres as RDBMS for our database needs and if you guys are already using postgres_exporter(https://github.com/prometheus-community/postgres_exporter) for exporting PostgreSQL server metrics to prometheus, then you can surely give coroot-pg-agent a try.
-
Pg-agent – a Postgres exporter for Prometheus focusing on query performance statistics
It’s not that simple…https://github.com/prometheus-community/postgres_exporter :)
- Given an ansible playbook, how do I "execute" it on a server?
-
Tips for a Healthier Postgres Database
New server and want a basic config for a production server? (I'm assuming brand new app here, no prior monitoring and knowledge on what to tune.)
Use this to get the values you need https://pgtune.leopard.in.ua/#/ .
This saved me a lot of headaches, and it just gets the server into a good enough state from which you can observe and optimise later.
I'd also add in monitoring early, add a Prometheus exporter https://github.com/prometheus-community/postgres_exporter and alerts https://awesome-prometheus-alerts.grep.to/rules#postgresql . There are a few Grafana dashboards available for the prometheus exporter, start with those.
-
Prometheus exporter preference: postgres_exporter vs pg_exporter?
I’m setting up some monitoring for a PostgreSQL instance and came across two seemingly mature projects for Prometheus monitoring, those being postgres_exporter and pg_exporter . From the outside it looks like postgres_exporter is linked from the Prometheus pages, but has fewer recent updates, and pg_exporter has a smaller user base but a more active development community.
-
Top PostgreSQL monitoring metrics for Prometheus – Includes cheat sheet
PostgreSQL monitoring with Prometheus is an easy thing to do thanks to the PostgreSQL Exporter.
-
PostgreSQL vs Prometheus
Thanks, that is probably a better fit. I was looking to use this part of the PostgreSQL exporter: https://github.com/prometheus-community/postgres_exporter/blob/master/queries.yaml and just not care about the metrics about Postgres itself.
-
Custom healthcheck and alerting tool
The postgres_exporter provides the data about the state of replication. Then you have rules like these to validate the data.
What are some alternatives?
operator - Kubernetes operator for Victoria Metrics
pg_exporter - postgres exporter for prometheus
mermaid - Generation of diagrams like flowcharts or sequence diagrams from text in a similar manner as markdown
coroot-pg-agent - A Prometheus exporter for Postgres focusing on query performance statistics
diagrams - :art: Diagram as Code for prototyping cloud system architectures
node_exporter - Exporter for machine metrics
gl-infra
supabase - The open source Firebase alternative.
Trickster - Open Source HTTP Reverse Proxy Cache and Time Series Dashboard Accelerator
PgHero - A performance dashboard for Postgres
postgres - Unmodified Postgres with some useful plugins
realtime - Broadcast, Presence, and Postgres Changes via WebSockets