explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qOjR

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.026 146.660 ↑ 1.5 171 1

Limit (cost=29,201.42..29,332.05 rows=250 width=554) (actual time=142.023..146.660 rows=171 loops=1)

2. 4.705 146.634 ↑ 57.5 171 1

Result (cost=29,201.42..34,337.08 rows=9,829 width=554) (actual time=142.021..146.634 rows=171 loops=1)

3. 0.241 141.929 ↑ 57.5 171 1

Sort (cost=29,201.42..29,226.00 rows=9,829 width=557) (actual time=141.887..141.929 rows=171 loops=1)

  • Sort Key: lima_delta1.mike_seven, lima_delta1.november
  • Sort Method: quicksort Memory: 189kB
4. 0.111 141.688 ↑ 57.5 171 1

Hash Left Join (cost=2,339.12..28,760.80 rows=9,829 width=557) (actual time=55.189..141.688 rows=171 loops=1)

  • Hash Cond: (echo_seven1.delta_kilo = alpha_seven1.quebec_seven)
5. 0.111 140.738 ↑ 57.5 171 1

Hash Left Join (cost=2,064.61..28,460.43 rows=9,829 width=1,134) (actual time=54.329..140.738 rows=171 loops=1)

  • Hash Cond: (echo_seven1.four_delta = kilo_foxtrot2.quebec_seven)
6. 0.126 139.827 ↑ 57.5 171 1

Nested Loop Left Join (cost=1,859.31..28,229.21 rows=9,829 width=1,073) (actual time=53.518..139.827 rows=171 loops=1)

7. 0.103 138.846 ↑ 56.9 171 1

Hash Left Join (cost=1,858.88..9,161.07 rows=9,727 width=1,049) (actual time=53.501..138.846 rows=171 loops=1)

  • Hash Cond: (lima_delta1.quebec_seven = zulu1.sierra_foxtrot)
8. 0.154 136.601 ↑ 56.9 171 1

Hash Left Join (cost=1,366.94..8,620.46 rows=9,727 width=382) (actual time=51.344..136.601 rows=171 loops=1)

  • Hash Cond: ((kilo_foxtrot1.quebec_seven = alpha_oscar1.uniform_bravo) AND (lima_delta1.juliet_hotel = alpha_oscar1.foxtrot_charlie))
9. 0.139 114.367 ↑ 56.9 171 1

Hash Left Join (cost=1,031.57..8,234.01 rows=9,727 width=354) (actual time=29.240..114.367 rows=171 loops=1)

  • Hash Cond: (lima_delta1.lima_echo = kilo_foxtrot1.quebec_seven)
10. 0.135 89.590 ↑ 56.9 171 1

Hash Left Join (cost=424.00..7,600.89 rows=9,727 width=295) (actual time=4.584..89.590 rows=171 loops=1)

  • Hash Cond: (lima_delta1.two = papa_kilo1.quebec_seven)
11. 0.095 85.543 ↑ 56.9 171 1

Hash Left Join (cost=80.87..7,232.21 rows=9,727 width=284) (actual time=0.657..85.543 rows=171 loops=1)

  • Hash Cond: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
12. 0.095 85.436 ↑ 56.9 171 1

Hash Left Join (cost=79.58..7,197.07 rows=9,727 width=275) (actual time=0.640..85.436 rows=171 loops=1)

  • Hash Cond: (lima_delta1.juliet_hotel = uniform_delta1.quebec_seven)
13. 5.879 85.027 ↑ 56.9 171 1

Hash Left Join (cost=1.65..7,093.32 rows=9,727 width=179) (actual time=0.321..85.027 rows=171 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,621
14. 79.137 79.137 ↑ 1.7 17,792 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.026..79.137 rows=17,792 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.003 0.011 ↑ 1.0 3 1

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

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

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

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

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 58kB
18. 0.216 0.216 ↑ 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.216 rows=397 loops=1)

19. 0.004 0.012 ↑ 1.0 13 1

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

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

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

21. 1.748 3.912 ↓ 1.0 8,167 1

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

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

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

23. 4.242 24.638 ↑ 1.0 5,181 1

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

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

25. 4.098 22.080 ↓ 1.0 5,539 1

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

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

27. 0.976 2.142 ↑ 1.0 2,540 1

Hash (cost=459.75..459.75 rows=2,575 width=675) (actual time=2.141..2.142 rows=2,540 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 1,354kB
28. 1.166 1.166 ↑ 1.0 2,540 1

Seq Scan on juliet_november romeo_kilo (cost=0.00..459.75 rows=2,575 width=675) (actual time=0.008..1.166 rows=2,540 loops=1)

29. 0.855 0.855 ↑ 1.0 1 171

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=171)

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

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

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

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

32. 0.284 0.839 ↓ 1.0 1,193 1

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

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

Planning time : 19.594 ms
Execution time : 146.867 ms