explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oEJv

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

Hash Join (cost=1.04..17.64 rows=5 width=256) (actual rows= loops=)

  • Output: t.id, t.name, t2.id, t2.name
  • Inner Unique: true
  • Hash Cond: (t2.id = t.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

Hash (cost=1.02..1.02 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