PostgreSQL: Coroot-pg-agent - an open-source Postgres exporter for Prometheus

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

The Coroot team is happy to announce coroot-pg-agent – an open-source (Apache 2.0) Postgres exporter for Prometheus focusing on query performance statistics.

Motivation:

At Coroot, we work on a product that detects the root cause of a service outage and provides our users with a list of possible fixes.

Initially, we planned to use metrics collected by existing open-source Prometheus exporters, such as postgres_exporter (1.7k stars on Github). Unfortunately, we realized that the metrics it collects are useless for identifying the most common performance issues, like:

• A CPU-intensive query is affecting other queries
• A server has reached its max_connections limit because most of the connections are stuck in the idle in transaction state
• An I/O-intensive query is affecting other queries...

Get the full details here: https://www.postgresql.org/about/news/coroot-pg-agent-an-open-source-postgres-exporter-for-prometheus-2488/

[bot]

Corresponding tweet for this thread:

Devtalk

Share link for this tweet.