explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GFRgz

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

Nested Loop (cost=4.33..118.28 rows=3 width=488) (actual rows= loops=)

  • Join Filter: (t1.hundred < t2.hundred)
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on tenk1 t1 (cost=4.33..39.44 rows=10 width=244) (actual rows= loops=)

  • Recheck Cond: (unique1 < 10)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tenk1_unique1 (cost=0.00..4.33 rows=10 width=0) (actual rows= loops=)

  • Index Cond: (unique1 < 10)
4. 0.000 0.000 ↓ 0.0

Index Scan using tenk2_unique2 on tenk2 t2 (cost=0.00..7.87 rows=1 width=244) (actual rows= loops=)

  • Index Cond: (unique2 = t1.unique2)