Skip to content
CAI
Produce a survey ↗Verify a survey

ankane/pghero

PgHero is an open-source dashboard for monitoring and managing PostgreSQL databases. It provides comprehensive visibility into database health, query performance, and system metrics, while offering tools for maintenance, index management, and query analysis. The system supports multi-database navigation and allows for configurable thresholds and statistics collection.

61.9

Adequate · 2 August 2026

3k

lines of production code

Ruby

primary language

1

bus factor · 35 authors in all

2

measurements over time

CAI band scale
CAI trend line

How it got here

2014 · Dashboard overhaul and multi-database support

This period focused on a comprehensive redesign of the PgHero interface and backend architecture to support multiple databases. The work introduced a new modular structure with dedicated pages for system stats, query analysis, and maintenance, while updating dependencies and adding extensive test coverage.

8 changes

2015–2024 · Architecture modernization and modularization

This period focused on restructuring the codebase by refactoring methods into modular components and introducing separate database support for statistics to improve maintainability. The work also involved adding new generators, Rake tasks, and helper modules to streamline configuration and data collection, while updating frontend libraries and styles for better compatibility and visual consistency.

9 changes

CAI lens gauges

Survey your own repository

ankane/pghero was measured the same way every project in this corpus was: the same rubric, at a pinned commit, with the result published in full. Point the surveyor at a repository you know and see whether you agree with it.

Survey a repository

About this page

  • The description of this project is derived from its own commit history, not from its README.
  • The score is its highest published measurement, taken on 2 August 2026 at a pinned commit. It is not a live figure and does not change until the project is measured again.
  • Measured at commit 607e397d5e — the exact code this score is about.
  • Scored under rubric rubric-2026.08.18. Score the same commit under that rubric and you get the same number.
CAI link cards