explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XD8A : test2

Settings

Optimization path:

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

Merge Join (cost=1.25..11,833.68 rows=60,043 width=1,223) (actual rows= loops=)

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

Index Scan using zulu on whiskey kilo_foxtrot (cost=0.29..2,574.42 rows=60,043 width=530) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using seven on five kilo_hotel (cost=0.41..8,352.97 rows=62,303 width=705) (actual rows= loops=)