How to identify missing indexes in PostgreSQL

This might sound familiar to you: You join a new project with existing applications. The application and database schema does not look overwhelmingly complex. Yes, the queries span across multiple tables, but nothing unusual. Anyways, the query perf...