Open-source alternatives to Pgtune

PgHero is a performance dashboard and diagnostic tool for PostgreSQL. It provides a web interface for monitoring database metrics, analyzing query performance, and managing active connections across multiple database instances. The project distinguishes itself by recording query and storage statistics over time, enabling historical trend analysis through a time-range slider. It also identifies missing indexes by analyzing query patterns and integrates with cloud provider APIs to retrieve system-level hardware statistics such as CPU and IOPS. The tool's broader capabilities cover process admi

A PostgreSQL assistant for developers Understand, optimize, and improve your PostgreSQL database with ease.

PostgreSQL Monitoring, Metrics Collection and Alerting Resources from Crunchy Data

Postgres Explain Visualizer 2

pgBadger is a PostgreSQL log analyzer and database performance profiler that parses database logs to generate detailed reports on slow queries and system errors. It functions as a statistics visualizer, transforming raw logs into interactive charts and graphs to monitor system trends. The tool utilizes a multi-core log processor to distribute parsing across CPU cores, accelerating the analysis of large volumes of database activity logs. It provides a mechanism for remote log analysis by retrieving and parsing files from distant servers via secure shell connections. The system covers database