Skip to content

Run the PostgreSQL Explain Visualizer 2 (pev2) from the command line.

License

Notifications You must be signed in to change notification settings

derhuerst/pev2-cli

Repository files navigation

pev2-cli

Run the PostgreSQL Explain Visualizer 2 (pev2) from the command line.

npm version ISC-licensed minimum Node.js version support me via GitHub Sponsors chat with me on Twitter

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.