explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jMue

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.006 19.042 ↑ 1.0 1 1

Unique (cost=1.690..2,304.320 rows=1 width=417) (actual time=18.997..19.042 rows=1 loops=1)

2. 0.062 19.036 ↑ 4.0 1 1

Nested Loop Left Join (cost=1.690..2,304.320 rows=4 width=417) (actual time=18.992..19.036 rows=1 loops=1)

  • Join Filter: ((foxtrot_two.alpha_oscar = hotel_mike.alpha_oscar) OR (hotel_mike.alpha_oscar = mike_seven_four.alpha_oscar))
  • Rows Removed by Join Filter: 6
3. 0.043 18.900 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.690..2,302.930 rows=2 width=385) (actual time=18.868..18.900 rows=1 loops=1)

  • Join Filter: ((mike_seven_four.quebec_seven = five_delta.seven) OR (mike_seven_four.quebec_seven = lima_charlie.five_papa))
  • Rows Removed by Join Filter: 106
4. 0.004 18.814 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.690..2,297.260 rows=1 width=369) (actual time=18.785..18.814 rows=1 loops=1)

  • Join Filter: (alpha_kilo.quebec_seven = alpha_bravo.five_lima)
5. 0.003 18.805 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.690..2,286.360 rows=1 width=295) (actual time=18.776..18.805 rows=1 loops=1)

  • Join Filter: (whiskey_romeo.quebec_seven = alpha_bravo.quebec_three)
6. 0.010 18.792 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.690..2,275.680 rows=1 width=221) (actual time=18.764..18.792 rows=1 loops=1)

7. 0.124 18.778 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.410..2,273.180 rows=1 width=197) (actual time=18.750..18.778 rows=1 loops=1)

  • Join Filter: ((charlie_november.xray_three)::text = (sierra_papa.whiskey_juliet)::text)
  • Rows Removed by Join Filter: 450
8. 0.006 18.488 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.410..2,255.050 rows=1 width=181) (actual time=18.461..18.488 rows=1 loops=1)

  • Join Filter: (alpha_bravo.quebec_seven = charlie_november.delta_four)
9. 0.004 0.364 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.410..14.060 rows=1 width=160) (actual time=0.338..0.364 rows=1 loops=1)

  • Join Filter: (five_delta.quebec_seven = india.xray_uniform)
  • Rows Removed by Join Filter: 1
10. 0.005 0.350 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.410..13.040 rows=1 width=149) (actual time=0.325..0.350 rows=1 loops=1)

11. 0.004 0.336 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.270..12.850 rows=1 width=105) (actual time=0.317..0.336 rows=1 loops=1)

12. 0.011 0.321 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.130..10.480 rows=1 width=96) (actual time=0.304..0.321 rows=1 loops=1)

13. 0.003 0.219 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.700..7.820 rows=1 width=84) (actual time=0.206..0.219 rows=1 loops=1)

  • Join Filter: (india.foxtrot_hotel = alpha_bravo.quebec_seven)
14. 0.005 0.199 ↑ 1.0 1 1

Nested Loop (cost=0.700..6.260 rows=1 width=80) (actual time=0.188..0.199 rows=1 loops=1)

15. 0.016 0.184 ↑ 1.0 1 1

Nested Loop (cost=0.420..3.750 rows=1 width=56) (actual time=0.176..0.184 rows=1 loops=1)

  • Join Filter: ((alpha_bravo.tango_yankee)::text = (mike_zulu.tango_yankee)::text)
  • Rows Removed by Join Filter: 4
16. 0.148 0.148 ↑ 1.0 1 1

Index Scan using uniform_india on tango_sierra alpha_bravo (cost=0.420..2.640 rows=1 width=49) (actual time=0.147..0.148 rows=1 loops=1)

  • Index Cond: (quebec_seven = 189956)
17. 0.020 0.020 ↑ 1.0 5 1

Seq Scan on delta_india mike_zulu (cost=0.000..1.050 rows=5 width=11) (actual time=0.017..0.020 rows=5 loops=1)

18. 0.010 0.010 ↑ 1.0 1 1

Index Scan using four_zulu on foxtrot_romeo hotel_oscar (cost=0.280..2.500 rows=1 width=28) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (quebec_seven = alpha_bravo.victor_four)
19. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on bravo_three india (cost=0.000..1.550 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Filter: (foxtrot_hotel = 189956)
  • Rows Removed by Filter: 44
20. 0.091 0.091 ↑ 1.0 1 1

Index Scan using lima_delta on echo quebec_november (cost=0.420..2.640 rows=1 width=22) (actual time=0.089..0.091 rows=1 loops=1)

  • Index Cond: ((alpha_bravo.juliet = juliet) AND ((alpha_bravo.mike_seven_romeo)::text = (mike_seven_romeo)::text))
21. 0.011 0.011 ↑ 1.0 1 1

Index Scan using sierra_golf on delta_tango lima_charlie (cost=0.140..2.360 rows=1 width=13) (actual time=0.009..0.011 rows=1 loops=1)

  • Index Cond: (quebec_seven = alpha_bravo.lima_bravo)
22. 0.009 0.009 ↑ 1.0 1 1

Index Scan using zulu on bravo_victor foxtrot_two (cost=0.140..0.180 rows=1 width=48) (actual time=0.006..0.009 rows=1 loops=1)

  • Index Cond: (quebec_seven = lima_charlie.five_papa)
23. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on five_charlie five_delta (cost=0.000..1.010 rows=1 width=19) (actual time=0.010..0.010 rows=1 loops=1)

24. 18.118 18.118 ↓ 0.0 0 1

Seq Scan on victor_delta charlie_november (cost=0.000..2,240.980 rows=1 width=25) (actual time=18.118..18.118 rows=0 loops=1)

  • Filter: (delta_four = 189956)
  • Rows Removed by Filter: 112198
25. 0.166 0.166 ↑ 1.0 450 1

Seq Scan on victor_five sierra_papa (cost=0.000..12.500 rows=450 width=33) (actual time=0.040..0.166 rows=450 loops=1)

26. 0.004 0.004 ↓ 0.0 0 1

Index Scan using four_zulu on foxtrot_romeo mike_golf (cost=0.280..2.500 rows=1 width=28) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (charlie_november.uniform_echo = quebec_seven)
27. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on four_romeo whiskey_romeo (cost=0.000..10.300 rows=30 width=82) (actual time=0.010..0.010 rows=0 loops=1)

28. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on charlie_five alpha_kilo (cost=0.000..10.400 rows=40 width=82) (actual time=0.005..0.005 rows=0 loops=1)

29. 0.043 0.043 ↑ 1.0 107 1

Seq Scan on bravo_victor mike_seven_four (cost=0.000..4.070 rows=107 width=20) (actual time=0.012..0.043 rows=107 loops=1)

30. 0.054 0.074 ↑ 1.0 7 1

Materialize (cost=0.000..1.110 rows=7 width=12) (actual time=0.067..0.074 rows=7 loops=1)

31. 0.020 0.020 ↑ 1.0 7 1

Seq Scan on five_two hotel_mike (cost=0.000..1.070 rows=7 width=12) (actual time=0.017..0.020 rows=7 loops=1)

Planning time : 15.550 ms
Execution time : 19.663 ms