explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vQBZ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 47.184 ↑ 1.5 2 1

Limit (cost=10,385.88..10,385.89 rows=3 width=301) (actual time=47.177..47.184 rows=2 loops=1)

2. 0.018 47.182 ↑ 1.5 2 1

Sort (cost=10,385.88..10,385.89 rows=3 width=301) (actual time=47.177..47.182 rows=2 loops=1)

  • Sort Key: lima_delta1.foxtrot_bravo DESC, ((six_uniform(1, alpha1.six_uniform, lima_delta1.foxtrot_bravo, LOCALTIMESTAMP, lima_delta1.mike))::boolean) DESC, (six_uniform(0, alpha1.six_uniform, lima_delta1.foxtrot_bravo, LOCALTIMESTAMP, lima_delta1.mike)), lima_delta1.mike
  • Sort Method: quicksort Memory: 25kB
3. 0.121 47.164 ↑ 1.5 2 1

Nested Loop Left Join (cost=40.91..10,385.86 rows=3 width=301) (actual time=0.667..47.164 rows=2 loops=1)

  • Join Filter: (lima_delta1.juliet_hotel = alpha1.foxtrot_charlie)
4. 0.012 47.029 ↑ 1.5 2 1

Hash Left Join (cost=40.63..10,383.24 rows=3 width=212) (actual time=0.556..47.029 rows=2 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: 11
5. 0.006 46.545 ↑ 208.0 13 1

Nested Loop Left Join (cost=2.35..10,337.83 rows=2,704 width=220) (actual time=0.070..46.545 rows=13 loops=1)

6. 0.007 46.511 ↑ 323.0 2 1

Nested Loop Left Join (cost=2.06..10,021.99 rows=646 width=212) (actual time=0.062..46.511 rows=2 loops=1)

7. 0.021 46.490 ↑ 323.0 2 1

Hash Join (cost=1.78..9,737.34 rows=646 width=153) (actual time=0.053..46.490 rows=2 loops=1)

  • Hash Cond: (lima_delta1.four_sierra = romeo1.quebec_seven)
8. 46.447 46.447 ↑ 221.1 19 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.026..46.447 rows=19 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,494
9. 0.003 0.022 ↑ 1.0 2 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
10. 0.019 0.019 ↑ 1.0 2 1

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

  • Filter: (yankee_uniform((six_xray)::text) = ANY ('four_yankee'::text[]))
  • Rows Removed by Filter: 11
11. 0.014 0.014 ↑ 1.0 1 2

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

  • Index Cond: (lima_delta1.lima_echo = quebec_seven)
12. 0.028 0.028 ↓ 1.2 6 2

Index Scan using foxtrot_sierra on two foxtrot_four (cost=0.29..0.44 rows=5 width=16) (actual time=0.006..0.014 rows=6 loops=2)

  • Index Cond: (kilo_foxtrot1.quebec_seven = uniform)
13. 0.176 0.472 ↑ 1.0 902 1

Hash (cost=27.00..27.00 rows=902 width=8) (actual time=0.472..0.472 rows=902 loops=1)

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

Index Only Scan using kilo_kilo on oscar yankee_xray (cost=0.28..27.00 rows=902 width=8) (actual time=0.008..0.296 rows=902 loops=1)

  • Heap Fetches: 230
15. 0.014 0.014 ↑ 1.0 1 2

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

  • Index Cond: (kilo_foxtrot1.quebec_seven = uniform)
  • Filter: (foxtrot_charlie = 81)
  • Rows Removed by Filter: 0
Planning time : 1.440 ms
Execution time : 47.292 ms