explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YTCP : 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 #yWnq; plan #Mjxa; plan #ximH; plan #tFxB; plan #c67q; plan #GF83; plan #WkFQ9; plan #JY3d; plan #C4RI; plan #6usz; plan #lEQ2; plan #BXY; plan #akJx; plan #9Zjc

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.015 56.137 ↓ 4.4 92 1

Limit (cost=7,628.62..7,639.60 rows=21 width=554) (actual time=53.289..56.137 rows=92 loops=1)

2. 2.945 56.122 ↓ 4.4 92 1

Result (cost=7,628.62..7,639.60 rows=21 width=554) (actual time=53.288..56.122 rows=92 loops=1)

3. 0.150 53.177 ↓ 4.4 92 1

Sort (cost=7,628.62..7,628.68 rows=21 width=557) (actual time=53.156..53.177 rows=92 loops=1)

  • Sort Key: lima_delta1.quebec_seven
  • Sort Method: quicksort Memory: 115kB
4. 0.095 53.027 ↓ 4.4 92 1

Nested Loop Left Join (cost=339.12..7,628.16 rows=21 width=557) (actual time=4.034..53.027 rows=92 loops=1)

5. 0.107 52.932 ↓ 4.4 92 1

Nested Loop (cost=338.85..7,621.97 rows=21 width=1,134) (actual time=4.030..52.932 rows=92 loops=1)

6. 0.069 52.641 ↓ 4.4 92 1

Nested Loop (cost=338.57..7,615.82 rows=21 width=1,073) (actual time=4.021..52.641 rows=92 loops=1)

7. 0.052 52.014 ↓ 4.4 93 1

Nested Loop (cost=338.14..7,574.65 rows=21 width=1,049) (actual time=4.008..52.014 rows=93 loops=1)

8. 0.134 51.590 ↓ 4.4 93 1

Nested Loop (cost=337.86..7,568.21 rows=21 width=1,038) (actual time=3.998..51.590 rows=93 loops=1)

  • Join Filter: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
  • Rows Removed by Join Filter: 170
9. 0.039 51.456 ↓ 4.4 93 1

Nested Loop Left Join (cost=337.86..7,563.28 rows=21 width=1,029) (actual time=3.986..51.456 rows=93 loops=1)

10. 0.136 51.231 ↓ 4.4 93 1

Nested Loop (cost=337.58..7,556.48 rows=21 width=362) (actual time=3.978..51.231 rows=93 loops=1)

11. 0.110 50.816 ↓ 4.2 93 1

Nested Loop (cost=337.30..7,549.45 rows=22 width=311) (actual time=3.968..50.816 rows=93 loops=1)

12. 3.370 50.520 ↑ 2.8 93 1

Hash Left Join (cost=337.02..7,472.48 rows=263 width=231) (actual time=3.957..50.520 rows=93 loops=1)

  • Hash Cond: (lima_delta1.juliet_hotel = india1.quebec_hotel)
  • Filter: ((lima_delta1.juliet_hotel = 81) OR ((india1.yankee_zulu = 81) AND ((india1.juliet_charlie)::text = 'kilo_papa'::text)))
  • Rows Removed by Filter: 17,541
13. 8.558 47.138 ↓ 18.0 17,634 1

Hash Join (cost=335.93..7,467.46 rows=978 width=231) (actual time=3.698..47.138 rows=17,634 loops=1)

  • Hash Cond: ((lima_delta1.juliet_hotel = alpha1.foxtrot_charlie) AND (lima_delta1.lima_echo = alpha1.uniform_bravo))
14. 34.933 34.933 ↑ 1.7 17,634 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.033..34.933 rows=17,634 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. 1.565 3.647 ↓ 1.0 5,539 1

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

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

17. 0.003 0.012 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=23) (actual time=0.011..0.012 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
18. 0.009 0.009 ↑ 1.0 4 1

Seq Scan on hotel_three romeo_foxtrot (cost=0.00..1.04 rows=4 width=23) (actual time=0.007..0.009 rows=4 loops=1)

19. 0.186 0.186 ↑ 1.0 1 93

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

  • Index Cond: (quebec_seven = lima_delta1.juliet_hotel)
20. 0.279 0.279 ↑ 1.0 1 93

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

  • Index Cond: (quebec_seven = lima_delta1.lima_echo)
21. 0.186 0.186 ↓ 0.0 0 93

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

  • Index Cond: (lima_delta1.quebec_seven = sierra_foxtrot)
22. 0.000 0.000 ↑ 4.3 3 93

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

23. 0.006 0.006 ↑ 4.3 3 1

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

24. 0.372 0.372 ↑ 1.0 1 93

Index Scan using kilo_charlie on golf uniform_romeo (cost=0.28..0.31 rows=1 width=27) (actual time=0.004..0.004 rows=1 loops=93)

  • Index Cond: (quebec_seven = lima_delta1.two_romeo)
25. 0.558 0.558 ↑ 1.0 1 93

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

  • Index Cond: (sierra_foxtrot = lima_delta1.quebec_seven)
26. 0.184 0.184 ↑ 1.0 1 92

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

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

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

  • Index Cond: (echo_seven1.delta_kilo = quebec_seven)
Planning time : 25.833 ms
Execution time : 56.369 ms