explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 50jB : Optimization for: Optimization for: Optimization for: Optimization for: plan #vQBZ; plan #lkBq; plan #ON5C; plan #YH9F

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 34.737 ↓ 2.3 7 1

Limit (cost=9,993.88..9,995.45 rows=3 width=301) (actual time=34.647..34.737 rows=7 loops=1)

2. 0.184 34.735 ↓ 2.3 7 1

Result (cost=9,993.88..9,995.45 rows=3 width=301) (actual time=34.647..34.735 rows=7 loops=1)

3. 0.012 34.551 ↓ 2.3 7 1

Sort (cost=9,993.88..9,993.89 rows=3 width=304) (actual time=34.547..34.551 rows=7 loops=1)

  • Sort Key: lima_delta1.foxtrot_bravo DESC
  • Sort Method: quicksort Memory: 28kB
4. 0.006 34.539 ↓ 2.3 7 1

Nested Loop (cost=2.63..9,993.85 rows=3 width=304) (actual time=0.067..34.539 rows=7 loops=1)

5. 0.006 34.512 ↓ 2.3 7 1

Nested Loop Left Join (cost=2.35..9,992.53 rows=3 width=189) (actual time=0.062..34.512 rows=7 loops=1)

  • Filter: ((quebec_sierra_sierra1.three_golf = 152) OR (quebec_sierra_sierra1.three_golf five_romeo NULL))
  • Rows Removed by Filter: 36
6. 0.004 34.457 ↑ 6.4 7 1

Nested Loop (cost=2.06..9,969.30 rows=45 width=189) (actual time=0.052..34.457 rows=7 loops=1)

7. 0.013 34.432 ↑ 92.3 7 1

Hash Join (cost=1.78..9,737.34 rows=646 width=153) (actual time=0.046..34.432 rows=7 loops=1)

  • Hash Cond: (lima_delta1.four_sierra = romeo1.quebec_seven)
8. 34.403 34.403 ↑ 161.5 26 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.025..34.403 rows=26 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,602
9. 0.002 0.016 ↑ 1.0 2 1

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

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

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

  • Filter: (yankee((six)::text) = ANY ('four_yankee'::text[]))
  • Rows Removed by Filter: 11
11. 0.021 0.021 ↑ 1.0 1 7

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

  • Index Cond: (uniform = lima_delta1.lima_echo)
  • Filter: (foxtrot_charlie = 81)
  • Rows Removed by Filter: 0
12. 0.049 0.049 ↓ 1.2 6 7

Index Scan using foxtrot_sierra on two foxtrot_four (cost=0.29..0.45 rows=5 width=16) (actual time=0.003..0.007 rows=6 loops=7)

  • Index Cond: (lima_delta1.lima_echo = uniform)
13. 0.021 0.021 ↑ 1.0 1 7

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

  • Index Cond: (quebec_seven = lima_delta1.lima_echo)
Planning time : 1.306 ms
Execution time : 34.801 ms