I can completely see myself using this on my Postgres projects, but something li... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

beefsack on July 23, 2017 | parent | context | favorite | on: Pev: Postgres ‘Explain’ Visualizer (2016)

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.

johannes1234321 on July 23, 2017 | [–]

Not 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-explai...

linux2647 on July 23, 2017 | [–]

I 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

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact