explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B8eq : Optimization for: Optimization for: plan #gWgH; plan #lj5Ms

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.319 108.753 ↑ 1.5 169 1

Limit (cost=17,133.24..17,263.87 rows=250 width=554) (actual time=98.065..108.753 rows=169 loops=1)

2. 10.570 108.434 ↑ 17.9 169 1

Result (cost=17,133.24..18,717.46 rows=3,032 width=554) (actual time=98.064..108.434 rows=169 loops=1)

3. 0.271 97.864 ↑ 17.9 169 1

Sort (cost=17,133.24..17,140.82 rows=3,032 width=557) (actual time=97.803..97.864 rows=169 loops=1)

  • Sort Key: lima_delta1.mike_seven, lima_delta1.november
  • Sort Method: quicksort Memory: 187kB
4. 0.114 97.593 ↑ 17.9 169 1

Hash Left Join (cost=2,123.43..16,997.32 rows=3,032 width=557) (actual time=45.936..97.593 rows=169 loops=1)

  • Hash Cond: (echo_seven1.delta_kilo = alpha_seven1.quebec_seven)
5. 0.515 87.680 ↑ 17.9 169 1

Hash Left Join (cost=1,848.93..16,714.83 rows=3,032 width=1,134) (actual time=36.122..87.680 rows=169 loops=1)

  • Hash Cond: (echo_seven1.four_delta = kilo_foxtrot2.quebec_seven)
6. 0.198 73.183 ↑ 17.9 169 1

Nested Loop Left Join (cost=1,643.63..16,501.55 rows=3,032 width=1,073) (actual time=22.129..73.183 rows=169 loops=1)

7. 0.128 72.140 ↑ 17.8 169 1

Nested Loop Left Join (cost=1,643.20..8,842.75 rows=3,000 width=1,049) (actual time=22.116..72.140 rows=169 loops=1)

  • Join Filter: (lima_delta1.juliet_hotel = india1.yankee_zulu)
8. 0.110 72.012 ↑ 17.8 169 1

Hash Left Join (cost=1,643.20..8,796.68 rows=3,000 width=1,057) (actual time=22.101..72.012 rows=169 loops=1)

  • Hash Cond: (lima_delta1.quebec_seven = zulu1.sierra_foxtrot)
9. 0.139 69.671 ↑ 17.8 169 1

Hash Left Join (cost=1,151.26..8,289.74 rows=3,000 width=390) (actual time=19.859..69.671 rows=169 loops=1)

  • Hash Cond: ((lima_delta1.juliet_hotel = alpha_oscar1.foxtrot_charlie) AND (kilo_foxtrot1.quebec_seven = alpha_oscar1.uniform_bravo))
10. 0.140 69.091 ↑ 17.8 169 1

Hash Left Join (cost=952.82..8,075.53 rows=3,000 width=354) (actual time=19.403..69.091 rows=169 loops=1)

  • Hash Cond: (lima_delta1.lima_echo = kilo_foxtrot1.quebec_seven)
11. 0.497 53.607 ↑ 17.8 169 1

Hash Left Join (cost=345.25..7,460.08 rows=3,000 width=295) (actual time=4.039..53.607 rows=169 loops=1)

  • Hash Cond: (lima_delta1.two_romeo = papa_kilo1.quebec_seven)
12. 0.106 49.156 ↑ 17.8 169 1

Hash Left Join (cost=2.12..7,109.07 rows=3,000 width=284) (actual time=0.071..49.156 rows=169 loops=1)

  • Hash Cond: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
13. 0.133 49.036 ↑ 17.8 169 1

Nested Loop Left Join (cost=0.83..7,097.34 rows=3,000 width=275) (actual time=0.051..49.036 rows=169 loops=1)

  • Join Filter: (lima_delta1.juliet_hotel = uniform_delta1.quebec_seven)
14. 48.903 48.903 ↑ 17.8 169 1

Index Scan using papa_yankee on foxtrot_romeo quebec_sierra (cost=0.56..7,049.84 rows=3,000 width=179) (actual time=0.040..48.903 rows=169 loops=1)

  • Index Cond: ((lima_romeo)::text = 'quebec_quebec'::text)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND (juliet_hotel = 81))
  • Rows Removed by Filter: 27,033
