explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R6nv : Optimization for: plan #t1nF

Settings

Optimization path:

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

Result (cost=73.00..73.27 rows=1 width=249) (actual time=1.781..1.785 rows=1 loops=1)

2. 0.011 1.714 ↑ 1.0 1 1

Sort (cost=73.00..73.01 rows=1 width=264) (actual time=1.711..1.714 rows=1 loops=1)

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

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

4. 0.004 1.694 ↑ 1.0 1 1

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

5. 1.380 1.676 ↑ 1.0 1 1

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

  • Recheck Cond: ((lima_echo = 3,126) 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
6. 0.029 0.296 ↓ 0.0 0 1

BitmapAnd (cost=66.71..66.71 rows=1 width=0) (actual time=0.295..0.296 rows=0 loops=1)

7. 0.121 0.121 ↑ 2.2 677 1

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

  • Index Cond: (lima_echo = 3,126)
8. 0.146 0.146 ↑ 2.2 677 1

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

  • Index Cond: ((golf_echo)::text = 'papa_india'::text)
9. 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=77) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (quebec_seven = 3,126)
10. 0.006 0.006 ↓ 0.0 0 1

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

  • Index Cond: (romeo1.quebec_seven = sierra_foxtrot)
Planning time : 0.413 ms
Execution time : 1.851 ms