explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ijhQ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 35.207 1,639.222 ↓ 2.2 576 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 153.983 1,604.015 ↓ 1.7 192 3

Nested Loop Left Join (cost=1.56..24,864.16 rows=111 width=258) (actual time=89.011..1,604.015 rows=192 loops=3)

3. 691.006 1,449.238 ↓ 1.7 192 3

Nested Loop Left Join (cost=1.14..24,810.84 rows=111 width=168) (actual time=88.110..1,449.238 rows=192 loops=3)

4. 20.273 754.622 ↓ 1.7 192 3

Nested Loop Left Join (cost=0.71..24,569.82 rows=111 width=148) (actual time=82.823..754.622 rows=192 loops=3)

5. 681.944 734.253 ↓ 1.7 192 3

Nested Loop (cost=0.43..24,513.44 rows=111 width=135) (actual time=81.836..734.253 rows=192 loops=3)

6. 48.556 48.556 ↑ 1.2 182 3

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

  • Filter: ((progress >= '30'::numeric) AND (progress < '60'::numeric))
  • Rows Removed by Filter: 33446
7. 3.753 3.753 ↑ 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=3.725..3.753 rows=1 loops=547)

  • Index Cond: ((doc_aid)::text = (w_arinv.autoid)::text)
  • Filter: (mto IS TRUE)
  • Rows Removed by Filter: 5
8. 0.096 0.096 ↑ 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.095..0.096 rows=1 loops=576)

  • Index Cond: ((w_arinvdet.inven)::text = (id)::text)
9. 3.610 3.610 ↑ 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=3.574..3.610 rows=1 loops=576)

  • Index Cond: ((w_arinvdet."timestamp")::text = (cdoc_stamp)::text)
10. 0.794 0.794 ↑ 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.791..0.794 rows=1 loops=576)

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