explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tFxB : Optimization for: Optimization for: Optimization for: plan #yWnq; plan #Mjxa; plan #ximH

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.011 47.565 ↑ 2.7 94 1

Limit (cost=34,426.90..34,444.40 rows=250 width=554) (actual time=47.457..47.565 rows=94 loops=1)

2. 0.079 47.554 ↑ 104.6 94 1

Unique (cost=34,426.90..35,114.93 rows=9,829 width=554) (actual time=47.456..47.554 rows=94 loops=1)

3. 0.132 47.475 ↑ 104.6 94 1

Sort (cost=34,426.90..34,451.47 rows=9,829 width=554) (actual time=47.455..47.475 rows=94 loops=1)

  • Sort Key: lima_delta1.quebec_seven, lima_delta1.juliet_delta, lima_delta1.oscar_four, lima_delta1.november_seven, lima_delta1.mike_seven, lima_delta1.foxtrot_bravo, lima_delta1.golf_echo, lima_delta1.zulu_alpha, lima_delta1.november_romeo, romeo_three1.three, romeo_three1.six_xray, kilo_foxtrot1.quebec_seven, kilo_foxtrot1.juliet_delta, kilo_foxtrot1.three, kilo_foxtrot2.quebec_seven, kilo_foxtrot2.juliet_delta, kilo_foxtrot2.three, alpha_seven1.three, alpha_seven1.yankee_tango, uniform_delta1.quebec_seven, uniform_delta1.juliet_delta, uniform_delta1.three, papa_kilo1.whiskey_zulu, echo_seven1.victor_five, ((zulu_uniform1.oscar_sierra five_romeo NOT NULL)), (six_uniform(0, alpha_oscar1.six_uniform, lima_delta1.foxtrot_bravo, LOCALTIMESTAMP, lima_delta1.mike_seven)), ((six_uniform(1, alpha_oscar1.six_uniform, lima_delta1.foxtrot_bravo, LOCALTIMESTAMP, lima_delta1.mike_seven))::boolean)
  • Sort Method: quicksort Memory: 94kB
4. 2.497 47.343 ↑ 104.6 94 1

Hash Left Join (cost=2,338.12..33,775.09 rows=9,829 width=554) (actual time=9.450..47.343 rows=94 loops=1)

  • Hash Cond: (echo_seven1.delta_kilo = alpha_seven1.quebec_seven)
5. 0.059 44.274 ↑ 104.6 94 1

Hash Left Join (cost=2,063.61..28,461.93 rows=9,829 width=1,134) (actual time=8.781..44.274 rows=94 loops=1)

  • Hash Cond: (echo_seven1.four_delta = kilo_foxtrot2.quebec_seven)
6. 0.080 43.733 ↑ 104.6 94 1

Nested Loop Left Join (cost=1,859.31..28,231.71 rows=9,829 width=1,073) (actual time=8.292..43.733 rows=94 loops=1)

7. 0.084 43.183 ↑ 103.5 94 1

Hash Left Join (cost=1,858.88..9,161.07 rows=9,727 width=1,049) (actual time=8.282..43.183 rows=94 loops=1)

  • Hash Cond: ((kilo_foxtrot1.quebec_seven = alpha_oscar1.uniform_bravo) AND (lima_delta1.juliet_hotel = alpha_oscar1.foxtrot_charlie))
8. 0.075 41.151 ↑ 103.5 94 1

Hash Left Join (cost=1,523.51..8,774.63 rows=9,727 width=1,021) (actual time=6.318..41.151 rows=94 loops=1)

  • Hash Cond: (lima_delta1.lima_echo = kilo_foxtrot1.quebec_seven)
9. 0.078 38.919 ↑ 103.5 94 1

Hash Left Join (cost=915.93..8,141.50 rows=9,727 width=962) (actual time=4.147..38.919 rows=94 loops=1)

  • Hash Cond: (lima_delta1.two = papa_kilo1.quebec_seven)
10. 0.053 36.581 ↑ 103.5 94 1

