explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ojuA : Optimization for: plan #9JfW

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Merge Join (cost=0.56..292.65 rows=10 width=488) (actual rows= loops=)

  • Merge Cond: (t1.unique2 = t2.unique2)
2. 0.000 0.000 ↓ 0.0

Index Scan using tenk1_unique2 on tenk1 t1 (cost=0.29..656.28 rows=101 width=244) (actual rows= loops=)

  • Filter: (unique1 < 100)
3. 0.000 0.000 ↓ 0.0

Index Scan using onek_unique2 on onek t2 (cost=0.28..224.79 rows=1,000 width=244) (actual rows= loops=)