Hacker GitHub

← All repos

ankane/pghero

View on GitHub ↗ ★ 8,945 Ruby

A performance dashboard for Postgres

22 mentions on Hacker News by 17 people: 7 stories, 15 comments · first 2014-07-24 · latest 2025-12-01

Mentions per year 22 mentions · busiest year 2024 (6)
20082026
AllStoriesComments NewestTopOldest
  1. …both in production and they work very well to help track down performance issues with Postgres. [1] https://github.com/ankane/pghero [2] https://pgtune.leopard.in.ua/ Edit: For the record, I have worked at a few small companies as the…
    comment by rtp4me · 2025-12-01 · in Advent of Sysadmin 2025
  2. …to be empty. Would've been interesting to see that. There's many tools that do similar things like https://github.com/ankane/pghero or some tools here: https://gitlab.com/postgres-ai
    comment by dewey · 2025-02-12 · in PgAssistant: OSS tool to help devs understand and optimize PG performance
  3. ▲ 2
    PgHero: A Performance Dashboard for Postgres
    story by password4321 · 2024-09-26 · 0 comments
  4. …great (props for linking to related projects!), though somehow not discussed here much previously. https://github.com/ankane/pghero https://news.ycombinator.com/item?id=41299148#41300220 (mentioned among the author's other helpful tools…
    comment by password4321 · 2024-09-26 · in SQL Tips and Tricks
  5. …in production, remove duplicate indexes, see missing indexes, keep an eye on table size, etc. https://github.com/ankane/pghero
    comment by andruby · 2024-08-20 · in Transformers for Ruby
  6. …these three utilities help keep our DBs running very well. [0] https://pgtune.leopard.in.ua [1] https://github.com/ankane/pghero
    comment by rtp4me · 2024-06-12 · in How to get the most out of Postgres memory settings
  7. ▲ 4
    PGHero: A Performance Dashboard for Postgres
    story by riv991 · 2024-05-09 · 0 comments
  8. I am using https://github.com/ankane/pghero/ and this is one of its features with GUI
    comment by PikachuEXE · 2024-04-14 · in Show HN: PostgreSQL index advisor
  9. I'm a huge supporter of PGhero ( https://github.com/ankane/pghero ) for this reason. Sometimes a single index is all that's required, but if DB design isn't your forte it's hard to know where to put it.
    comment by bshipp · 2022-01-17 · in How and why the Relational Model works for databases
  10. If you are using rails, pghero is a great gem to get better visibility on your Postgres performance https://github.com/ankane/pghero
    comment by czhu12 · 2022-01-09 · in Tips for a Healthier Postgres Database
  11. Also worth checking out for postgres users: https://github.com/ankane/pghero
    comment by zeypar · 2020-01-24 · in Show HN: Postgresqlco.nf: PostgreSQL Configuration for Humans
  12. Related. https://github.com/ankane/pghero
    comment by whycombagator · 2019-11-06 · in Postgres Health Check and SQL Performance Analysis
  13. …it also sent me down the road to learn (but definitely not master) index optimization. https://github.com/ankane/pghero
    comment by bshipp · 2019-11-04 · in What SQL Analysts Need to Know About Python (2016)
  14. ▲ 2
    A Performance Dashboard for Postgres and Rails
    story by mooreds · 2019-08-14 · 0 comments
  15. …scratch. I discovered a handy little utility called pghero and set up it's internal monitoring: https://github.com/ankane/pghero I backed up my old .conf replaced it with a default and blew away all my old indices, and fired up the…
    comment by bshipp · 2019-03-19 · in Vertically Scaling PostgreSQL
  16. …called, etc. This is all just reading from pg_stats and such but the UI is very nice. [0] https://github.com/ankane/pghero
    comment by _asummers · 2019-02-21 · in PostgreSQL's Explain Analyze Made Readable
  17. ▲ 40
    Pghero 2.0: A performance dashboard for Postgres
    story by craigkerstiens · 2017-08-13 · 1 comment
  18. ▲ 2
    Pghero: A performance dashboard for Postgres
    story by craigkerstiens · 2017-05-06 · 0 comments
  19. Surprised the list doesn't mention PGHero ( https://github.com/ankane/pghero ). It's been really useful at our company to find slow queries and identify missing indices.
    comment by theodorton · 2017-04-29 · in Postgres tips for Rails developers
  20. ▲ 2
    Performance Dashboard for PostgreSQL
    story by utternerd · 2016-09-29 · 0 comments
  21. …on top of http://www.postgresql.org/docs/9.3/static/pgstatstatements.h... If you use Rails, there's https://github.com/ankane/pghero . Other frameworks / languages have equivalent projects, but I haven't used them. But in the end, the data…
    comment by silversmith · 2014-08-12 · in The New Heroku Postgres Database Experience
  22. ▲ 1
    Show HN: Database insights made easy
    story by akane · 2014-07-24 · 1 comment