PEV2: A VueJS component to show a graphical vizualization of a PostgreSQL execution plan.
Usage
To use the explain vizualizer you can choose one of the following options:
Dalibo service (recommended)
This service is provided by Dalibo
and can help you to share your plans with
colleagues or customers.
All-in-one local (no installation, no network)
PEV2 can be run locally without any external internet resource.
Simply download index.html, open it in your favorite internet browser.
Integrated in a web application
Without building tools
<script src="https://unpkg.com/[email protected]/dist/vue.global.prod.js"></script>
<script src="https://unpkg.com/pev2/dist/pev2.umd.js"></script>
<link
href="https://unpkg.com/[email protected]/dist/css/bootstrap.min.css"
rel="stylesheet"
/>
<link rel="stylesheet" href="https://unpkg.com/pev2/dist/style.css" />
<div id="app">
<pev2 :plan-source="plan" plan-query="" />
</div>
<script>
const { createApp } = Vue
const plan = "Seq Scan on foo (cost=0.00..155.00 rows=10000 width=4)"
const app = createApp({
data() {
return {
plan: plan,
}
},
})
app.component("pev2", pev2.Plan)
app.mount("#app")
</script>
For a complete example, see this codesandbox
With build tools
PEV2 can be integrated as a component in a web application.
Install it:
npm install pev2
Declare the PEV2
component and use it:
import { Plan } from "pev2"
import "pev2/dist/style.css"
export default {
name: "PEV2 example",
components: {
pev2: Plan,
},
data() {
return {
plan: plan,
query: query,
}
},
}
Then add the PEV2
component to your template:
<div id="app">
<pev2 :plan-source="plan" :plan-query="query"></pev2>
</div>
PEV2
requires Bootstrap (CSS)
to work so don't forget to
add the following in you header (or load them with your favorite bundler).
<link
href="https://unpkg.com/[email protected]/dist/css/bootstrap.min.css"
rel="stylesheet"
/>
For a complete example, see this codesandbox.
Disclaimer
This project is a rewrite of the excellent Postgres Explain Visualizer (pev). Kudos go to Alex Tatiyants.
The pev project was initialy written in early 2016 but seems to be abandoned since then. There was no activity at all for more than 3 years and counting though there are several issues open and relevant pull requests pending.