0

Is there a way to create MySQL Workbench query plan image from command line or terminal and save it as an image something like this?

enter image description here

I checked the MySQL Workbench documentation here, https://dev.mysql.com/doc/workbench/en/wb-command-line-options.html. But don't see any such option. So, is there a hack or even a separate tool to create this image? Any help on this would be greatly appreciated.

Stranger
  • 10,332
  • 18
  • 78
  • 115
  • 1
    See SchemaCrawler http://sualeh.github.io/SchemaCrawler/diagramming.html – matrix Sep 05 '17 at 09:55
  • SchemaCrawler is the wrong answer. It's a tool to document a db structure. The question however is about visual explain (optimizer planning), which is a special feature in MySQL Workbench (JSON explain data is visualized in a graph). – Mike Lischke Sep 06 '17 at 06:43

1 Answers1

0

There is no such option in MySQL Workbench. The tool is a GUI application and as such not well suited for command line work. Maybe you can find a tool that can take the JSON output of EXPLAIN and builds a graphic from that.

Mike Lischke
  • 48,925
  • 16
  • 119
  • 181