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
20082026
-
…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 -
…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 -
…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 -
…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 -
…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 -
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 -
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 -
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 -
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 -
Related. https://github.com/ankane/pghero
comment by whycombagator · 2019-11-06 · in Postgres Health Check and SQL Performance Analysis -
…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) -
…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 -
…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 -
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 -
…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