explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t1nF

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.077 1.925 ↑ 1.0 1 1

Result (cost=81.78..82.04 rows=1 width=249) (actual time=1.922..1.925 rows=1 loops=1)

2. 0.012 1.848 ↑ 1.0 1 1

Sort (cost=81.78..81.78 rows=1 width=264) (actual time=1.845..1.848 rows=1 loops=1)

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

Nested Loop Left Join (cost=76.19..81.77 rows=1 width=264) (actual time=1.787..1.836 rows=1 loops=1)

4. 0.004 1.823 ↑ 1.0 1 1

Nested Loop (cost=75.77..79.12 rows=1 width=235) (actual time=1.775..1.823 rows=1 loops=1)

5. 0.015 0.015 ↑ 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.014..0.015 rows=1 loops=1)

  • Index Cond: ((juliet)::text = 'golf_xray'::text)
6. 1.479 1.804 ↑ 1.0 1 1

Bitmap Heap Scan on foxtrot_romeo four (cost=75.48..76.61 rows=1 width=174) (actual time=1.757..1.804 rows=1 loops=1)

  • Recheck Cond: ((lima_echo = romeo2.quebec_seven) AND ((golf_echo)::text = 'papa_india'::text))
  • Filter: ((NOT seven) AND ((NOT papa_bravo) OR (papa_bravo five NULL)) AND (((lima_romeo)::text = 'quebec_quebec'::text) OR ((lima_romeo)::text = 'two'::text) OR ((lima_romeo)::text = 'golf_juliet'::text) OR ((lima_romeo)::text = 'kilo'::text)))
  • Rows Removed by Filter: 630
  • Heap Blocks: exact=635
7. 0.033 0.325 ↓ 0.0 0 1

BitmapAnd (cost=75.48..75.48 rows=1 width=0) (actual time=0.323..0.325 rows=0 loops=1)

8. 0.133 0.133 ↑ 3.1 677 1

Bitmap Index Scan on three (cost=0.00..34.84 rows=2,094 width=0) (actual time=0.132..0.133 rows=677 loops=1)

  • Index Cond: (lima_echo = romeo2.quebec_seven)
9. 0.159 0.159 ↑ 2.2 677 1

Bitmap Index Scan on uniform (cost=0.00..40.39 rows=1,498 width=0) (actual time=0.159..0.159 rows=677 loops=1)

  • Index Cond: ((golf_echo)::text = 'papa_india'::text)
10. 0.008 0.008 ↓ 0.0 0 1

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

  • Index Cond: (romeo1.quebec_seven = sierra_foxtrot)
Planning time : 0.595 ms
Execution time : 1.997 ms