4 ms·
I can completely see myself using this on my Postgres projects, but something like this would be most useful for me at work. How feasible would it be to port t
by beefsack 9y ago
I can completely see myself using this on my Postgres projects, but something like this would be most useful for me at work.
How feasible would it be to port this over to MySQL / MariaDB? I know EXPLAIN output on MySQL is much simpler than what you get out of Postgres so my gut feeling would be that it wouldn't be possible.
- linux2647 9y agoI would imagine that as long as you could get a JSON representation of the plan, Pev could consume it. Edit: looks like MySQL can output it as JSON: https://dev.mysql.com/doc/refman/5.7/en/explain-output.html https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
- johannes1234321 9y agoNot exactly the same, but if you run MySQL Workbench as GUI there's a visual explain feature built around MySQL's JSON explain: https://dev.mysql.com/doc/workbench/en/wb-performance-explain.html https://dev.mysql.com/doc/workbench/en/wb-performance-explai...