explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UZX : 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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.013 36.183 ↑ 2.1 121 1

Limit (cost=12,811.90..12,841.07 rows=250 width=448) (actual time=34.171..36.183 rows=121 loops=1)

2. 11.806 36.170 ↑ 22.6 121 1

Gather Merge (cost=12,811.90..13,130.43 rows=2,730 width=448) (actual time=34.171..36.170 rows=121 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.078 24.364 ↑ 34.1 40 3 / 3

Sort (cost=11,811.88..11,815.29 rows=1,365 width=448) (actual time=24.354..24.364 rows=40 loops=3)

  • Sort Key: lima_delta1.mike_seven
  • Sort Method: quicksort Memory: 94kB
4. 0.021 24.286 ↑ 34.1 40 3 / 3

Hash Left Join (cost=8,350.54..11,740.80 rows=1,365 width=448) (actual time=23.926..24.286 rows=40 loops=3)

  • Hash Cond: (echo_seven1.delta = alpha1.quebec_seven)
5. 0.025 23.993 ↑ 34.1 40 3 / 3

Hash Left Join (cost=8,076.04..11,462.70 rows=1,365 width=423) (actual time=23.650..23.993 rows=40 loops=3)

  • Hash Cond: (echo_seven1.four_delta = kilo_foxtrot2.quebec_seven)
6. 0.041 23.737 ↑ 34.1 40 3 / 3

Nested Loop Left Join (cost=7,870.74..11,253.80 rows=1,365 width=362) (actual time=23.413..23.737 rows=40 loops=3)

7. 0.118 23.535 ↑ 33.8 40 3 / 3

Merge Left Join (cost=7,870.31..8,082.12 rows=1,351 width=346) (actual time=23.407..23.535 rows=40 loops=3)

  • Merge Cond: (lima_delta1.quebec_seven = zulu1.sierra_foxtrot)
8. 0.059 23.139 ↑ 33.8 40 3 / 3

Sort (cost=7,870.03..7,873.41 rows=1,351 width=346) (actual time=23.127..23.139 rows=40 loops=3)

  • Sort Key: lima_delta1.quebec_seven
  • Sort Method: quicksort Memory: 87kB
9. 0.020 23.080 ↑ 33.8 40 3 / 3

Nested Loop Left Join (cost=424.28..7,799.78 rows=1,351 width=346) (actual time=14.749..23.080 rows=40 loops=3)

10. 0.028 22.939 ↑ 33.8 40 3 / 3

Hash Left Join (cost=424.00..7,314.44 rows=1,351 width=295) (actual time=14.744..22.939 rows=40 loops=3)

  • Hash Cond: (lima_delta1.two = papa_kilo1.quebec_seven)
11. 0.020 21.521 ↑ 33.8 40 3 / 3

Hash Left Join (cost=80.87..6,967.76 rows=1,351 width=284) (actual time=13.349..21.521 rows=40 loops=3)

  • Hash Cond: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
12. 0.022 21.497 ↑ 33.8 40 3 / 3

Hash Left Join (cost=79.58..6,961.77 rows=1,351 width=275) (actual time=13.343..21.497 rows=40 loops=3)

  • Hash Cond: (lima_delta1.juliet_hotel = uniform_delta1.quebec_seven)
13. 0.317 21.365 ↑ 33.8 40 3 / 3

Hash Left Join (cost=1.65..6,880.26 rows=1,351 width=179) (actual time=13.231..21.365 rows=40 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: 1,245
14. 21.035 21.035 ↑ 3.2 1,285 3 / 3

Parallel Index Scan using papa_yankee on foxtrot quebec_sierra (cost=0.56..6,862.90 rows=4,154 width=179) (actual time=4.729..21.035 rows=1,285 loops=3)

  • Index Cond: ((lima_romeo)::text = 'quebec_quebec'::text)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND ((mike_seven)::date >= 'four_india'::date))
  • Rows Removed by Filter: 7,778
15. 0.003 0.013 ↑ 1.0 3 2 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
16. 0.011 0.011 ↑ 1.0 3 2 / 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=2)

  • Filter: ((juliet_charlie)::text = 'kilo_papa'::text)
  • Rows Removed by Filter: 1
17. 0.033 0.110 ↑ 1.0 397 1 / 3

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

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

Seq Scan on echo_zulu mike_quebec (cost=0.00..72.97 rows=397 width=96) (actual time=0.006..0.231 rows=397 loops=1)

19. 0.002 0.004 ↑ 1.0 13 1 / 3

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

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

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

21. 0.600 1.390 ↓ 1.0 8,167 1 / 3

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

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

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

23. 0.121 0.121 ↑ 1.0 1 121 / 3

Index Scan using sierra_delta on sierra_three whiskey_six (cost=0.28..0.36 rows=1 width=67) (actual time=0.003..0.003 rows=1 loops=121)

  • Index Cond: (lima_delta1.lima_echo = quebec_seven)
24. 0.278 0.278 ↑ 1.0 2,541 1 / 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.022..0.835 rows=2,541 loops=1)

  • Heap Fetches: 882
25. 0.161 0.161 ↑ 1.0 1 121 / 3

Index Scan using charlie on uniform_kilo victor (cost=0.43..2.34 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=121)

  • Index Cond: (sierra_foxtrot = lima_delta1.quebec_seven)
26. 0.073 0.231 ↑ 1.0 902 1 / 3

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

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

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

28. 0.096 0.272 ↓ 1.0 1,193 1 / 3

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

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

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

Planning time : 8.662 ms
Execution time : 36.318 ms