explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XZBd : 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: 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; plan #XyN3; plan #WHzt; plan #sUl; plan #xWEE

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.023 114.288 ↑ 1.5 169 1

Limit (cost=29,201.78..29,334.91 rows=250 width=554) (actual time=109.979..114.288 rows=169 loops=1)

2. 4.387 114.265 ↑ 58.2 169 1

Result (cost=29,201.78..34,435.72 rows=9,829 width=554) (actual time=109.978..114.265 rows=169 loops=1)

3. 0.234 109.878 ↑ 58.2 169 1

Sort (cost=29,201.78..29,226.35 rows=9,829 width=557) (actual time=109.836..109.878 rows=169 loops=1)

  • Sort Key: lima_delta1.mike_seven
  • Sort Method: quicksort Memory: 187kB
4. 0.104 109.644 ↑ 58.2 169 1

Hash Left Join (cost=2,339.12..28,761.16 rows=9,829 width=557) (actual time=51.003..109.644 rows=169 loops=1)

  • Hash Cond: (echo_seven1.delta_kilo = alpha_seven1.quebec_seven)
5. 0.119 93.007 ↑ 58.2 169 1

Hash Left Join (cost=2,064.61..28,460.78 rows=9,829 width=1,134) (actual time=34.459..93.007 rows=169 loops=1)

  • Hash Cond: (echo_seven1.four_delta = kilo_foxtrot2.quebec_seven)
6. 0.133 92.208 ↑ 58.2 169 1

Nested Loop Left Join (cost=1,859.31..28,229.57 rows=9,829 width=1,073) (actual time=33.768..92.208 rows=169 loops=1)

7. 0.129 91.230 ↑ 57.6 169 1

Hash Left Join (cost=1,858.88..9,161.07 rows=9,727 width=1,049) (actual time=33.753..91.230 rows=169 loops=1)

  • Hash Cond: (lima_delta1.quebec_seven = zulu1.sierra_foxtrot)
8. 0.161 85.459 ↑ 57.6 169 1

Hash Left Join (cost=1,366.94..8,620.46 rows=9,727 width=382) (actual time=28.095..85.459 rows=169 loops=1)

  • Hash Cond: ((kilo_foxtrot1.quebec_seven = alpha_oscar1.uniform_bravo) AND (lima_delta1.juliet_hotel = alpha_oscar1.foxtrot_charlie))
9. 0.147 66.766 ↑ 57.6 169 1

Hash Left Join (cost=1,031.57..8,234.01 rows=9,727 width=354) (actual time=9.544..66.766 rows=169 loops=1)

  • Hash Cond: (lima_delta1.lima_echo = kilo_foxtrot1.quebec_seven)
10. 0.130 63.113 ↑ 57.6 169 1

Hash Left Join (cost=424.00..7,600.89 rows=9,727 width=295) (actual time=6.017..63.113 rows=169 loops=1)

  • Hash Cond: (lima_delta1.two = papa_kilo1.quebec_seven)
11. 0.096 57.319 ↑ 57.6 169 1

Hash Left Join (cost=80.87..7,232.21 rows=9,727 width=284) (actual time=0.340..57.319 rows=169 loops=1)

  • Hash Cond: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
12. 0.098 57.214 ↑ 57.6 169 1

Hash Left Join (cost=79.58..7,197.07 rows=9,727 width=275) (actual time=0.327..57.214 rows=169 loops=1)

  • Hash Cond: (lima_delta1.juliet_hotel = uniform_delta1.quebec_seven)
13. 9.576 56.858 ↑ 57.6 169 1

Hash Left Join (cost=1.65..7,093.32 rows=9,727 width=179) (actual time=0.066..56.858 rows=169 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,603
14. 47.273 47.273 ↑ 1.7 17,772 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.022..47.273 rows=17,772 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.006..0.007 rows=3 loops=1)

  • Filter: ((juliet_charlie)::text = 'kilo_papa'::text)
  • Rows Removed by Filter: 1
17. 0.083 0.258 ↑ 1.0 397 1

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

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

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

19. 0.003 0.009 ↑ 1.0 13 1

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

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

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

21. 1.429 5.664 ↓ 1.0 8,167 1

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

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

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

23. 1.489 3.506 ↑ 1.0 5,181 1

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

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

25. 4.593 18.532 ↓ 1.0 5,539 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 501kB
26. 13.939 13.939 ↓ 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.007..13.939 rows=5,539 loops=1)

27. 1.764 5.642 ↑ 1.0 2,541 1

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

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

29. 0.845 0.845 ↑ 1.0 1 169

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

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

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

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

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

32. 0.341 16.533 ↓ 1.0 1,193 1

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

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

Planning time : 19.203 ms
Execution time : 114.450 ms