explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lkBq : Optimization for: plan #vQBZ

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 35.551 ↑ 4.0 1 1

Limit (cost=10,109.98..10,112.07 rows=4 width=301) (actual time=35.546..35.551 rows=1 loops=1)

2. 0.039 35.550 ↑ 4.0 1 1

Result (cost=10,109.98..10,112.07 rows=4 width=301) (actual time=35.545..35.550 rows=1 loops=1)

3. 0.005 35.511 ↑ 4.0 1 1

Sort (cost=10,109.98..10,109.99 rows=4 width=304) (actual time=35.506..35.511 rows=1 loops=1)

  • Sort Key: lima_delta1.foxtrot_bravo DESC
  • Sort Method: quicksort Memory: 25kB
4. 0.002 35.506 ↑ 4.0 1 1

Nested Loop Left Join (cost=37.61..10,109.94 rows=4 width=304) (actual time=0.610..35.506 rows=1 loops=1)

  • Join Filter: (lima_delta1.juliet_hotel = alpha1.foxtrot_charlie)
5. 0.002 35.498 ↑ 4.0 1 1

Nested Loop (cost=37.33..10,108.50 rows=4 width=212) (actual time=0.604..35.498 rows=1 loops=1)

6. 0.006 35.491 ↑ 4.0 1 1

Hash Left Join (cost=37.05..10,106.73 rows=4 width=153) (actual time=0.598..35.491 rows=1 loops=1)

  • Hash Cond: (quebec_sierra_sierra1.three_golf = kilo_foxtrot2.quebec_seven)
  • Filter: ((kilo_foxtrot2.quebec_seven = 152) OR (kilo_foxtrot2.quebec_seven five_romeo NULL))
  • Rows Removed by Filter: 6
7. 0.002 35.157 ↑ 483.6 7 1

Nested Loop Left Join (cost=2.06..10,062.81 rows=3,385 width=161) (actual time=0.259..35.157 rows=7 loops=1)

8. 0.010 35.141 ↑ 646.0 1 1

Hash Join (cost=1.78..9,737.34 rows=646 width=153) (actual time=0.252..35.141 rows=1 loops=1)

  • Hash Cond: (lima_delta1.four_sierra = romeo1.quebec_seven)
9. 35.112 35.112 ↑ 233.3 18 1

Index Scan using papa_yankee on foxtrot_romeo quebec_sierra_echo (cost=0.56..9,721.50 rows=4,200 width=144) (actual time=0.107..35.112 rows=18 loops=1)

  • Index Cond: ((lima_romeo)::text = 'juliet_uniform'::text)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND (juliet_hotel = 81))
  • Rows Removed by Filter: 43,501
10. 0.002 0.019 ↑ 1.0 2 1

Hash (cost=1.20..1.20 rows=2 width=25) (actual time=0.019..0.019 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
11. 0.017 0.017 ↑ 1.0 2 1

Seq Scan on tango four_uniform (cost=0.00..1.20 rows=2 width=25) (actual time=0.011..0.017 rows=2 loops=1)

  • Filter: (yankee_uniform((six)::text) = ANY ('four_yankee'::text[]))
  • Rows Removed by Filter: 11
12. 0.014 0.014 ↓ 1.4 7 1

Index Scan using foxtrot_sierra on two foxtrot_four (cost=0.29..0.45 rows=5 width=16) (actual time=0.006..0.014 rows=7 loops=1)

  • Index Cond: (lima_delta1.lima_echo = uniform)
13. 0.095 0.328 ↑ 1.0 902 1

Hash (cost=23.70..23.70 rows=902 width=8) (actual time=0.327..0.328 rows=902 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 44kB
14. 0.233 0.233 ↑ 1.0 902 1

Index Only Scan using kilo_kilo on oscar yankee_xray (cost=0.28..23.70 rows=902 width=8) (actual time=0.006..0.233 rows=902 loops=1)

  • Heap Fetches: 264
15. 0.005 0.005 ↑ 1.0 1 1

Index Scan using sierra_delta on sierra_three whiskey (cost=0.28..0.44 rows=1 width=67) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (quebec_seven = lima_delta1.lima_echo)
16. 0.006 0.006 ↑ 1.0 1 1

Index Scan using three_juliet on delta five_xray (cost=0.28..0.35 rows=1 width=52) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (kilo_foxtrot1.quebec_seven = uniform)
  • Filter: (foxtrot_charlie = 81)
  • Rows Removed by Filter: 1
Planning time : 1.193 ms
Execution time : 35.629 ms