explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6f1a

Settings
# exclusive inclusive rows x rows loops node
1. 1,000.423 1,436.243 ↑ 1.0 2,998,650 1

Hash Join (cost=21,413.00..104,729.01 rows=2,998,650 width=16) (actual time=127.469..1,436.243 rows=2,998,650 loops=1)

  • Hash Cond: (ol.orderid = o.orderid)
2. 311.381 311.381 ↑ 1.0 2,998,650 1

Seq Scan on orderlines ol (cost=0.00..49,086.50 rows=2,998,650 width=8) (actual time=0.028..311.381 rows=2,998,650 loops=1)

3. 73.119 124.439 ↑ 1.0 600,000 1

Hash (cost=10,983.00..10,983.00 rows=600,000 width=12) (actual time=124.439..124.439 rows=600,000 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 2636kB
4. 51.320 51.320 ↑ 1.0 600,000 1

Seq Scan on orders o (cost=0.00..10,983.00 rows=600,000 width=12) (actual time=0.007..51.320 rows=600,000 loops=1)