explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dbkq

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

Limit (cost=76,059.550..76,071.780 rows=30 width=1,148) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=76,059.550..158,852.650 rows=203,074 width=1,148) (actual rows= loops=)

  • Hash Cond: (november_mike.zulu_papa = three_four.zulu_papa)
  • Join Filter: (three_four.golf < november_mike.golf)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.730..78,555.660 rows=304,611 width=1,148) (actual rows= loops=)

  • Hash Cond: (november_mike.delta = three_golf.delta)
4. 0.000 0.000 ↓ 0.0

Seq Scan on three_four november_mike (cost=0.000..73,857.850 rows=439,994 width=1,111) (actual rows= loops=)

  • Filter: ((mike = 1) AND (delta <> november_november ('november_kilo'::integer[])) AND ((NOT papa_papa) OR (papa_papa AND (papa_tango < (zulu_golf() - 'november_zulu'::interval)))))
5. 0.000 0.000 ↓ 0.0

Hash (cost=1.390..1.390 rows=27 width=41) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on hotel three_golf (cost=0.000..1.390 rows=27 width=41) (actual rows= loops=)

  • Filter: (oscar five_romeo NOT NULL)
7. 0.000 0.000 ↓ 0.0

Hash (cost=70,557.900..70,557.900 rows=439,994 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on three_four (cost=0.000..70,557.900 rows=439,994 width=16) (actual rows= loops=)

  • Filter: ((mike <> november_november ('five_echo'::integer[])) AND (delta <> november_november ('november_kilo'::integer[])))