explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KkaN : Optimization for: Optimization for: Optimization for: plan #M4MS; plan #3MRi; plan #DJP8

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.275 7.973 ↓ 32.0 32 1

Result (cost=81.77..82.04 rows=1 width=249) (actual time=7.751..7.973 rows=32 loops=1)

2. 0.065 7.698 ↓ 32.0 32 1

Sort (cost=81.77..81.78 rows=1 width=264) (actual time=7.693..7.698 rows=32 loops=1)

  • Sort Key: romeo1.lima_romeo, romeo1.foxtrot_bravo DESC, romeo1.quebec DESC
  • Sort Method: quicksort Memory: 39kB
3. 0.004 7.633 ↓ 32.0 32 1

Nested Loop Left Join (cost=76.19..81.76 rows=1 width=264) (actual time=3.242..7.633 rows=32 loops=1)

4. 0.010 7.533 ↓ 32.0 32 1

Nested Loop (cost=75.77..79.12 rows=1 width=227) (actual time=3.232..7.533 rows=32 loops=1)

5. 0.008 0.008 ↑ 1.0 1 1

Index Scan using hotel on sierra_three foxtrot_juliet (cost=0.28..2.50 rows=1 width=85) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: ((juliet)::text = 'seven_november'::text)
6. 5.990 7.515 ↓ 32.0 32 1

Bitmap Heap Scan on foxtrot_romeo four (cost=75.48..76.61 rows=1 width=174) (actual time=3.221..7.515 rows=32 loops=1)

  • Recheck Cond: ((lima_echo = romeo2.quebec) AND ((golf)::text = 'kilo'::text))
  • Filter: ((NOT seven_seven) AND ((NOT papa) OR (papa five NULL)) AND (mike >= romeo2.echo_six) AND ((lima_romeo)::text = ANY ('lima_five'::text[])))
  • Rows Removed by Filter: 3,745
  • Heap Blocks: exact=3,665
7. 0.121 1.525 ↓ 0.0 0 1

BitmapAnd (cost=75.48..75.48 rows=1 width=0) (actual time=1.524..1.525 rows=0 loops=1)

8. 0.693 0.693 ↓ 1.9 3,880 1

Bitmap Index Scan on three (cost=0.00..34.84 rows=2,094 width=0) (actual time=0.693..0.693 rows=3,880 loops=1)

  • Index Cond: (lima_echo = romeo2.quebec)
9. 0.711 0.711 ↓ 2.6 3,880 1

Bitmap Index Scan on uniform (cost=0.00..40.39 rows=1,498 width=0) (actual time=0.711..0.711 rows=3,880 loops=1)

  • Index Cond: ((golf)::text = 'kilo'::text)
10. 0.096 0.096 ↓ 0.0 0 32

Index Scan using whiskey on echo_lima india (cost=0.42..2.64 rows=1 width=45) (actual time=0.003..0.003 rows=0 loops=32)

  • Index Cond: (romeo1.quebec = sierra_foxtrot)
Planning time : 0.372 ms
Execution time : 8.017 ms