# Result: AUP : Optimization for: plan #9SBx

Settings

### Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 30.686 114.366 ↓ 2.2 576 1

Gather (cost=1,001.56..25,891.64 rows=267 width=258) (actual time=2.676..114.366 rows=576 loops=1)

• Workers Planned: 2
• Workers Launched: 2
2. 5.358 83.680 ↓ 1.7 192 3

(cost=1.56..24,864.16 rows=111 width=258) (actual time=5.450..83.680 rows=192 loops=3)

3. 5.172 78.301 ↓ 1.7 192 3

(cost=1.14..24,810.84 rows=111 width=168) (actual time=5.372..78.301 rows=192 loops=3)

4. 4.754 73.107 ↓ 1.7 192 3

(cost=0.71..24,569.82 rows=111 width=148) (actual time=5.312..73.107 rows=192 loops=3)

5. 7.313 68.335 ↓ 1.7 192 3

(cost=0.43..24,513.44 rows=111 width=135) (actual time=5.251..68.335 rows=192 loops=3)

6. 60.987 60.987 ↑ 1.2 182 3

Parallel Seq Scan on arinv w_arinv (cost=0.00..9,232.54 rows=224 width=48) (actual time=0.588..60.987 rows=182 loops=3)

• Filter: ((progress >= '30'::numeric) AND (progress < '60'::numeric))
• Rows Removed by Filter: 33446
7. 0.035 0.035 ↑ 1.0 1 547

Index Scan using arinvdet_docaid_idx on arinvdet w_arinvdet (cost=0.43..68.21 rows=1 width=104) (actual time=0.029..0.035 rows=1 loops=547)

• Index Cond: ((doc_aid)::text = (w_arinv.autoid)::text)
• Filter: (mto IS TRUE)
• Rows Removed by Filter: 5
8. 0.018 0.018 ↑ 1.0 1 576

Index Scan using idx_btree_inventry_id on inventry w_inventry (cost=0.29..0.50 rows=1 width=13) (actual time=0.017..0.018 rows=1 loops=576)

• Index Cond: ((w_arinvdet.inven)::text = (id)::text)
9. 0.022 0.022 ↑ 1.0 1 576