explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6B5X : Optimization for: plan #TLPF

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.071 5.361 ↑ 1.0 1 1

Nested Loop Left Join (cost=67.41..73.24 rows=1 width=241) (actual time=5.307..5.361 rows=1 loops=1)

2. 0.006 5.284 ↑ 1.0 1 1

Nested Loop (cost=66.99..70.34 rows=1 width=227) (actual time=5.231..5.284 rows=1 loops=1)

  • Join Filter: (romeo1.mike >= romeo2.echo_six)
3. 4.269 5.264 ↑ 1.0 1 1

Bitmap Heap Scan on foxtrot_romeo four (cost=66.71..67.83 rows=1 width=174) (actual time=5.212..5.264 rows=1 loops=1)

  • Recheck Cond: ((lima_echo = 657) AND ((golf)::text = 'uniform_delta'::text))
  • Filter: ((NOT seven) AND ((NOT papa) OR (papa five NULL)) AND ((lima_romeo)::text = ANY ('lima_five'::text[])))
  • Rows Removed by Filter: 1,673
  • Heap Blocks: exact=1,676
4. 0.068 0.995 ↓ 0.0 0 1

BitmapAnd (cost=66.71..66.71 rows=1 width=0) (actual time=0.994..0.995 rows=0 loops=1)

5. 0.339 0.339 ↓ 1.1 1,732 1

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

  • Index Cond: (lima_echo = 657)
6. 0.588 0.588 ↓ 1.2 1,732 1

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

  • Index Cond: ((golf)::text = 'uniform_delta'::text)
7. 0.014 0.014 ↑ 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.013..0.014 rows=1 loops=1)

  • Index Cond: (quebec = 657)
8. 0.006 0.006 ↓ 0.0 0 1

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

  • Index Cond: (romeo1.quebec = sierra_foxtrot)
Planning time : 0.575 ms
Execution time : 5.417 ms