explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uFqK : Optimization for: plan #R7wB

Settings

Optimization path:

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

Nested Loop (cost=27.19..67,719.64 rows=5,227,875 width=119) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on products (cost=0.00..2,313.45 rows=7,745 width=99) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Materialize (cost=27.19..59.44 rows=675 width=20) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=27.19..56.06 rows=675 width=20) (actual rows= loops=)

  • Hash Cond: (merchants.name = merchants_1.name)