explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZuSI : Optimization for: test; plan #eH2o

Settings

Optimization path:

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

Hash Join (cost=4,707.82..6,464.87 rows=60,043 width=21) (actual rows= loops=)

  • Hash Cond: (kilo_foxtrot.india = kilo_hotel.quebec)
2. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey kilo_foxtrot (cost=0.00..1,599.43 rows=60,043 width=12) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=3929.03..3929.03 rows=62303 width=21)" -> Seq Scan on "user" u (cost=0.00..3,929.03 rows=62,303 width=21) (actual rows= loops=)