explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AUP : Optimization for: plan #9SBx

Settings

Optimization path:

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

Nested Loop Left Join (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

Nested Loop Left Join (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

Nested Loop Left Join (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

Nested Loop (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

Index Scan using idx_btree_inlink_cdoc on inlink w_inlink (cost=0.43..2.16 rows=1 width=20) (actual time=0.020..0.022 rows=1 loops=576)

  • Index Cond: ((w_arinvdet."timestamp")::text = (cdoc_stamp)::text)
10. 0.021 0.021 ↑ 1.0 1 576

Index Scan using idx_btree_apinvdet_timestamp on apinvdet w_apinvdet (cost=0.42..0.47 rows=1 width=42) (actual time=0.020..0.021 rows=1 loops=576)

  • Index Cond: ((w_inlink.vdoc_stamp)::text = ("timestamp")::text)