Chambéry, 4 October 2019
PEV is dead, please welcome PEV2!
PEV2 is a graphical visualization tool to understand PostgreSQL execution plans.
The latter is a really great tool in my opinion but unfortunately it hasn’t been actively maintained for more than 3 years now.
The result can be seen at explain.dalibo.com.
To make it very quick, the new project is written using webpack, VueJS, Typescript, Bootstrap.
VueJS? Well, it’s just a matter of personal taste.
PEV2 Can Parse TEXT Format!
Though still to be improved,
PEV2 is able to parse an execution plan in the
default format returned by
EXPLAIN (ie. text).
Instead of only showing the slowest, costliest or largest node. I decided to imitate what Depesz does by highlighting the most relevant values for duration, cost and row estimation factor using thresholds and a color palette going from to .
With PEV2, you can choose the way the graph is displayed: 2D or classic. This is your preference.
To be continued…
That’s already a lot. But stay tuned. There will be other posts to go into more details.
Reminder: you can already play with it on explain.dalibo.com.
Want to contribute or built it for your own needs? The code is free to use and is on github.