explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.010 63.891 ↓ 3.6 93 1

Limit (cost=7,731.32..7,733.14 rows=26 width=554) (actual time=63.778..63.891 rows=93 loops=1)

2. 0.088 63.881 ↓ 3.6 93 1

Unique (cost=7,731.32..7,733.14 rows=26 width=554) (actual time=63.777..63.881 rows=93 loops=1)

3. 0.170 63.793 ↓ 3.6 93 1

Sort (cost=7,731.32..7,731.38 rows=26 width=554) (actual time=63.776..63.793 rows=93 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. 3.248 63.623 ↓ 3.6 93 1

Nested Loop Left Join (cost=338.03..7,730.71 rows=26 width=554) (actual time=2.557..63.623 rows=93 loops=1)

5. 0.075 60.375 ↓ 3.6 93 1

Nested Loop (cost=337.76..7,709.77 rows=26 width=1,134) (actual time=2.436..60.375 rows=93 loops=1)

6. 0.113 60.114 ↓ 3.6 93 1

Nested Loop (cost=337.48..7,702.17 rows=26 width=1,073) (actual time=2.424..60.114 rows=93 loops=1)

7. 0.107 59.531 ↓ 3.6 94 1

Nested Loop Left Join (cost=337.05..7,651.19 rows=26 width=1,049) (actual time=2.416..59.531 rows=94 loops=1)

8. 0.133 59.330 ↓ 3.6 94 1

Nested Loop (cost=336.77..7,642.77 rows=26 width=382) (actual time=2.410..59.330 rows=94 loops=1)

9. 0.103 58.915 ↓ 3.6 94 1

Nested Loop (cost=336.49..7,634.80 rows=26 width=371) (actual time=2.403..58.915 rows=94 loops=1)

  • Join Filter: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
  • Rows Removed by Join Filter: 170
10. 0.127 58.812 ↓ 3.6 94 1

Nested Loop (cost=336.49..7,628.90 rows=26 width=362) (actual time=2.397..58.812 rows=94 loops=1)

11. 0.111 58.403 ↓ 3.5 94 1

Nested Loop (cost=336.20..7,620.27 rows=27 width=311) (actual time=2.391..58.403 rows=94 loops=1)

12. 18.302 58.104 ↑ 3.4 94 1

Nested Loop Left Join (cost=335.93..7,527.20 rows=318 width=231) (actual time=2.382..58.104 rows=94 loops=1)

  • Join Filter: (lima_delta1.juliet_hotel = india1.quebec_hotel)
  • Rows Removed by Join Filter: 52,832
  • Filter: ((lima_delta1.juliet_hotel = 81) OR (india1.yankee_zulu = 81))
  • Rows Removed by Filter: 17,520
13. 8.216 39.802 ↓ 18.0 17,614 1

Hash Join (cost=335.93..7,467.46 rows=978 width=231) (actual time=2.317..39.802 rows=17,614 loops=1)

  • Hash Cond: ((lima_delta1.juliet_hotel = alpha_oscar1.foxtrot_charlie) AND (lima_delta1.lima_echo = alpha_oscar1.uniform_bravo))
14. 29.307 29.307 ↑ 1.7 17,614 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..29.307 rows=17,614 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.908 2.279 ↓ 1.0 5,539 1

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

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

17. 0.000 0.000 ↑ 1.0 3 17,614

Materialize (cost=0.00..1.06 rows=3 width=16) (actual time=0.000..0.000 rows=3 loops=17,614)

18. 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
19. 0.188 0.188 ↑ 1.0 1 94

Index Scan using two_delta on echo_zulu mike_quebec (cost=0.27..0.29 rows=1 width=96) (actual time=0.002..0.002 rows=1 loops=94)

  • Index Cond: (quebec_seven = lima_delta1.juliet_hotel)
20. 0.282 0.282 ↑ 1.0 1 94

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

  • Index Cond: (quebec_seven = lima_delta1.lima_echo)
21. 0.000 0.000 ↑ 4.3 3 94

Materialize (cost=0.00..1.19 rows=13 width=25) (actual time=0.000..0.000 rows=3 loops=94)

22. 0.005 0.005 ↑ 4.3 3 1

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

23. 0.282 0.282 ↑ 1.0 1 94

Index Scan using kilo_charlie on golf_five uniform_romeo (cost=0.28..0.31 rows=1 width=27) (actual time=0.003..0.003 rows=1 loops=94)

  • Index Cond: (quebec_seven = lima_delta1.two_romeo)
24. 0.094 0.094 ↓ 0.0 0 94

Index Scan using five_oscar on juliet_november romeo_kilo (cost=0.28..0.31 rows=1 width=675) (actual time=0.001..0.001 rows=0 loops=94)

  • Index Cond: (lima_delta1.quebec_seven = sierra_foxtrot)
25. 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)
26. 0.186 0.186 ↑ 1.0 1 93

Index Scan using kilo_kilo on oscar_oscar yankee_xray (cost=0.28..0.29 rows=1 width=69) (actual time=0.002..0.002 rows=1 loops=93)

  • Index Cond: (quebec_seven = echo_seven1.four_delta)
27. 0.000 0.000 ↓ 0.0 0 93

Index Scan using uniform_golf on whiskey_tango hotel_golf (cost=0.28..0.30 rows=1 width=41) (actual time=0.000..0.000 rows=0 loops=93)

  • Index Cond: (echo_seven1.delta_kilo = quebec_seven)
Planning time : 19.523 ms
Execution time : 64.029 ms