Hash Left Join (cost=572.81..7,772.83 rows=9,727 width=951) (actual time=1.874..36.581 rows=94 loops=1)

  • Hash Cond: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
11. 0.057 36.520 ↑ 103.5 94 1

Hash Left Join (cost=571.51..7,737.68 rows=9,727 width=942) (actual time=1.861..36.520 rows=94 loops=1)

  • Hash Cond: (lima_delta1.juliet_hotel = uniform_delta1.quebec_seven)
12. 0.056 36.247 ↑ 103.5 94 1

Hash Left Join (cost=493.58..7,633.94 rows=9,727 width=846) (actual time=1.638..36.247 rows=94 loops=1)

  • Hash Cond: (lima_delta1.quebec_seven = zulu_uniform1.sierra_foxtrot)
13. 2.727 34.626 ↑ 103.5 94 1

Hash Left Join (cost=1.65..7,093.32 rows=9,727 width=179) (actual time=0.066..34.626 rows=94 loops=1)

  • Hash Cond: (lima_delta1.juliet_hotel = india1.quebec_hotel)
  • Filter: ((lima_delta1.juliet_hotel = 81) OR (india1.yankee_zulu = 81))
  • Rows Removed by Filter: 17,521
14. 31.890 31.890 ↑ 1.7 17,615 1

Index Scan using papa_yankee on foxtrot_romeo quebec_sierra (cost=0.56..6,975.07 rows=29,909 width=179) (actual time=0.019..31.890 rows=17,615 loops=1)

  • Index Cond: ((lima_romeo)::text = 'quebec_quebec'::text)
  • Filter: ((NOT papa_bravo) OR (papa_bravo five_romeo NULL))
  • Rows Removed by Filter: 9,402
15. 0.002 0.009 ↑ 1.0 3 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
16. 0.007 0.007 ↑ 1.0 3 1

Seq Scan on hotel_three romeo_foxtrot (cost=0.00..1.05 rows=3 width=16) (actual time=0.005..0.007 rows=3 loops=1)

  • Filter: ((juliet_charlie)::text = 'kilo_papa'::text)
  • Rows Removed by Filter: 1
17. 0.623 1.565 ↑ 1.0 2,541 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 1,354kB
18. 0.942 0.942 ↑ 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.003..0.942 rows=2,541 loops=1)

19. 0.058 0.216 ↑ 1.0 397 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 58kB
20. 0.158 0.158 ↑ 1.0 397 1

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

21. 0.003 0.008 ↑ 1.0 13 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
22. 0.005 0.005 ↑ 1.0 13 1

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

23. 0.976 2.260 ↓ 1.0 8,167 1

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

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

Seq Scan on golf_five uniform_romeo (cost=0.00..241.39 rows=8,139 width=27) (actual time=0.003..1.284 rows=8,167 loops=1)

25. 0.709 2.157 ↑ 1.0 5,181 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 569kB
26. 1.448 1.448 ↑ 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.004..1.448 rows=5,181 loops=1)

27. 0.753 1.948 ↓ 1.0 5,539 1

Hash (cost=252.95..252.95 rows=5,495 width=52) (actual time=1.947..1.948 rows=5,539 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 501kB
28. 1.195 1.195 ↓ 1.0 5,539 1

Seq Scan on delta_alpha five_xray (cost=0.00..252.95 rows=5,495 width=52) (actual time=0.006..1.195 rows=5,539 loops=1)

29. 0.470 0.470 ↑ 1.0 1 94

Index Scan using charlie on uniform_kilo victor_romeo (cost=0.43..1.95 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=94)

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

Hash (cost=193.02..193.02 rows=902 width=69) (actual time=0.482..0.482 rows=902 loops=1)

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

Seq Scan on oscar_oscar yankee_xray (cost=0.00..193.02 rows=902 width=69) (actual time=0.004..0.337 rows=902 loops=1)

32. 0.165 0.572 ↓ 1.0 1,193 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 107kB
33. 0.407 0.407 ↓ 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.005..0.407 rows=1,193 loops=1)

Planning time : 10.194 ms
Execution time : 47.706 ms