explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aDes : Optimization for: plan #ijhQ

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 30.340 92.261 ↓ 2.2 576 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 4.204 61.921 ↓ 1.7 192 3

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

3. 4.166 57.701 ↓ 1.7 192 3

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

4. 3.842 53.518 ↓ 1.7 192 3

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

5. 5.643 49.662 ↓ 1.7 192 3

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

6. 43.993 43.993 ↑ 1.2 182 3

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

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

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

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

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

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