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.

Rails Long Term Support

Rails LTS provides security patches for old versions of Ruby on Rails (2.3, 3.2, 4.2 and 5.2)

• Prevents you from data breaches and liability risks
• Upgrade at your own pace
• Works with modern Rubies

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.