explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.240 8.795 ↓ 32.0 32 1

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

2. 0.070 8.555 ↓ 32.0 32 1

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

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

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

4. 0.010 8.377 ↓ 32.0 32 1

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

5. 0.011 0.011 ↑ 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.010..0.011 rows=1 loops=1)

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

Bitmap Heap Scan on foxtrot_romeo four (cost=75.48..76.61 rows=1 width=174) (actual time=3.839..8.356 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.152 1.750 ↓ 0.0 0 1

BitmapAnd (cost=75.48..75.48 rows=1 width=0) (actual time=1.749..1.750 rows=0 loops=1)

8. 0.764 0.764 ↓ 1.9 3,880 1

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

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

Bitmap Index Scan on uniform (cost=0.00..40.39 rows=1,498 width=0) (actual time=0.834..0.834 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.526 ms
Execution time : 8.858 ms