PostgreSQL EXPLAIN Viewer

Analyze and visualize PostgreSQL query plans.

EXPLAIN Plan Output


Limit  (cost=43.46..43.46 rows=1 width=39) (actual time=0.088..0.089 rows=1 loops=1)
  Buffers: shared hit=4
  ->  Sort  (cost=43.46..43.46 rows=1 width=39) (actual time=0.087..0.087 rows=1 loops=1)
        Sort Key: c.oid
        Sort Method: top-N heapsort  Memory: 25kB
        Buffers: shared hit=4
        ->  Nested Loop  (cost=0.29..43.45 rows=1 width=39) (actual time=0.046..0.082 rows=1 loops=1)
              Buffers: shared hit=4
              ->  Index Scan using pg_class_relname_nsp_index on pg_class c  (cost=0.29..8.31 rows=1 width=35) (actual time=0.021..0.022 rows=1 loops=1)
                    Index Cond: (((relname)::text = 'users'::text) AND (relnamespace = '2200'::oid))
                    Buffers: shared hit=3
              ->  Index Scan using pg_index_indrelid_index on pg_index i  (cost=0.00..35.12 rows=1 width=8) (actual time=0.023..0.058 rows=1 loops=1)
                    Index Cond: (indrelid = c.oid)
                    Filter: (indnatts = 1)
                    Buffers: shared hit=1

Query Plan Visualization

Your visualized plan will appear here

Enter a valid query plan on the left to see the visualization.

About the PostgreSQL EXPLAIN Viewer

A tool to help developers visualize and understand PostgreSQL's EXPLAIN plans. It turns the complex text output into an interactive, hierarchical view, making it easier to spot performance bottlenecks like sequential scans or costly joins.

Raw EXPLAIN ANALYZE output from PostgreSQL is powerful but can be incredibly difficult to read, especially for complex queries. This visualizer untangles that output, showing the query plan as a nested tree. You can quickly see which nodes are most expensive in terms of time and cost, identify inefficient operations, and understand how your query is actually being executed by the database engine. It saves a massive amount of time when tuning queries.

PostgreSQL EXPLAIN Viewer

EXPLAIN Plan Output

Query Plan Visualization

Why Use This Tool?

How to Use It

When to Use It