15. 0.000 0.000 ↑ 1.0 1 169

Materialize (cost=0.27..2.50 rows=1 width=96) (actual time=0.000..0.000 rows=1 loops=169)

16. 0.008 0.008 ↑ 1.0 1 1

Index Scan using two_delta on echo_zulu mike_quebec (cost=0.27..2.49 rows=1 width=96) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: (quebec_seven = 81)
17. 0.004 0.014 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=25) (actual time=0.014..0.014 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
18. 0.010 0.010 ↑ 1.0 13 1

Seq Scan on tango four_uniform (cost=0.00..1.13 rows=13 width=25) (actual time=0.007..0.010 rows=13 loops=1)

19. 1.729 3.954 ↓ 1.0 8,167 1

Hash (cost=241.39..241.39 rows=8,139 width=27) (actual time=3.953..3.954 rows=8,167 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 569kB
20. 2.225 2.225 ↓ 1.0 8,167 1

Seq Scan on golf uniform_romeo (cost=0.00..241.39 rows=8,139 width=27) (actual time=0.004..2.225 rows=8,167 loops=1)

21. 12.737 15.344 ↑ 1.0 5,181 1

Hash (cost=542.81..542.81 rows=5,181 width=67) (actual time=15.343..15.344 rows=5,181 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 569kB
22. 2.607 2.607 ↑ 1.0 5,181 1

Seq Scan on sierra_three whiskey_six (cost=0.00..542.81 rows=5,181 width=67) (actual time=0.007..2.607 rows=5,181 loops=1)

23. 0.132 0.441 ↓ 1.0 352 1

Hash (cost=193.23..193.23 rows=347 width=52) (actual time=0.440..0.441 rows=352 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 65kB
24. 0.309 0.309 ↓ 1.0 352 1

Index Scan using five_victor on delta_alpha five_xray (cost=0.28..193.23 rows=347 width=52) (actual time=0.015..0.309 rows=352 loops=1)

  • Index Cond: (foxtrot_charlie = 81)
25. 1.010 2.231 ↑ 1.0 2,541 1

Hash (cost=459.75..459.75 rows=2,575 width=675) (actual time=2.231..2.231 rows=2,541 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 1,354kB
26. 1.221 1.221 ↑ 1.0 2,541 1

Seq Scan on juliet_november romeo_kilo (cost=0.00..459.75 rows=2,575 width=675) (actual time=0.010..1.221 rows=2,541 loops=1)

27. 0.000 0.000 ↑ 1.0 1 169

Materialize (cost=0.00..1.06 rows=1 width=8) (actual time=0.000..0.000 rows=1 loops=169)

28. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on hotel_three romeo_foxtrot (cost=0.00..1.06 rows=1 width=8) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: ((yankee_zulu = 81) AND ((juliet_charlie)::text = 'kilo_papa'::text))
  • Rows Removed by Filter: 3
29. 0.845 0.845 ↑ 1.0 1 169

Index Scan using charlie on uniform_kilo victor (cost=0.43..2.54 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=169)

  • Index Cond: (sierra_foxtrot = lima_delta1.quebec_seven)
30. 0.257 13.982 ↑ 1.0 902 1

Hash (cost=194.02..194.02 rows=902 width=69) (actual time=13.981..13.982 rows=902 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 98kB
31. 13.725 13.725 ↑ 1.0 902 1

Seq Scan on oscar yankee_xray (cost=0.00..194.02 rows=902 width=69) (actual time=0.005..13.725 rows=902 loops=1)

32. 0.298 9.799 ↓ 1.0 1,193 1

Hash (cost=259.78..259.78 rows=1,178 width=41) (actual time=9.798..9.799 rows=1,193 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 107kB
33. 9.501 9.501 ↓ 1.0 1,193 1

Seq Scan on whiskey_tango hotel_golf (cost=0.00..259.78 rows=1,178 width=41) (actual time=0.008..9.501 rows=1,193 loops=1)

Planning time : 20.362 ms
Execution time : 108.990 ms