postgres_exporter
Trickster
postgres_exporter | Trickster | |
---|---|---|
15 | 1 | |
2,549 | 1,954 | |
1.9% | 0.5% | |
7.9 | 6.7 | |
9 days ago | 1 day ago | |
Go | Go | |
Apache License 2.0 | 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.
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.
Trickster
-
PostgreSQL vs Prometheus
Are you thinking of something like nginx which would drop the cache periodically? Which would do this: https://github.com/trickstercache/trickster but for any http request?
What are some alternatives?
pg_exporter - postgres exporter for prometheus
nginx-prometheus - Turn Nginx logs into Prometheus metrics
coroot-pg-agent - A Prometheus exporter for Postgres focusing on query performance statistics
cortex-tenant - Prometheus remote write proxy that adds Cortex/Mimir tenant ID based on metric labels
node_exporter - Exporter for machine metrics
traefik - The Cloud Native Application Proxy
runbooks
sshpiper - The missing reverse proxy for ssh scp
supabase - The open source Firebase alternative.
minio - The Object Store for AI Data Infrastructure
PgHero - A performance dashboard for Postgres
go-feature-flag - GO Feature Flag is a simple, complete and lightweight self-hosted feature flag solution 100% Open Source. 🎛️