explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 52jZ

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

Nested Loop (cost=0.00..31.80 rows=5 width=256) (actual rows= loops=)

  • Output: t.id, t.name, t2.id, t2.name
  • Inner Unique: true
  • Join Filter: (t.id = t2.id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on schema0.test2 t2 (cost=0.00..15.20 rows=520 width=128) (actual rows= loops=)

  • Output: t2.id, t2.name
3. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.03 rows=2 width=128) (actual rows= loops=)

  • Output: t.id, t.name
4. 0.000 0.000 ↓ 0.0

Seq Scan on schema0.test t (cost=0.00..1.02 rows=2 width=128) (actual rows= loops=)

  • Output: t.id, t.name