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:

• What queries are consuming the most IOPS or CPU time?
• Which transactions are hanging in the Idle in transaction state?
• Which query is holding the lock?

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.