When working on performance with Postgres the EXPLAIN tool is incredibly useful. Sometimes the raw output from this is a bit hard to read. Recently I've come across a tool that creates a highly readable output of this:

https://explain.depesz.com/