explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1v7X

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

Nested Loop (cost=61,990.020..779,097.970 rows=237 width=26) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=61,989.460..778,144.660 rows=208 width=24) (actual rows= loops=)

  • Join Filter: (hotel_quebec.kilo = five.oscar_zulu_charlie)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=61,989.020..332,242.650 rows=128,293 width=12) (actual rows= loops=)

  • Hash Cond: (hotel_quebec.two = lima.quebec_seven)
  • Join Filter: ((lima.bravo - lima.alpha_oscar) >= quebec_sierra.mike_four)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=61,467.510..324,497.330 rows=386,837 width=21) (actual rows= loops=)

  • Hash Cond: (quebec_sierra.oscar_zulu_charlie = hotel_quebec.kilo)
  • Join Filter: ((hotel_quebec.echo - hotel_quebec.delta) >= quebec_sierra.mike_four)
5. 0.000 0.000 ↓ 0.0

Seq Scan on yankee quebec_sierra (cost=0.000..222,640.760 rows=1,197,176 width=9) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=40,161.130..40,161.130 rows=1,160,510 width=20) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on alpha_kilo hotel_quebec (cost=0.000..40,161.130 rows=1,160,510 width=20) (actual rows= loops=)

  • Filter: ((echo - delta) <> 'november'::numeric)
8. 0.000 0.000 ↓ 0.0

Hash (cost=506.770..506.770 rows=1,179 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on hotel_five lima (cost=0.000..506.770 rows=1,179 width=16) (actual rows= loops=)

  • Filter: ((bravo - alpha_oscar) <> 'november'::numeric)
10. 0.000 0.000 ↓ 0.0

Index Scan using oscar_november on oscar_zulu_golf five (cost=0.440..3.460 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (oscar_zulu_charlie = quebec_sierra.oscar_zulu_charlie)
  • Filter: mike_alpha
11. 0.000 0.000 ↓ 0.0

Index Scan using hotel_six on golf quebec_three (cost=0.560..4.570 rows=1 width=22) (actual rows= loops=)

  • Index Cond: ((kilo = five.oscar_zulu_charlie) AND (india = five.juliet))