explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E3qw

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.152 5.173 ↓ 2.0 2 1

Nested Loop Left Join (cost=67.41..73.24 rows=1 width=241) (actual time=5.057..5.173 rows=2 loops=1)

  • Output: romeo_three1.juliet_delta, romeo_three1.oscar, romeo_three1.november_seven, romeo_three1.three_five, romeo_three1.foxtrot_bravo, romeo_three1.lima_romeo, romeo_three1.seven_seven, romeo_three2.juliet_delta, romeo_three2.three_zulu, CASE WHEN (quebec_echo(romeo_three2.quebec_bravo) > 1316) THEN romeo_three3.charlie ELSE NULL::character varying END
  • Buffers: shared hit=1,695 read=49
2. 0.043 5.009 ↓ 2.0 2 1

Nested Loop (cost=66.99..70.34 rows=1 width=227) (actual time=4.913..5.009 rows=2 loops=1)

  • Output: romeo_three1.juliet_delta, romeo_three1.oscar, romeo_three1.november_seven, romeo_three1.three_five, romeo_three1.foxtrot_bravo, romeo_three1.lima_romeo, romeo_three1.seven_seven, romeo_three1.quebec_seven, romeo_three2.juliet_delta, romeo_three2.three_zulu, romeo_three2.quebec_bravo
  • Inner Unique: true
  • Join Filter: (romeo_three1.mike >= romeo_three2.echo)
  • Buffers: shared hit=1,689 read=49
3. 4.135 4.882 ↓ 2.0 2 1

Bitmap Heap Scan on two_india four_uniform (cost=66.71..67.83 rows=1 width=174) (actual time=4.793..4.882 rows=2 loops=1)

  • Output: romeo_three1.quebec_seven, romeo_three1.delta_uniform_lima, romeo_three1.three_five, romeo_three1.seven_seven, romeo_three1.november_seven, romeo_three1.mike, romeo_three1.foxtrot_bravo, romeo_three1.golf_echo, romeo_three1.zulu, romeo_three1.oscar, romeo_three1.victor_tango, romeo_three1.lima_echo, romeo_three1.juliet_hotel, romeo_three1.lima_romeo, romeo_three1.november_romeo, romeo_three1.yankee_papa, romeo_three1.four_sierra, romeo_three1.juliet_delta, romeo_three1.papa, romeo_three1.two_romeo, romeo_three1.yankee_tango, romeo_three1.quebec_xray, romeo_three1.whiskey_five, romeo_three1.delta_uniform_two, romeo_three1.seven_bravo
  • Recheck Cond: ((romeo_three1.lima_echo = 657) AND ((romeo_three1.golf_echo)::text = 'uniform_delta'::text))
  • Filter: ((NOT romeo_three1.seven_seven) AND ((NOT romeo_three1.papa) OR (romeo_three1.papa five NULL)) AND ((romeo_three1.lima_romeo)::text = ANY ('lima_five'::text[])))
  • Rows Removed by Filter: 1,674
  • Heap Blocks: exact=1,679
  • Buffers: shared hit=1,683 read=49
4. 0.053 0.747 ↓ 0.0 0 1

BitmapAnd (cost=66.71..66.71 rows=1 width=0) (actual time=0.745..0.747 rows=0 loops=1)

  • Buffers: shared hit=4 read=49
5. 0.259 0.259 ↓ 1.2 1,739 1

Bitmap Index Scan on three_india (cost=0.00..26.07 rows=1,511 width=0) (actual time=0.259..0.259 rows=1,739 loops=1)

  • Index Cond: (romeo_three1.lima_echo = 657)
  • Buffers: shared hit=2 read=10
6. 0.435 0.435 ↓ 1.2 1,739 1

Bitmap Index Scan on uniform_charlie (cost=0.00..40.39 rows=1,498 width=0) (actual time=0.434..0.435 rows=1,739 loops=1)

  • Index Cond: ((romeo_three1.golf_echo)::text = 'uniform_delta'::text)
  • Buffers: shared hit=2 read=39
7. 0.084 0.084 ↑ 1.0 1 2

Index Scan using sierra_delta on six foxtrot_juliet (cost=0.28..2.50 rows=1 width=85) (actual time=0.042..0.042 rows=1 loops=2)

  • Output: romeo_three2.quebec_seven, romeo_three2.delta_uniform_lima, romeo_three2.echo, romeo_three2.lima_seven, romeo_three2.romeo_kilo, romeo_three2.hotel, romeo_three2.lima_delta, romeo_three2.three_zulu, romeo_three2.juliet_delta, romeo_three2.quebec_bravo, romeo_three2.romeo_echo, romeo_three2.papa, romeo_three2.golf_romeo, romeo_three2.india_foxtrot, romeo_three2.uniform_five
  • Index Cond: (romeo_three2.quebec_seven = 657)
  • Buffers: shared hit=6
8. 0.012 0.012 ↓ 0.0 0 2

Index Scan using whiskey_juliet on victor_uniform india_november (cost=0.42..2.64 rows=1 width=45) (actual time=0.006..0.006 rows=0 loops=2)

  • Output: romeo_three3.quebec_seven, romeo_three3.delta_uniform_lima, romeo_three3.sierra_foxtrot, romeo_three3.charlie
  • Index Cond: (romeo_three1.quebec_seven = romeo_three3.sierra_foxtrot)
  • Buffers: shared hit=6
Planning time : 0.605 ms
Execution time : 5.226 ms