Simple. Fast. Useful.

Choose your tool

DEVELOPER TOOL

PostgreSQL Query Plan Viewer

Inspect pasted PostgreSQL EXPLAIN JSON, expand the plan tree and compare estimates with actual rows.

â—‡ Browser only
0 lines · 0 characters
Ready when you are
Your results will appear here.
Copy or download your result below.

Your text stays on this device.

Favorites
Recently used
LESS BUSYWORK, MORE DONE

Three steps. That’s it.

A useful toolkit for text, data, images and calculations.

  1. 01

    Add your input

    Choose a tool, enter values or select a file.

  2. 02

    Make it yours

    Adjust the options and run the action.

  3. 03

    Take the result

    Copy the result or download its file.

Postgres EXPLAIN plan viewer online

Inspect estimates and actual rows in a PostgreSQL EXPLAIN JSON plan. A plan describes its recorded execution; it does not automatically choose indexes or fix production performance.

How to use it

Enter the source input or select Try example. Review the displayed input. Select Run tool and inspect the result before copying or downloading.

Worked examples

Inspect estimates and actual rows in a PostgreSQL EXPLAIN JSON plan.

Worked example — PostgreSQL Query Plan Viewer

Settings: No additional options

Input:

[{"Plan":{"Node Type":"Seq Scan","Relation Name":"users","Total Cost":125,"Plan Rows":1000,"Actual Rows":1200,"Actual Total Time":4.5,"Actual Loops":1,"Shared Hit Blocks":100},"Planning Time":0.2,"Execution Time":4.8}]

Output:

Planning: 0.2 ms
Execution: 4.8 ms

Seq Scan on users | cost 125 | rows estimated 1000, actual 1200 | actual/estimate 1.20 | inclusive time/loop 4.5 ms | loops 1

The example output has 4 lines. Compare its order, separators and whitespace with the input before copying the result.

Limitations and common mistakes

  • A plan describes its recorded execution; it does not automatically choose indexes or fix production performance.

Frequently asked questions

How can I inspect a PostgreSQL query plan online?

Enter the source input or select Try example. Review the displayed input. Select Run tool and inspect the result before copying or downloading.

Where is my input processed?

The bundled tool processes input in your browser. It does not upload tool input to a conversion service. Other site plugins, analytics, advertising and browser extensions may have separate behavior.

Useful next tools

Explore other tools

Open a tool below, use the search, or choose a category to browse its full collection.