Pangea | Developer Advocate | Platform Engineer - AuthZ/AuthN | Full Time | Palo Alto & Remote We're Pangea, a well-funded Series B startup led by veterans of the security industry and have raised over $52M in funding from Google Ventures, Ballistic Ventures, SYN Ventures, Decibel, and Okta Ventures. We are a product-led company, whose mission is to deliver an amazing product built specifically for developers. ... - Source: Hacker News / 7 months ago

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

I use either PgHero or Rails PG Extras on every project. Source: 11 months 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 1 year 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 2 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 2 years ago