explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TLPF

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.052 3.461 ↑ 1.0 1 1

Result (cost=73.00..73.27 rows=1 width=249) (actual time=3.458..3.461 rows=1 loops=1)

2. 0.009 3.409 ↑ 1.0 1 1

Sort (cost=73.00..73.00 rows=1 width=264) (actual time=3.406..3.409 rows=1 loops=1)

  • Sort Key: romeo1.lima_romeo, romeo1.foxtrot_bravo DESC, romeo1.mike DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.003 3.400 ↑ 1.0 1 1

Nested Loop Left Join (cost=67.41..72.99 rows=1 width=264) (actual time=3.368..3.400 rows=1 loops=1)

4. 0.003 3.392 ↑ 1.0 1 1

Nested Loop (cost=66.99..70.34 rows=1 width=235) (actual time=3.360..3.392 rows=1 loops=1)

  • Join Filter: (romeo1.mike >= romeo2.echo_six)
5. 2.833 3.378 ↑ 1.0 1 1

Bitmap Heap Scan on foxtrot_romeo four (cost=66.71..67.83 rows=1 width=174) (actual time=3.347..3.378 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
6. 0.053 0.545 ↓ 0.0 0 1

BitmapAnd (cost=66.71..66.71 rows=1 width=0) (actual time=0.544..0.545 rows=0 loops=1)

7. 0.206 0.206 ↓ 1.1 1,732 1

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

  • Index Cond: (lima_echo = 657)
8. 0.286 0.286 ↓ 1.2 1,732 1

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

  • Index Cond: ((golf)::text = 'uniform_delta'::text)
9. 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.011..0.011 rows=1 loops=1)

  • Index Cond: (quebec = 657)
10. 0.005 0.005 ↓ 0.0 0 1

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

  • Index Cond: (romeo1.quebec = sierra_foxtrot)
Planning time : 0.372 ms
Execution time : 3.509 ms