PgHero

PgHero shows you what your database is doing: slow queries, missing indexes, unused
indexes, table bloat, connections and query statistics.

What you get

• A slow query list backed by pg_stat_statements
• Index suggestions, and unused indexes you can drop
• Space usage per table
• Live queries, with a kill button
• Historical query stats if you enable capture

Mounting it

# Gemfile
gem "pghero"

# config/routes.rb
authenticate :user, ->(user) { user.admin? } do
  mount PgHero::Engine, at: "/pghero"
end

Note

PgHero is Postgres-only. On SQLite or MySQL this is not the tool for you.