explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lj5Ms : Optimization for: plan #gWgH

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.018 57.718 ↑ 1.5 169 1

Limit (cost=13,278.50..13,307.67 rows=250 width=5,723) (actual time=52.863..57.718 rows=169 loops=1)

2. 26.988 57.700 ↑ 14.9 169 1

Gather Merge (cost=13,278.50..13,573.22 rows=2,526 width=5,723) (actual time=52.862..57.700 rows=169 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.299 30.712 ↑ 22.6 56 3 / 3

Sort (cost=12,278.48..12,281.63 rows=1,263 width=5,723) (actual time=30.692..30.712 rows=56 loops=3)

  • Sort Key: lima_delta1.mike_seven, lima_delta1.november
  • Sort Method: quicksort Memory: 603kB
4. 0.067 30.413 ↑ 22.6 56 3 / 3

Hash Left Join (cost=2,126.73..12,213.42 rows=1,263 width=5,723) (actual time=18.551..30.413 rows=56 loops=3)

  • Hash Cond: (echo_seven1.delta_kilo = alpha_seven1.quebec_seven)
5. 0.078 29.131 ↑ 22.6 56 3 / 3

Hash Left Join (cost=1,852.23..11,935.58 rows=1,263 width=3,694) (actual time=17.321..29.131 rows=56 loops=3)

  • Hash Cond: (echo_seven1.four_delta = kilo_foxtrot2.quebec_seven)
6. 0.073 28.368 ↑ 22.6 56 3 / 3

Nested Loop Left Join (cost=1,646.93..11,726.96 rows=1,263 width=3,372) (actual time=16.624..28.368 rows=56 loops=3)

7. 0.075 27.844 ↑ 22.3 56 3 / 3

Hash Left Join (cost=1,646.50..8,535.80 rows=1,250 width=3,316) (actual time=16.585..27.844 rows=56 loops=3)

  • Hash Cond: (lima_delta1.juliet_hotel = india1.yankee_zulu)
8. 0.076 27.754 ↑ 22.3 56 3 / 3

Hash Left Join (cost=1,645.43..8,517.54 rows=1,250 width=3,093) (actual time=16.551..27.754 rows=56 loops=3)

  • Hash Cond: (lima_delta1.quebec_seven = zulu1.sierra_foxtrot)
9. 0.075 22.035 ↑ 22.3 56 3 / 3

Hash Left Join (cost=1,153.49..8,019.34 rows=1,250 width=1,650) (actual time=10.884..22.035 rows=56 loops=3)

  • Hash Cond: ((lima_delta1.juliet_hotel = alpha_oscar1.foxtrot_charlie) AND (kilo_foxtrot1.quebec_seven = alpha_oscar1.uniform_bravo))
10. 0.104 21.321 ↑ 22.3 56 3 / 3

Hash Left Join (cost=955.05..7,814.34 rows=1,250 width=1,417) (actual time=10.230..21.321 rows=56 loops=3)

  • Hash Cond: (lima_delta1.lima_echo = kilo_foxtrot1.quebec_seven)
11. 0.095 17.225 ↑ 22.3 56 3 / 3

Hash Left Join (cost=347.48..7,203.48 rows=1,250 width=1,132) (actual time=6.193..17.225 rows=56 loops=3)

  • Hash Cond: (lima_delta1.two_romeo = papa_kilo1.quebec_seven)
12. 0.054 13.082 ↑ 22.3 56 3 / 3

Hash Left Join (cost=4.35..6,857.07 rows=1,250 width=1,007) (actual time=2.105..13.082 rows=56 loops=3)

  • Hash Cond: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
13. 0.287 13.007 ↑ 22.3 56 3 / 3

Hash Left Join (cost=3.06..6,851.43 rows=1,250 width=959) (actual time=2.074..13.007 rows=56 loops=3)

  • Hash Cond: (lima_delta1.juliet_hotel = uniform_delta1.quebec_seven)
14. 12.671 12.671 ↑ 22.3 56 3 / 3

Parallel Index Scan using papa_yankee on foxtrot_romeo quebec_sierra (cost=0.56..6,831.74 rows=1,250 width=295) (actual time=1.793..12.671 rows=56 loops=3)

  • 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: 9,012
15. 0.004 0.049 ↑ 1.0 1 3 / 3

Hash (cost=2.49..2.49 rows=1 width=664) (actual time=0.049..0.049 rows=1 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
16. 0.045 0.045 ↑ 1.0 1 3 / 3

Index Scan using two_delta on echo_zulu mike_quebec (cost=0.27..2.49 rows=1 width=664) (actual time=0.044..0.045 rows=1 loops=3)

  • Index Cond: (quebec_seven = 81)
17. 0.006 0.021 ↑ 1.0 13 3 / 3

Hash (cost=1.13..1.13 rows=13 width=48) (actual time=0.020..0.021 rows=13 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
18. 0.015 0.015 ↑ 1.0 13 3 / 3

Seq Scan on tango four_uniform (cost=0.00..1.13 rows=13 width=48) (actual time=0.013..0.015 rows=13 loops=3)

19. 2.463 4.048 ↓ 1.0 8,167 3 / 3

Hash (cost=241.39..241.39 rows=8,139 width=125) (actual time=4.048..4.048 rows=8,167 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,324kB
20. 1.585 1.585 ↓ 1.0 8,167 3 / 3

Seq Scan on golf uniform_romeo (cost=0.00..241.39 rows=8,139 width=125) (actual time=0.011..1.585 rows=8,167 loops=3)

21. 2.238 3.992 ↑ 1.0 5,181 3 / 3

Hash (cost=542.81..542.81 rows=5,181 width=285) (actual time=3.991..3.992 rows=5,181 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,644kB
22. 1.754 1.754 ↑ 1.0 5,181 3 / 3

Seq Scan on sierra_three whiskey_six (cost=0.00..542.81 rows=5,181 width=285) (actual time=0.012..1.754 rows=5,181 loops=3)

23. 0.260 0.639 ↓ 1.0 352 3 / 3

Hash (cost=193.23..193.23 rows=347 width=233) (actual time=0.639..0.639 rows=352 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 149kB
24. 0.379 0.379 ↓ 1.0 352 3 / 3

Index Scan using five_victor on delta_alpha five_xray (cost=0.28..193.23 rows=347 width=233) (actual time=0.040..0.379 rows=352 loops=3)

  • Index Cond: (foxtrot_charlie = 81)
25. 4.192 5.643 ↑ 1.0 2,541 3 / 3

Hash (cost=459.75..459.75 rows=2,575 width=1,443) (actual time=5.643..5.643 rows=2,541 loops=3)

  • Buckets: 4,096 Batches: 1 Memory Usage: 3,258kB
26. 1.451 1.451 ↑ 1.0 2,541 3 / 3

Seq Scan on juliet_november romeo_kilo (cost=0.00..459.75 rows=2,575 width=1,443) (actual time=0.015..1.451 rows=2,541 loops=3)

27. 0.004 0.015 ↑ 1.0 1 3 / 3

Hash (cost=1.06..1.06 rows=1 width=223) (actual time=0.014..0.015 rows=1 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
28. 0.011 0.011 ↑ 1.0 1 3 / 3

Seq Scan on hotel_three romeo_foxtrot (cost=0.00..1.06 rows=1 width=223) (actual time=0.011..0.011 rows=1 loops=3)

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

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

  • Index Cond: (sierra_foxtrot = lima_delta1.quebec_seven)
30. 0.384 0.685 ↑ 1.0 902 3 / 3

Hash (cost=194.02..194.02 rows=902 width=322) (actual time=0.684..0.685 rows=902 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 287kB
31. 0.301 0.301 ↑ 1.0 902 3 / 3

Seq Scan on oscar yankee_xray (cost=0.00..194.02 rows=902 width=322) (actual time=0.010..0.301 rows=902 loops=3)

32. 0.873 1.215 ↓ 1.0 1,193 3 / 3

Hash (cost=259.78..259.78 rows=1,178 width=2,013) (actual time=1.215..1.215 rows=1,193 loops=3)

  • Buckets: 2,048 Batches: 1 Memory Usage: 999kB
33. 0.342 0.342 ↓ 1.0 1,193 3 / 3

Seq Scan on whiskey_tango hotel_golf (cost=0.00..259.78 rows=1,178 width=2,013) (actual time=0.011..0.342 rows=1,193 loops=3)

Planning time : 10.112 ms
Execution time : 58.256 ms