explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CagF

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

Nested Loop (cost=4.65..118.62 rows=10 width=488) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on tenk1 t1 (cost=4.36..39.47 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.36 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.29..7.91 rows=1 width=244) (actual rows= loops=)

  • Index Cond: (unique2 = t1.unique2)