PG Reports

PostgreSQL Analysis Dashboard

A comprehensive PostgreSQL monitoring and analysis library for Rails applications. Get insights into query performance, index usage, table statistics, connection health, and more — across every database on the cluster, switchable from the dashboard with no extra configuration. Includes a beautiful web dashboard, a Grafana / Prometheus exporter, and Telegram delivery.

What you get

• 📊 Query Analysis - Identify slow, heavy, and expensive queries using pg_stat_statements
• 📇 Index Analysis - Find unused, duplicate, invalid, and missing indexes
• 📋 Table Statistics - Monitor table sizes, bloat, vacuum needs, and cache hit ratios
• 🔌 Connection Monitoring - Track active connections, locks, and blocking queries
• 🖥️ System Overview - Database sizes, PostgreSQL settings, installed extensions
• 🌐 Web Dashboard - Beautiful dark-themed UI with sortable tables and expandable rows
• 📨 Telegram Integration - Send reports directly to Telegram

Mounting it

# Gemfile
gem "pg_reports"

# config/routes.rb
mount PgReports::Engine, at: "/pg_reports"

Details

76 stars on GitHub · MIT licensed · maintained by deadalice. Source: https://github.com/deadalice/pg_reports