Awesome GitHub RepositoriesPerformance and Optimization

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

pgBadger 是一个 PostgreSQL 日志分析器和数据库性能分析器，解析数据库日志以生成关于慢查询和系统错误的详细报告。它作为统计可视化工具，将原始日志转换为交互式图表，以监控系统趋势。 该工具利用多核日志处理器将解析任务分配到 CPU 核心，加速对大量数据库活动日志的分析。它提供了一种远程日志分析机制，通过安全 Shell 连接从远程服务器检索和解析文件。 该系统涵盖数据库资源监控、连接池日志分析和性能趋势可视化。它支持生成增量报告以创建累积摘要，并以 JSON 格式导出分析指标，以便与外部监控工具集成。 分析后的数据被转换为静态 HTML 报告和图像，供离线查看。

Postgres Explain Visualizer 2

Pgtune - tuning PostgreSQL config by your hardware

Command-line admin tool for observing and troubleshooting Postgres.

PostgreSQL configuration wizard

PostgreSQL Monitoring, Metrics Collection and Alerting Resources from Crunchy Data

Tool that extracts and provides metrics on your PostgreSQL database

A tool for tuning TimescaleDB for better performance by adjusting settings to match your system's CPU and memory resources.

Adaptive query optimization for PostgreSQL

Web Based PostgreSQL configuration tool

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