SQL EXPLAIN Explainer

Paste a Postgres EXPLAIN (ANALYZE) or MySQL EXPLAIN plan, as text, table or JSON, and see the plan tree with cost and time bars and plain-English advice on the slow parts.

Plan

Sort  (cost=18234.52..18259.52 rows=10000 width=48) (actual time=412.337..498.120 rows=184233 loops=1)
  Sort Key: o.created_at DESC
  Sort Method: external merge  Disk: 9872kB
  ->  Hash Join  (cost=1245.00..17570.13 rows=10000 width=48) (actual time=12.410..301.556 rows=184233 loops=1)
        Hash Cond: (o.customer_id = c.id)
        ->  Seq Scan on orders o  (cost=0.00..15406.00 rows=500000 width=40) (actual time=0.011..142.876 rows=498211 loops=1)
              Filter: (status = 'paid'::text)
              Rows Removed by Filter: 1789
        ->  Hash  (cost=1120.00..1120.00 rows=10 width=16) (actual time=12.301..12.302 rows=9800 loops=1)
              Buckets: 16384  Batches: 1  Memory Usage: 588kB
              ->  Nested Loop  (cost=0.29..1120.00 rows=10 width=16) (actual time=0.030..10.880 rows=9800 loops=1)
                    ->  Seq Scan on regions r  (cost=0.00..1.05 rows=1 width=4) (actual time=0.005..0.007 rows=1 loops=1)
                          Filter: (code = 'EU'::text)
                    ->  Index Scan using customers_region_id_idx on customers c  (cost=0.29..1118.85 rows=10 width=20) (actual time=0.020..9.901 rows=9800 loops=1)
                          Index Cond: (region_id = r.id)
Planning Time: 0.412 ms
Execution Time: 512.904 ms

Findings

Plan tree

Keyboard shortcuts

SQL EXPLAIN Explainer

Was this tool useful?