pgAdmin has a "graphical EXPLAIN" feature

Posted . Visible to the public.

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.


(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.

Arne Hartherz
Last edit
Tobias Kraze
License
Source code in this card is licensed under the MIT License.
Posted by Arne Hartherz to makandra dev (2015-09-29 10:11)