Pg-agent
is a Prometheus exporter for Postgres focusing on query performance statistics.
Features
Comprehensive query metrics
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
Locks monitoring
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 metric can provide the answer to that.
Query normalization and obfuscation
In addition to query normalization, which Postgres does, the agent obfuscates all queries so that no sensitive data gets into the metrics labels.
License
Coroot-pg-agent is licensed under the Apache License, Version 2.0.