explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6MR0 : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #E3qw; plan #BFpM; plan #zYcE; plan #9E4V; plan #5PSt; plan #50k; plan #r9or; plan #CowG

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.099 12.774 ↑ 1.3 3 1

Result (cost=681.52..682.58 rows=4 width=249) (actual time=12.745..12.774 rows=3 loops=1)

  • Buffers: shared hit=4,174
2. 0.017 12.675 ↑ 1.3 3 1

Sort (cost=681.52..681.53 rows=4 width=264) (actual time=12.671..12.675 rows=3 loops=1)

  • Sort Key: romeo1.lima_romeo, romeo1.foxtrot_bravo DESC, romeo1.mike DESC
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=4,174
3. 0.005 12.658 ↑ 1.3 3 1

Nested Loop Left Join (cost=656.62..681.48 rows=4 width=264) (actual time=12.642..12.658 rows=3 loops=1)

  • Buffers: shared hit=4,174
4. 0.007 12.641 ↑ 1.3 3 1

Nested Loop (cost=656.20..670.89 rows=4 width=235) (actual time=12.629..12.641 rows=3 loops=1)

  • Join Filter: (romeo1.mike >= romeo2.echo_six)
  • Buffers: shared hit=4,165
5. 0.011 0.011 ↑ 1.0 1 1

Index Scan using sierra_delta on sierra_three foxtrot_juliet (cost=0.28..2.50 rows=1 width=85) (actual time=0.009..0.011 rows=1 loops=1)

  • Index Cond: (quebec_seven = 657)
  • Buffers: shared hit=3
6. 0.016 12.623 ↑ 3.7 3 1

Bitmap Heap Scan on foxtrot_romeo four (cost=655.92..668.26 rows=11 width=174) (actual time=12.615..12.623 rows=3 loops=1)

  • Recheck Cond: ((lima_echo = 657) AND (((lima_romeo)::text = 'quebec_quebec'::text) OR ((lima_romeo)::text = 'two'::text) OR ((lima_romeo)::text = 'golf'::text) OR ((lima_romeo)::text = 'kilo'::text)))
  • Filter: ((NOT seven) AND ((NOT papa_bravo) OR (papa_bravo five NULL)))
  • Heap Blocks: exact=3
  • Buffers: shared hit=4,162
7. 0.153 12.607 ↓ 0.0 0 1

BitmapAnd (cost=655.92..655.92 rows=11 width=0) (actual time=12.604..12.607 rows=0 loops=1)

  • Buffers: shared hit=4,159
8. 0.289 0.289 ↓ 1.2 1,742 1

Bitmap Index Scan on three (cost=0.00..26.07 rows=1,511 width=0) (actual time=0.289..0.289 rows=1,742 loops=1)

  • Index Cond: (lima_echo = 657)
  • Buffers: shared hit=12
9. 0.003 12.165 ↓ 0.0 0 1

BitmapOr (cost=629.60..629.60 rows=40,380 width=0) (actual time=12.164..12.165 rows=0 loops=1)

  • Buffers: shared hit=4,147
10. 6.296 6.296 ↑ 1.1 27,045 1

Bitmap Index Scan on papa_yankee (cost=0.00..463.59 rows=29,911 width=0) (actual time=6.296..6.296 rows=27,045 loops=1)

  • Index Cond: ((lima_romeo)::text = 'quebec_quebec'::text)
  • Buffers: shared hit=1,735
11. 5.194 5.194 ↓ 1.2 9,433 1

Bitmap Index Scan on papa_yankee (cost=0.00..125.75 rows=8,039 width=0) (actual time=5.194..5.194 rows=9,433 loops=1)

  • Index Cond: ((lima_romeo)::text = 'two'::text)
  • Buffers: shared hit=2,156
12. 0.657 0.657 ↓ 1.3 3,273 1

Bitmap Index Scan on papa_yankee (cost=0.00..38.58 rows=2,430 width=0) (actual time=0.657..0.657 rows=3,273 loops=1)

  • Index Cond: ((lima_romeo)::text = 'golf'::text)
  • Buffers: shared hit=252
13. 0.015 0.015 ↓ 0.0 0 1

Bitmap Index Scan on papa_yankee (cost=0.00..1.67 rows=1 width=0) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((lima_romeo)::text = 'kilo'::text)
  • Buffers: shared hit=4
14. 0.012 0.012 ↓ 0.0 0 3

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

  • Index Cond: (romeo1.quebec_seven = sierra_foxtrot)
  • Buffers: shared hit=9
Planning time : 0.424 ms
Execution time : 12.850 ms