PEV is dead, please welcome PEV2!
Laura Ricci <[email protected]> Fri, 4 Oct 2019 16:04:31 +0200
| Newsgroups | gmane.comp.db.postgresql.announce |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
--------------9AD04535AC40A24AF7B812FA
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
*PEV2, Another Query Plan Visualization Tool For PostgreSQL*
====================
PEV2 is a graphical visualization tool to understand PostgreSQL
execution plans.
**Why PEV2?**
You probably already know the simple yet excellent Depesz
<https://explain.depesz.com>. You may also have heard about PEV
<http://tatiyants.com/pev/> which is popular as well and it’s deserved.
The latter is a really great tool in my opinion but unfortunately it
hasn’t been actively maintained for more than 3 years now.
While searching for a javascript library to display an execution plan
into a monitoring tool (temBoard <https://temboard.io>), I wanted to
check if PEV could make a good candidate. It was unfortunately
impossible to use it as is. It seemed abandoned and didn’t fully match
my needs.
Thus I quickly decided to fork it. With great and quick success, given
the fact that it was really well written. Kudos to its author.
To make it very quick, the new project is written using webpack, VueJS,
Typescript, Bootstrap.
**Its main features**
* |PEV2| is able to parse an execution plan in the default format
returned by |EXPLAIN| (ie. text),
* it highlights the most relevant values for duration, cost and row
estimation factor,
* you can choose the way the graph is displayed: 2D or classic.
As the tool is improving quickly, many more features are still to come!
For more information, please visit <https://dali.bo/github_pev2> and
<https://explain.dalibo.com> <https://explain.dalibo.com/>.
Feedback & contributions are welcome!
---
PEV2 is a Dalibo Labs project created and maintained by Pierre Giraud.
Check out Dalibo's open source projects at https://labs.dalibo.com/
--
Pierre Giraud / Laura Ricci
https://www.dalibo.com/
--------------9AD04535AC40A24AF7B812FA
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<b class="moz-txt-star">*PEV2, Another Query Plan Visualization Tool
For PostgreSQL<span class="moz-txt-tag">*</span></b> <br>
<div class="moz-forward-container">
<div class="moz-text-html" lang="x-unicode">
<div class="moz-forward-container">
<p> ==================== <br>
</p>
<p><br>
</p>
<p>PEV2 is a graphical visualization tool to understand
PostgreSQL execution plans.</p>
<p><br>
</p>
<p><b>*Why PEV2?*</b></p>
<p>You probably already know the simple yet excellent <a
href="https://explain.depesz.com" moz-do-not-send="true">Depesz</a>.
You may also have heard about <a
href="http://tatiyants.com/pev/" moz-do-not-send="true">PEV</a>
which is popular as well and it’s deserved.</p>
<p>The latter is a really great tool in my opinion but
unfortunately it hasn’t been actively maintained for more
than 3 years now.</p>
<p>While searching for a javascript library to display an
execution plan into a monitoring tool (<a
href="https://temboard.io" moz-do-not-send="true">temBoard</a>),
I wanted to check if PEV could make a good candidate. It was
unfortunately impossible to use it as is. It seemed
abandoned and didn’t fully match my needs. <br>
</p>
<p>Thus I quickly decided to fork it. With great and quick
success, given the fact that it was really well written.
Kudos to its author.</p>
<p>To make it very quick, the new project is written using
webpack, VueJS, Typescript, Bootstrap.</p>
<p><br>
</p>
<p><b>*Its main features*</b></p>
<p> * <code class="highlighter-rouge">PEV2</code> is able to
parse an execution plan in the default format returned by <code
class="highlighter-rouge">EXPLAIN</code> (ie. text),</p>
<p> * it highlights the most relevant values for duration,
cost and row estimation factor,</p>
<p> * you can choose the way the graph is displayed: 2D or
classic.</p>
<p>As the tool is improving quickly, many more features are
still to come!</p>
<p><br>
</p>
For more information, please visit <a
class="moz-txt-link-rfc2396E"
href="https://dali.bo/github_pev2" moz-do-not-send="true"><https://dali.bo/github_pev2></a>
and <a href="https://explain.dalibo.com/"
moz-do-not-send="true"><https://explain.dalibo.com></a>.
<p> Feedback & contributions are welcome! <br>
<br>
--- <br>
<b class="moz-txt-star"><span class="moz-txt-tag"></span></b><span
class="moz-txt-star">PEV2</span><b class="moz-txt-star"><span
class="moz-txt-tag"></span></b> is a Dalibo Labs
project created and maintained by Pierre Giraud. <br>
Check out Dalibo's open source projects at <a
href="https://labs.dalibo.com/" moz-do-not-send="true">https://labs.dalibo.com/</a>
</p>
<pre class="moz-signature" cols="72">--
Pierre Giraud / Laura Ricci
<a class="moz-txt-link-freetext" href="https://www.dalibo.com/" moz-do-not-send="true">https://www.dalibo.com/</a></pre>
</div>
</div>
</div>
</body>
</html>
--------------9AD04535AC40A24AF7B812FA--