explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3MRi : Optimization for: plan #M4MS

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 15.243 ↓ 0.0 0 1

Result (cost=81.77..82.04 rows=1 width=249) (actual time=15.239..15.243 rows=0 loops=1)

2. 0.007 15.242 ↓ 0.0 0 1

Sort (cost=81.77..81.78 rows=1 width=264) (actual time=15.239..15.242 rows=0 loops=1)

  • Sort Key: romeo1.lima_romeo, romeo1.foxtrot_bravo DESC, romeo1.mike DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.001 15.235 ↓ 0.0 0 1

Nested Loop Left Join (cost=76.19..81.76 rows=1 width=264) (actual time=15.232..15.235 rows=0 loops=1)

4. 0.003 15.234 ↓ 0.0 0 1

Nested Loop (cost=75.77..79.11 rows=1 width=235) (actual time=15.231..15.234 rows=0 loops=1)

5. 0.014 0.014 ↑ 1.0 1 1

Index Scan using hotel on sierra_three foxtrot_juliet (cost=0.28..2.50 rows=1 width=77) (actual time=0.011..0.014 rows=1 loops=1)

  • Index Cond: ((juliet)::text = 'foxtrot_two'::text)
6. 12.735 15.217 ↓ 0.0 0 1

Bitmap Heap Scan on foxtrot_romeo four (cost=75.48..76.60 rows=1 width=174) (actual time=15.215..15.217 rows=0 loops=1)

  • Recheck Cond: ((lima_echo = romeo2.quebec) AND ((golf)::text = 'delta'::text))
  • Filter: ((NOT seven) AND ((NOT papa) OR (papa five NULL)) AND ((lima_romeo)::text = ANY ('lima_five'::text[])))
  • Rows Removed by Filter: 6,073
  • Heap Blocks: exact=5,922
7. 0.249 2.482 ↓ 0.0 0 1

BitmapAnd (cost=75.48..75.48 rows=1 width=0) (actual time=2.480..2.482 rows=0 loops=1)

8. 0.998 0.998 ↓ 2.9 6,133 1

Bitmap Index Scan on three (cost=0.00..34.84 rows=2,094 width=0) (actual time=0.998..0.998 rows=6,133 loops=1)

  • Index Cond: (lima_echo = romeo2.quebec)
9. 1.235 1.235 ↓ 4.1 6,133 1

Bitmap Index Scan on uniform (cost=0.00..40.39 rows=1,498 width=0) (actual time=1.234..1.235 rows=6,133 loops=1)

  • Index Cond: ((golf)::text = 'delta'::text)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using whiskey on echo india (cost=0.42..2.64 rows=1 width=45) (never executed)

  • Index Cond: (romeo1.quebec = sierra_foxtrot)
Planning time : 0.476 ms
Execution time : 15.306 ms