explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XyN3 : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #gWgH; plan #lj5Ms; plan #B8eq; plan #Yty9; plan #Lheu; plan #27c; plan #qUXb; plan #6xFD; plan #YOFp; plan #tvR9; plan #vDLc; plan #4jS3; plan #a2yB; plan #elHgV; plan #6VaS; plan #o816; plan #hclw; plan #UZX

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.017 36.703 ↑ 1.5 169 1

Limit (cost=17,870.40..17,899.57 rows=250 width=456) (actual time=32.608..36.703 rows=169 loops=1)

2. 8.639 36.686 ↑ 48.5 169 1

Gather Merge (cost=17,870.40..18,825.97 rows=8,190 width=456) (actual time=32.607..36.686 rows=169 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.119 28.047 ↑ 73.1 56 3 / 3

Sort (cost=16,870.38..16,880.61 rows=4,095 width=456) (actual time=28.036..28.047 rows=56 loops=3)

  • Sort Key: lima_delta1.mike_seven
  • Sort Method: quicksort Memory: 84kB
4. 0.040 27.928 ↑ 73.1 56 3 / 3

Hash Left Join (cost=1,742.88..16,624.68 rows=4,095 width=456) (actual time=10.921..27.928 rows=56 loops=3)

  • Hash Cond: (echo_seven1.delta = alpha1.quebec_seven)
5. 0.046 27.119 ↑ 73.1 56 3 / 3

Hash Left Join (cost=1,468.37..16,339.40 rows=4,095 width=431) (actual time=10.138..27.119 rows=56 loops=3)

  • Hash Cond: (echo_seven1.four_delta = kilo_foxtrot2.quebec_seven)
6. 0.080 26.419 ↑ 73.1 56 3 / 3

Nested Loop Left Join (cost=1,263.08..16,123.30 rows=4,095 width=370) (actual time=9.470..26.419 rows=56 loops=3)

7. 0.046 25.832 ↑ 72.4 56 3 / 3

Hash Left Join (cost=1,262.64..8,177.93 rows=4,053 width=346) (actual time=9.439..25.832 rows=56 loops=3)

  • Hash Cond: (lima_delta1.quebec_seven = zulu1.sierra_foxtrot)
8. 0.074 24.337 ↑ 72.4 56 3 / 3

Hash Left Join (cost=1,031.57..7,926.57 rows=4,053 width=346) (actual time=7.970..24.337 rows=56 loops=3)

  • Hash Cond: (lima_delta1.lima_echo = kilo_foxtrot1.quebec_seven)
9. 0.069 20.831 ↑ 72.4 56 3 / 3

Hash Left Join (cost=424.00..7,308.34 rows=4,053 width=295) (actual time=4.499..20.831 rows=56 loops=3)

  • Hash Cond: (lima_delta1.two = papa_kilo1.quebec_seven)
10. 0.038 16.933 ↑ 72.4 56 3 / 3

Hash Left Join (cost=80.87..6,954.58 rows=4,053 width=284) (actual time=0.637..16.933 rows=56 loops=3)

  • Hash Cond: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
11. 0.042 16.879 ↑ 72.4 56 3 / 3

Hash Left Join (cost=79.58..6,939.17 rows=4,053 width=275) (actual time=0.612..16.879 rows=56 loops=3)

  • Hash Cond: (lima_delta1.juliet_hotel = uniform_delta1.quebec_seven)
12. 1.184 16.508 ↑ 72.4 56 3 / 3

Hash Left Join (cost=1.65..6,850.49 rows=4,053 width=179) (actual time=0.272..16.508 rows=56 loops=3)

  • Hash Cond: (lima_delta1.juliet_hotel = india1.quebec_hotel)
  • Filter: ((lima_delta1.juliet_hotel = 81) OR (india1.yankee_zulu = 81))
  • Rows Removed by Filter: 5,872
13. 15.305 15.305 ↑ 2.1 5,929 3 / 3

Parallel Index Scan using papa_yankee on foxtrot quebec_sierra (cost=0.56..6,800.59 rows=12,462 width=179) (actual time=0.030..15.305 rows=5,929 loops=3)

  • Index Cond: ((lima_romeo)::text = 'quebec_quebec'::text)
  • Filter: ((NOT papa_bravo) OR (papa_bravo five_romeo NULL))
  • Rows Removed by Filter: 3,134
14. 0.003 0.019 ↑ 1.0 3 3 / 3

Hash (cost=1.05..1.05 rows=3 width=16) (actual time=0.019..0.019 rows=3 loops=3)

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

Seq Scan on hotel_three romeo_foxtrot (cost=0.00..1.05 rows=3 width=16) (actual time=0.014..0.016 rows=3 loops=3)

  • Filter: ((juliet_charlie)::text = 'kilo_papa'::text)
  • Rows Removed by Filter: 1
16. 0.092 0.329 ↑ 1.0 397 3 / 3

Hash (cost=72.97..72.97 rows=397 width=96) (actual time=0.329..0.329 rows=397 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 58kB
17. 0.237 0.237 ↑ 1.0 397 3 / 3

Seq Scan on echo_zulu mike_quebec (cost=0.00..72.97 rows=397 width=96) (actual time=0.012..0.237 rows=397 loops=3)

18. 0.007 0.016 ↑ 1.0 13 3 / 3

Hash (cost=1.13..1.13 rows=13 width=25) (actual time=0.015..0.016 rows=13 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
19. 0.009 0.009 ↑ 1.0 13 3 / 3

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

20. 1.701 3.829 ↓ 1.0 8,167 3 / 3

Hash (cost=241.39..241.39 rows=8,139 width=27) (actual time=3.828..3.829 rows=8,167 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 569kB
21. 2.128 2.128 ↓ 1.0 8,167 3 / 3

Seq Scan on golf uniform_romeo (cost=0.00..241.39 rows=8,139 width=27) (actual time=0.010..2.128 rows=8,167 loops=3)

22. 1.271 3.432 ↑ 1.0 5,181 3 / 3

Hash (cost=542.81..542.81 rows=5,181 width=67) (actual time=3.431..3.432 rows=5,181 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 569kB
23. 2.161 2.161 ↑ 1.0 5,181 3 / 3

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

24. 0.455 1.449 ↑ 1.0 2,541 3 / 3

Hash (cost=198.89..198.89 rows=2,575 width=8) (actual time=1.448..1.449 rows=2,541 loops=3)

  • Buckets: 4,096 Batches: 1 Memory Usage: 132kB
25. 0.994 0.994 ↑ 1.0 2,541 3 / 3

Index Only Scan using five_oscar on juliet_november romeo_kilo (cost=0.28..198.89 rows=2,575 width=8) (actual time=0.044..0.994 rows=2,541 loops=3)

  • Heap Fetches: 882
26. 0.507 0.507 ↑ 1.0 1 169 / 3

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

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

Hash (cost=194.02..194.02 rows=902 width=69) (actual time=0.654..0.654 rows=902 loops=3)

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

Seq Scan on oscar yankee_xray (cost=0.00..194.02 rows=902 width=69) (actual time=0.012..0.433 rows=902 loops=3)

29. 0.281 0.769 ↓ 1.0 1,193 3 / 3

Hash (cost=259.78..259.78 rows=1,178 width=41) (actual time=0.768..0.769 rows=1,193 loops=3)

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

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

Planning time : 6.751 ms
Execution time : 36.849 ms