# Result: 19Z : Optimization for: plan #6K3u

Settings

### Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.007 137.677 ↓ 0.0 0 1

(cost=43,228.68..43,234.95 rows=2,505 width=219) (actual time=121.896..137.677 rows=0 loops=1)

• Sort Key: romeo1.lima, romeo1.foxtrot_bravo DESC, romeo1.mike DESC
• Sort Method: quicksort Memory: 25kB
2. 0.002 137.670 ↓ 0.0 0 1

(cost=1,001.26..43,087.27 rows=2,505 width=219) (actual time=121.889..137.670 rows=0 loops=1)

3. 0.010 0.010 ↑ 1.0 1 1

Index Scan using kilo on oscar_oscar victor (cost=0.28..2.49 rows=1 width=69) (actual time=0.008..0.010 rows=1 loops=1)

• Index Cond: (quebec = 152)
4. 18.728 137.658 ↓ 0.0 0 1

Gather (cost=1,000.99..43,059.73 rows=2,505 width=166) (actual time=121.878..137.658 rows=0 loops=1)

• Workers Planned: 1
• Workers Launched: 1
5. 3.225 118.930 ↓ 0.0 0 2 / 2

(cost=0.99..41,809.23 rows=1,474 width=166) (actual time=118.930..118.930 rows=0 loops=2)

6. 35.115 35.115 ↑ 2.0 8,954 2 / 2

Parallel Index Scan using papa_yankee on foxtrot_romeo four_uniform (cost=0.56..6,935.31 rows=17,814 width=166) (actual time=0.039..35.115 rows=8,954 loops=2)

• Index Cond: ((lima)::text = ANY ('oscar_quebec'::text[]))
• Filter: ((NOT papa_bravo) OR (papa_bravo five NULL))
• Rows Removed by Filter: 4,762
7. 80.590 80.590 ↓ 0.0 0 17,909 / 2

Index Scan using charlie on uniform india (cost=0.43..1.95 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=17,909)

• Index Cond: (sierra = romeo1.quebec)
• Filter: (four_delta = 152)
• Rows Removed by Filter: 1
Planning time Execution time : 0.435 ms : 137.730 ms