Postgres execution plan image

Question

is it possible to generate an execution plan in Postgres like the one in MySQL below? thanks

In almost all cases the text representation is much more detailed and (in my opinion) easier to read. Most (if not all) of the image visualizations I know for Postgres (or Oracle for that matter) hide many of the important details. That's not so much the case with MySQL as its execution plan is far less detailed. Do try to learn the plan that you get when you just run explain or explain (analyze). It is worth the effort — user330315
– user330315, Commented Jun 4, 2018 at 6:41

Pavel Stehule · Accepted Answer · 2018-06-04 07:47:05Z

3

Yes, it is possible. pgAdmin does execution plan visualisation. Same possibility has OmniDB. There is a tool for visualisation plan based on result of Postgres's EXPLAIN command in JSON format Postgres EXPLAIN Visualizer. You can write own tool too, because Postgres can export plans in XML, JSON or YAML format.

edited Jun 4, 2018 at 7:47

answered Jun 4, 2018 at 5:55

Pavel Stehule

46.7k6 gold badges103 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres execution plan image

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related