Ross ROSS = Recommend OSS · open-source software intelligence for agents

pawurb/rails-pg-extras

Rails PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more. observed · 2026-08-28

github.com/pawurb/rails-pg-extras · Ruby · MIT (permissive) observed · 2026-08-28

Health v2 · maintenance only

71/100

  • Activity 87
  • Release rhythm 35
  • Longevity 100

Flags: no_releases

How is this computed?

round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.

  • gap_med: n/a
  • age_days: 2443
  • days_rel: n/a
  • days_push: 78
  • n_releases_24m: 0

Full methodology

Adoption not part of the score

1247 stars · 39 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

A Ruby gem providing PostgreSQL performance diagnostics for Rails applications, ported from Heroku PG Extras. It exposes rake tasks, a Ruby API, and an optional web UI for queries about locks, index usage, buffer cache hit ratios, vacuum stats, and slow queries.

Use cases

  • diagnose slow postgres queries in a rails app
  • check index usage and missing indexes in postgresql
  • inspect database locks and blocking queries
  • monitor buffer cache hit ratio and vacuum stats
  • find most expensive sql queries with pg_stat_statements
  • integrate postgres health checks into monitoring tasks

When to choose

  • you run a Ruby on Rails app on PostgreSQL and need performance insights without Heroku's plugin
  • you want a scriptable Ruby API plus optional web UI for database diagnostics
  • you need quick rake-task-based access to pg_stat_statements, locks, and cache stats

When to avoid

  • your app is not on Rails or Ruby (use ruby-pg-extras or the Node/Rust/Elixir/Python ports instead)
  • you need full continuous database observability rather than on-demand diagnostics
  • you use a database other than PostgreSQL

Facets

library · maturity active

database monitoring developer-tools databases developer-tools performance web-development ruby postgresql rails activerecord database-performance diagnostics rake-tasks

1 source

Member repositories

RepositoryRoleHealth v2
pawurb/rails-pg-extrasmain71

For agents

markdown · JSON · MCP: product_card(name="pawurb/rails-pg-extras")

Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem