explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Zjc : 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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.019 46.015 ↑ 2.7 94 1

Limit (cost=8,255.01..9,330.54 rows=250 width=554) (actual time=39.857..46.015 rows=94 loops=1)

2. 3.031 45.996 ↑ 86.5 94 1

Nested Loop Left Join (cost=8,255.01..43,231.34 rows=8,130 width=554) (actual time=39.856..45.996 rows=94 loops=1)

3. 0.124 42.025 ↑ 85.6 94 1

Nested Loop Left Join (cost=8,254.02..18,584.12 rows=8,045 width=1,049) (actual time=39.668..42.025 rows=94 loops=1)

  • Join Filter: (lima_delta1.juliet_hotel = alpha1.foxtrot_charlie)
  • Rows Removed by Join Filter: 33
4. 0.115 41.619 ↑ 85.6 94 1

Nested Loop Left Join (cost=8,253.74..15,701.11 rows=8,045 width=1,021) (actual time=39.656..41.619 rows=94 loops=1)

5. 0.054 41.222 ↑ 85.6 94 1

Nested Loop Left Join (cost=8,253.46..13,128.80 rows=8,045 width=962) (actual time=39.645..41.222 rows=94 loops=1)

6. 0.113 40.980 ↑ 85.6 94 1

Nested Loop Left Join (cost=8,253.18..10,774.26 rows=8,045 width=866) (actual time=39.634..40.980 rows=94 loops=1)

7. 0.571 40.585 ↑ 85.6 94 1

Merge Left Join (cost=8,252.90..8,306.04 rows=8,045 width=855) (actual time=39.617..40.585 rows=94 loops=1)

  • Merge Cond: (lima_delta1.quebec_seven = zulu1.sierra_foxtrot)
8. 0.105 37.221 ↑ 85.6 94 1

Sort (cost=7,647.27..7,667.39 rows=8,045 width=188) (actual time=37.198..37.221 rows=94 loops=1)

  • Sort Key: lima_delta1.quebec_seven
  • Sort Method: quicksort Memory: 50kB
9. 0.060 37.116 ↑ 85.6 94 1

Hash Left Join (cost=2.94..7,125.40 rows=8,045 width=188) (actual time=0.057..37.116 rows=94 loops=1)

  • Hash Cond: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
10. 3.525 37.045 ↑ 85.6 94 1

Hash Left Join (cost=1.65..7,096.10 rows=8,045 width=179) (actual time=0.042..37.045 rows=94 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
11. 33.510 33.510 ↑ 1.7 17,635 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.027..33.510 rows=17,635 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
12. 0.003 0.010 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=23) (actual time=0.009..0.010 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
13. 0.007 0.007 ↑ 1.0 4 1

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

14. 0.005 0.011 ↑ 1.0 13 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
15. 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)

16. 1.582 2.793 ↑ 1.0 2,541 1

Sort (cost=605.63..612.07 rows=2,575 width=675) (actual time=2.413..2.793 rows=2,541 loops=1)

  • Sort Key: zulu1.sierra_foxtrot
  • Sort Method: quicksort Memory: 1,936kB
17. 1.211 1.211 ↑ 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.010..1.211 rows=2,541 loops=1)

18. 0.282 0.282 ↑ 1.0 1 94

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

  • Index Cond: (lima_delta1.two_romeo = quebec_seven)
19. 0.188 0.188 ↑ 1.0 1 94

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

  • Index Cond: (lima_delta1.juliet_hotel = quebec_seven)
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: (lima_delta1.lima_echo = quebec_seven)
21. 0.282 0.282 ↑ 1.0 1 94

Index Scan using three on delta_alpha five_xray (cost=0.28..0.35 rows=1 width=52) (actual time=0.003..0.003 rows=1 loops=94)

  • Index Cond: (kilo_foxtrot1.quebec_seven = uniform_bravo)
22. 0.094 0.940 ↑ 1.0 1 94

Nested Loop Left Join (cost=0.99..2.54 rows=1 width=118) (actual time=0.009..0.010 rows=1 loops=94)

23. 0.096 0.846 ↑ 1.0 1 94

Nested Loop Left Join (cost=0.71..2.24 rows=1 width=93) (actual time=0.009..0.009 rows=1 loops=94)

24. 0.564 0.564 ↑ 1.0 1 94

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

  • Index Cond: (sierra_foxtrot = lima_delta1.quebec_seven)
25. 0.186 0.186 ↑ 1.0 1 93

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

  • Index Cond: (echo_seven1.four_delta = quebec_seven)
26. 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 : 15.042 ms
Execution time : 46.202 ms