Table of contents
PgHero
Rails database insights made easy. Add the gem, get a dashboard with long running queries, cache hit rate, and more.
As PgHero is an open source project, you can find more
open source alternatives and stats
on LibHunt.
We have collected here some useful links to help you find out if PgHero is good.
Check the traffic stats of PgHero on SimilarWeb. The key metrics to look for are: monthly visits, average visit duration, pages per visit, and traffic by country. Moreoever, check the traffic sources. For example "Direct" traffic is a good sign.
Check the "Domain Rating" of PgHero on Ahrefs. The domain rating is a measure of the strength of a website's backlink profile on a scale from 0 to 100. It shows the strength of PgHero's backlink profile compared to the other websites. In most cases a domain rating of 60+ is considered good and 70+ is considered very good.
Check the "Domain Authority" of PgHero on MOZ. A website's domain authority (DA) is a search engine ranking score that predicts how well a website will rank on search engine result pages (SERPs). It is based on a 100-point logarithmic scale, with higher scores corresponding to a greater likelihood of ranking. This is another useful metric to check if a website is good.
The latest comments about PgHero on Reddit. This can help you find out how popualr the product is and what people think about it.
The screenshot section in the README seems to be empty. Would've been interesting to see that. There's many tools that do similar things like https://github.com/ankane/pghero. - Source: Hacker News / over 1 year ago
For our production PGSQL databases, we use a combination of PGTuner[0] to help estimate RAM requirements and PGHero[1] to get a live view of the running DB. Furthermore, we use ZFS with the built-in compression to save disk space. Together, these three utilities help keep our DBs running very well. [0] https://pgtune.leopard.in.ua [1] https://github.com/ankane/pghero. - Source: Hacker News / almost 2 years ago
I am using https://github.com/ankane/pghero/ and this is one of its features with GUI. - Source: Hacker News / about 2 years ago
I use either PgHero or Rails PG Extras on every project. Source: almost 3 years ago
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: about 3 years ago
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 4 years ago
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 4 years ago
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 4 years ago
I know others can answer this better but we use a combination of PgHero and logging of slow queries trough jOOQ. Source: about 5 years ago
Do you know an article comparing PgHero to other products?
Suggest a link to a post with product alternatives.
Is PgHero good? This is an informative page that will help you find out. Moreover, you can review and discuss PgHero here. The primary details have not been verified within the last quarter, and they might be outdated. If you think we are missing something, please use the means on this page to comment or suggest changes. All reviews and comments are highly encouranged and appreciated as they help everyone in the community to make an informed choice. Please always be kind and objective when evaluating a product and sharing your opinion.
