1.24.0 • Published 1 month ago
pev2-cli v1.24.0
pev2-cli
Run the PostgreSQL Explain Visualizer 2 (pev2) from the command line.
Installation
npm install -g pev2-cli
Usage
Usage:
pev2 <path-to-query-file> [path-to-execution-plan]
Notes:
This tool uses the pev2 to visualize PostgreSQL's execution plan including
costs associated to each operation.
more info: https://www.postgresql.org/docs/14/using-explain.html
To let PostgreSQL generate the plan, prefix it with the following line:
EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS, FORMAT JSON)
If you don't pass an execution plan, this tool will spawn `psql` to run the
the query. Use the `PG*` environment variables to make sure `psql` can
connect to the right database.
more info: https://www.postgresql.org/docs/14/libpq-envars.html
Options:
--open -o Open the URL in the browser.
--app The browser to open the URL with.
--quiet -q Don't report what's going on.
--once -1 Stop serving after pev2 has received the data.
--name -n Give the execution plan a name within pev2.
Default: filename and ISO date+time
Examples:
pev2 --open --app firefox -q path/to/some-explain-query.sql
Contributing
If you have a question or need support using pev2-cli
, please double-check your code and setup first. If you think you have found a bug or want to propose a feature, use the issues page.
1.24.0
1 month ago
1.23.0
2 months ago
1.22.0
3 months ago
1.21.0
8 months ago
1.20.1
8 months ago
1.19.0
1 year ago
1.20.0
1 year ago
1.18.0
1 year ago
1.17.0
2 years ago
1.16.0
2 years ago
1.15.0
2 years ago
1.14.0
2 years ago
1.13.0
2 years ago
1.12.0
2 years ago
1.11.0
2 years ago
1.10.0
3 years ago
1.9.0
3 years ago
1.8.0
3 years ago
1.7.0
3 years ago
1.6.0
3 years ago
1.5.0
3 years ago
1.4.1
3 years ago
1.4.0
3 years ago
1.3.0
3 years ago
1.2.0
3 years ago
1.1.0
3 years ago
1.0.0
4 years ago