explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gWgH

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.022 97.107 ↑ 1.4 175 1

Limit (cost=13,260.24..13,289.41 rows=250 width=5,500) (actual time=90.235..97.107 rows=175 loops=1)

2. 29.185 97.085 ↑ 14.4 175 1

Gather Merge (cost=13,260.24..13,554.96 rows=2,526 width=5,500) (actual time=90.234..97.085 rows=175 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.372 67.900 ↑ 21.8 58 3 / 3

Sort (cost=12,260.22..12,263.37 rows=1,263 width=5,500) (actual time=67.876..67.900 rows=58 loops=3)

  • Sort Key: lima_delta1.mike_seven, lima_delta1.november
  • Sort Method: quicksort Memory: 466kB
4. 0.086 67.528 ↑ 21.8 58 3 / 3

Hash Left Join (cost=2,125.66..12,195.16 rows=1,263 width=5,500) (actual time=36.334..67.528 rows=58 loops=3)

  • Hash Cond: (echo_seven1.delta_kilo = alpha_seven1.quebec_seven)
5. 0.099 62.157 ↑ 21.8 58 3 / 3

Hash Left Join (cost=1,851.16..11,917.32 rows=1,263 width=3,471) (actual time=31.030..62.157 rows=58 loops=3)

  • Hash Cond: (echo_seven1.four_delta = kilo2.quebec_seven)
6. 0.092 61.330 ↑ 21.8 58 3 / 3

Nested Loop Left Join (cost=1,645.86..11,708.70 rows=1,263 width=3,149) (actual time=30.285..61.330 rows=58 loops=3)

7. 0.088 59.663 ↑ 21.6 58 3 / 3

Hash Left Join (cost=1,645.43..8,517.54 rows=1,250 width=3,093) (actual time=30.245..59.663 rows=58 loops=3)

  • Hash Cond: (lima_delta1.quebec_seven = zulu1.sierra_foxtrot)
8. 0.096 54.907 ↑ 21.6 58 3 / 3

Hash Left Join (cost=1,153.49..8,019.34 rows=1,250 width=1,650) (actual time=25.551..54.907 rows=58 loops=3)

  • Hash Cond: ((lima_delta1.juliet_hotel = alpha_oscar1.foxtrot_charlie) AND (kilo1.quebec_seven = alpha_oscar1.uniform_bravo))
9. 1.836 54.227 ↑ 21.6 58 3 / 3

Hash Left Join (cost=955.05..7,814.34 rows=1,250 width=1,417) (actual time=24.947..54.227 rows=58 loops=3)

  • Hash Cond: (lima_delta1.lima_echo = kilo1.quebec_seven)
10. 0.376 40.981 ↑ 21.6 58 3 / 3

Hash Left Join (cost=347.48..7,203.48 rows=1,250 width=1,132) (actual time=11.780..40.981 rows=58 loops=3)

  • Hash Cond: (lima_delta1.two_romeo = papa_kilo1.quebec_seven)
11. 1.687 29.513 ↑ 21.6 58 3 / 3

Hash Left Join (cost=4.35..6,857.07 rows=1,250 width=1,007) (actual time=0.423..29.513 rows=58 loops=3)

  • Hash Cond: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
12. 0.278 27.805 ↑ 21.6 58 3 / 3

Hash Left Join (cost=3.06..6,851.43 rows=1,250 width=959) (actual time=0.391..27.805 rows=58 loops=3)

  • Hash Cond: (lima_delta1.juliet_hotel = uniform_delta1.quebec_seven)
13. 27.476 27.476 ↑ 21.6 58 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=0.169..27.476 rows=58 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
14. 0.005 0.051 ↑ 1.0 1 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
15. 0.046 0.046 ↑ 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.045..0.046 rows=1 loops=3)

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

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
17. 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)

18. 2.377 11.092 ↓ 1.0 8,167 3 / 3

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,324kB
19. 8.715 8.715 ↓ 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.015..8.715 rows=8,167 loops=3)

20. 4.461 11.410 ↑ 1.0 5,181 3 / 3

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,644kB
21. 6.949 6.949 ↑ 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.015..6.949 rows=5,181 loops=3)

22. 0.195 0.584 ↓ 1.0 352 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 149kB
23. 0.389 0.389 ↓ 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.047..0.389 rows=352 loops=3)

  • Index Cond: (foxtrot_charlie = 81)
24. 3.134 4.668 ↑ 1.0 2,541 3 / 3

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 3,258kB
25. 1.534 1.534 ↑ 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.017..1.534 rows=2,541 loops=3)

26. 1.575 1.575 ↑ 1.0 1 175 / 3

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

  • Index Cond: (sierra_foxtrot = lima_delta1.quebec_seven)
27. 0.398 0.728 ↑ 1.0 902 3 / 3

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

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

Seq Scan on oscar yankee (cost=0.00..194.02 rows=902 width=322) (actual time=0.012..0.330 rows=902 loops=3)

29. 0.920 5.285 ↓ 1.0 1,193 3 / 3

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

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

Seq Scan on whiskey_tango hotel (cost=0.00..259.78 rows=1,178 width=2,013) (actual time=0.013..4.365 rows=1,193 loops=3)

Planning time : 30.100 ms
Execution time : 97.658 ms