explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 55.173 ↓ 12.0 48 1

Limit (cost=7,475.12..7,475.40 rows=4 width=554) (actual time=55.137..55.173 rows=48 loops=1)

2. 0.025 55.169 ↓ 12.0 48 1

Unique (cost=7,475.12..7,475.40 rows=4 width=554) (actual time=55.137..55.169 rows=48 loops=1)

3. 0.056 55.144 ↓ 12.0 48 1

Sort (cost=7,475.12..7,475.13 rows=4 width=554) (actual time=55.136..55.144 rows=48 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: 59kB
4. 0.946 55.088 ↓ 12.0 48 1

Nested Loop Left Join (cost=338.03..7,475.08 rows=4 width=554) (actual time=2.110..55.088 rows=48 loops=1)

5. 0.030 54.142 ↓ 12.0 48 1

Nested Loop (cost=337.76..7,471.86 rows=4 width=1,134) (actual time=2.012..54.142 rows=48 loops=1)

6. 0.032 54.064 ↓ 12.0 48 1

Nested Loop (cost=337.48..7,470.69 rows=4 width=1,073) (actual time=2.004..54.064 rows=48 loops=1)

7. 0.043 53.888 ↓ 12.0 48 1

Nested Loop (cost=337.05..7,460.63 rows=4 width=1,049) (actual time=1.996..53.888 rows=48 loops=1)

  • Join Filter: (lima_delta1.lima_echo = kilo_foxtrot1.quebec_seven)
8. 0.047 53.749 ↓ 12.0 48 1

Nested Loop (cost=336.77..7,458.95 rows=4 width=998) (actual time=1.988..53.749 rows=48 loops=1)

9. 0.101 53.606 ↓ 12.0 48 1

Nested Loop (cost=336.48..7,457.55 rows=4 width=987) (actual time=1.980..53.606 rows=48 loops=1)

  • Join Filter: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
  • Rows Removed by Join Filter: 576
10. 0.010 0.010 ↑ 1.0 13 1

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

11. 0.053 53.495 ↓ 12.0 48 13

Materialize (cost=336.48..7,455.65 rows=4 width=978) (actual time=0.152..4.115 rows=48 loops=13)

12. 4.166 53.442 ↓ 12.0 48 1

Nested Loop Left Join (cost=336.48..7,455.63 rows=4 width=978) (actual time=1.969..53.442 rows=48 loops=1)

  • Join Filter: (lima_delta1.juliet_hotel = india1.quebec_hotel)
  • Rows Removed by Join Filter: 20,491
  • Filter: ((lima_delta1.juliet_hotel = 81) OR (india1.yankee_zulu = 81))
  • Rows Removed by Filter: 6,784
13. 0.886 49.276 ↓ 569.3 6,832 1

Nested Loop Left Join (cost=336.48..7,453.85 rows=12 width=986) (actual time=1.959..49.276 rows=6,832 loops=1)

14. 3.016 41.558 ↓ 569.3 6,832 1

Nested Loop (cost=336.20..7,448.75 rows=12 width=319) (actual time=1.954..41.558 rows=6,832 loops=1)

15. 2.481 31.710 ↓ 50.6 6,832 1

Hash Join (cost=335.93..7,406.94 rows=135 width=231) (actual time=1.944..31.710 rows=6,832 loops=1)

  • Hash Cond: ((lima_delta1.juliet_hotel = alpha_oscar1.foxtrot_charlie) AND (lima_delta1.lima_echo = alpha_oscar1.uniform_bravo))
16. 27.319 27.319 ↓ 1.7 6,832 1

Index Scan using papa_yankee on foxtrot_romeo quebec_sierra (cost=0.56..7,049.84 rows=4,138 width=179) (actual time=0.020..27.319 rows=6,832 loops=1)

  • Index Cond: ((lima_romeo)::text = 'quebec_quebec'::text)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND (mike_seven >= 'charlie_sierra'::timestamp without time zone))
  • Rows Removed by Filter: 20,178
17. 0.729 1.910 ↓ 1.0 5,539 1

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

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

19. 6.832 6.832 ↑ 1.0 1 6,832

Index Scan using two_delta on echo_zulu mike_quebec (cost=0.27..0.31 rows=1 width=96) (actual time=0.001..0.001 rows=1 loops=6,832)

  • Index Cond: (quebec_seven = lima_delta1.juliet_hotel)
20. 6.832 6.832 ↓ 0.0 0 6,832

Index Scan using five_oscar on juliet_november romeo_kilo (cost=0.28..0.42 rows=1 width=675) (actual time=0.001..0.001 rows=0 loops=6,832)

  • Index Cond: (lima_delta1.quebec_seven = sierra_foxtrot)
21. 0.000 0.000 ↑ 1.0 3 6,832

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

22. 0.006 0.006 ↑ 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.006 rows=3 loops=1)

  • Filter: ((juliet_charlie)::text = 'kilo_papa'::text)
  • Rows Removed by Filter: 1
23. 0.096 0.096 ↑ 1.0 1 48

Index Scan using kilo_charlie on golf_five uniform_romeo (cost=0.28..0.35 rows=1 width=27) (actual time=0.002..0.002 rows=1 loops=48)

  • Index Cond: (quebec_seven = lima_delta1.two_romeo)
24. 0.096 0.096 ↑ 1.0 1 48

Index Scan using sierra_delta on sierra_three whiskey_six (cost=0.28..0.41 rows=1 width=67) (actual time=0.002..0.002 rows=1 loops=48)

  • Index Cond: (quebec_seven = alpha_oscar1.uniform_bravo)
25. 0.144 0.144 ↑ 1.0 1 48

Index Scan using charlie_alpha on uniform_kilo victor_romeo (cost=0.43..2.51 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=48)

  • Index Cond: (sierra_foxtrot = lima_delta1.quebec_seven)
26. 0.048 0.048 ↑ 1.0 1 48

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

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

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

  • Index Cond: (echo_seven1.delta_kilo = quebec_seven)
Planning time : 20.146 ms
Execution time : 55.304 ms