When working with PostgreSQL, you can use pgAdmin as a GUI.
While you can do most things just like on an SQL console, you can use it to display EXPLAIN results in a more human-readable way.

Growing Rails Applications in Practice

Check out our e-book. Learn to structure large Ruby on Rails codebases with the tools you already know and love.

• Introduce design conventions for controllers and user-facing models
• Create a system for growth
• Build applications to last

Read more Show archive.org snapshot

(image from the Postgres manual)

1. Open up pgAdmin, connect to your server
2. Pick a database from the left pane
3. Click the "SQL" icon in the toolbar, or press Ctrl+E to open the query tool.
4. Paste any queries that you'd like to explain.
5. Go to "Query" → "Explain analyze", or press Shift+F7.

For more information see the docs.