​
What is Postgres Database Monitoring?

Postgres Database Monitoring is a feature that allows you to track the performance and health of your Postgres databases. It analyzes active connections, uptime, and transaction commit ratio, alerting you when thresholds are exceeded.

​
Why Monitor Postgres Database?

  • Detect potential performance issues before they impact applications
  • Identify resource utilization trends
  • Optimize database performance and troubleshooting

​
Tutorial Video

Monitoring for Postgres

​
How do I set up Postgres Database Monitoring?

Add the Postgres resource to your Alerty inventory, and Alerty will begin monitoring it automatically! When Alerty detects an issue, it will send you an alert.

​
Setting up Postgres Database Monitoring

To monitor Postgres databases, you’ll need to provide the following information:

  1. DSN (Data Source Name): The connection string to your Postgres database, in the format:

postgresql://<username>:<password>@<host>:5432/<db_name>

​
Monitors

The following monitors are available for Postgres Database:

  • Active Connections usage
    • Alerts when the percentage of active connections approaches 80% of the max connections set
  • Up-time
    • Alerts when the database up time is less than 2 minutes, which could indicate a recent restart
  • Transaction Commit Ratio
    • Alerts when the commit ratio is below 90%, which could indicate a problem with the transactions

​
How It Works

Once set up, Alerty will continuously monitor your Postgres database performance and health using Postgres APIs. It uses advanced algorithms to detect potential issues, sending alerts when thresholds are exceeded. When an issue is detected, Alerty will send you an alert with details about the issue, allowing you to investigate and respond promptly.