explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fA8s : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #t2vM; plan #JWfy; plan #h6R3; plan #eolZ; plan #PUEu; plan #mnDu

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.087 1.511 ↓ 4.0 4 1

Result (cost=82.09..82.35 rows=1 width=249) (actual time=1.477..1.511 rows=4 loops=1)

2. 0.014 1.424 ↓ 4.0 4 1

Sort (cost=82.09..82.09 rows=1 width=264) (actual time=1.421..1.424 rows=4 loops=1)

  • Sort Key: romeo1.lima_romeo, romeo1.foxtrot_bravo DESC, romeo1.mike DESC
  • Sort Method: quicksort Memory: 26kB
3. 0.005 1.410 ↓ 4.0 4 1

Nested Loop Left Join (cost=76.49..82.08 rows=1 width=264) (actual time=1.391..1.410 rows=4 loops=1)

4. 0.005 1.393 ↓ 4.0 4 1

Nested Loop (cost=76.07..79.43 rows=1 width=235) (actual time=1.382..1.393 rows=4 loops=1)

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

  • Index Cond: ((juliet)::text = 'kilo_two'::text)
6. 1.105 1.376 ↓ 4.0 4 1

Bitmap Heap Scan on foxtrot_romeo four (cost=75.79..76.92 rows=1 width=174) (actual time=1.367..1.376 rows=4 loops=1)

  • Recheck Cond: ((lima_echo = romeo2.quebec_seven) AND ((golf_echo)::text = 'seven_november'::text))
  • Filter: ((NOT seven_seven) AND ((NOT papa) OR (papa five NULL)) AND (mike >= romeo2.echo_six) AND (((lima_romeo)::text = 'quebec_quebec'::text) OR ((lima_romeo)::text = 'two'::text) OR ((lima_romeo)::text = 'golf_juliet'::text) OR ((lima_romeo)::text = 'kilo_five'::text)))
  • Rows Removed by Filter: 511
  • Heap Blocks: exact=514
7. 0.024 0.271 ↓ 0.0 0 1

BitmapAnd (cost=75.79..75.79 rows=1 width=0) (actual time=0.270..0.271 rows=0 loops=1)

8. 0.096 0.096 ↑ 4.0 529 1

Bitmap Index Scan on three (cost=0.00..35.02 rows=2,118 width=0) (actual time=0.096..0.096 rows=529 loops=1)

  • Index Cond: (lima_echo = romeo2.quebec_seven)
9. 0.151 0.151 ↑ 1.6 920 1

Bitmap Index Scan on uniform (cost=0.00..40.52 rows=1,515 width=0) (actual time=0.150..0.151 rows=920 loops=1)

  • Index Cond: ((golf_echo)::text = 'seven_november'::text)
10. 0.012 0.012 ↓ 0.0 0 4

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=4)

  • Index Cond: (romeo1.quebec_seven = sierra_foxtrot)
Planning time : 0.656 ms
Execution time : 1.577 ms