explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l4qr : Optimization for: 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; plan #6MR0

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.104 12.373 ↑ 1.3 3 1

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

  • Buffers: shared hit=4,176
2. 0.018 12.269 ↑ 1.3 3 1

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

  • Sort Key: romeo1.lima_romeo, romeo1.foxtrot_bravo DESC, romeo1.quebec_seven DESC
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=4,176
3. 0.007 12.251 ↑ 1.3 3 1

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

  • Buffers: shared hit=4,176
4. 0.008 12.232 ↑ 1.3 3 1

Nested Loop (cost=656.20..670.89 rows=4 width=227) (actual time=12.219..12.232 rows=3 loops=1)

  • Join Filter: (romeo1.mike >= romeo2.echo_six)
  • Buffers: shared hit=4,167
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.010..0.011 rows=1 loops=1)

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

Bitmap Heap Scan on foxtrot_romeo four (cost=655.92..668.26 rows=11 width=174) (actual time=12.204..12.213 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,164
7. 0.163 12.193 ↓ 0.0 0 1

BitmapAnd (cost=655.92..655.92 rows=11 width=0) (actual time=12.190..12.193 rows=0 loops=1)

  • Buffers: shared hit=4,161
8. 0.266 0.266 ↓ 1.2 1,742 1

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

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

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

  • Buffers: shared hit=4,149
10. 5.584 5.584 ↑ 1.1 27,044 1

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

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

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

  • Index Cond: ((lima_romeo)::text = 'two'::text)
  • Buffers: shared hit=2,158
12. 0.699 0.699 ↓ 1.3 3,274 1

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

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

Bitmap Index Scan on papa_yankee (cost=0.00..1.67 rows=1 width=0) (actual time=0.016..0.016 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.443 ms
Execution time : 12.444 ms