gem-hunter
Language: Go
A Prometheus exporter for Postgres focusing on query performance statistics
Important
This repository is no longer maintained. PostgreSQL-related functionality has moved to coroot-cluster-agent. If you'd like to continue using this exporter, feel free to fork the repository.
Coroot-pg-agent is an open-source prometheus exporter that gathers metrics from Postgres servers.
Metrics should help you identify issues with your Postgres servers.
This agent collects metrics that can help you answer questions such as:
This provides visibility into Postgres performance without the need to navigate through system views manually.
The agent aggregates data from pg_stat_statements and pg_stat_activity to provide accurate metrics about queries, whether they are completed or still running.
Learn more about query metrics in the blog post "Missing metrics required to gain visibility into Postgres performance"
It is not enough to gather the number of active locks from pg_locks. What engineers really want to know is which query is blocking other queries. The pg_lock_awaiting_queries metric can provide the answer to that.
In addition to query normalization, which Postgres does, the agent obfuscates all queries so that no sensitive data gets into the metrics labels.
create role <USER> with login password '<PASSWORD>';
grant pg_monitor to <USER>;
create extension pg_stat_statements;
select * from pg_stat_statements; -- to check
docker run --detach --name coroot-pg-agent \
--env DSN="postgresql://<USER>:<PASSWORD>@<HOST>:5432/postgres?connect_timeout=1&statement_timeout=30000" \
ghcr.io/coroot/coroot-pg-agent
The collected metrics are described here.
Coroot-pg-agent is licensed under the Apache License, Version 2.0.