DtSQL mentions (0)

PgHero mentions (7)

• 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 / about 2 months 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: 11 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: about 1 year 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