PgHero Reviews and details

Social recommendations and mentions

• Show HN: PostgreSQL Index Advisor

  I am using https://github.com/ankane/pghero/ and this is one of its features with GUI. - Source: Hacker News / 15 days ago

• What are your favourite approaches to keeping on top of Postgres health?

  I use either PgHero or Rails PG Extras on every project. Source: 10 months ago

• Slow query. Should add indexes?

  There are tools available which can look at your Postgres logs and tell you if you need to add indexes, I've used https://github.com/ankane/pghero before and it seems decent. Source: 12 months ago

• How and why Relational Model works for databases

  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. - Source: Hacker News / over 2 years ago

• Check why Django app is slow in production

  If you are using PostgreSQL you can enable logging of slow queries and connect to the server with pghero (https://github.com/ankane/pghero) and check top queries by the number of requests and total usage time. Also, you can just enable logging of queries in Django, and on each request, you will have a list of queries on development, sometimes it's just a missing select_related of prefetch_related to increase... Source: over 2 years ago

• Tips for a Healthier Postgres Database

  If you are using rails, pghero is a great gem to get better visibility on your Postgres performance https://github.com/ankane/pghero. - Source: Hacker News / over 2 years ago

• PostgreSQL for Java Developer

  I know others can answer this better but we use a combination of PgHero and logging of slow queries trough jOOQ. Source: about 3 years ago