explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vms

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 241.387 ↑ 1.0 1 1

Aggregate (cost=74,774.41..74,774.41 rows=1 width=32) (actual time=241.387..241.387 rows=1 loops=1)

2. 5.652 241.369 ↓ 5.0 5 1

Gather (cost=1,000.08..74,774.40 rows=1 width=10) (actual time=241.355..241.369 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 2.967 235.717 ↑ 1.0 1 5

Nested Loop Left Join (cost=0.08..73,774.30 rows=1 width=10) (actual time=235.563..235.717 rows=1 loops=5)

  • Filter: ((arinv.progress = '40'::numeric) OR ((COALESCE(intran.q_ship_in, '0'::numeric) <> '0'::numeric) AND (COALESCE(intran.q_order_in, '0'::numeric) <> COALESCE(intran.q_linked_p, '0'::numeric)) AND (intran.doc_status = '0'::numeric)))
  • Rows Removed by Filter: 193
4. 232.738 232.738 ↓ 4.4 194 5

Parallel Seq Scan on intran (cost=0.00..73,599.19 rows=44 width=40) (actual time=8.386..232.738 rows=194 loops=5)

  • Filter: (((inven)::text = 'BSMOD-200REGWH36X6'::text) AND ((warehouse)::text = '1-PLANT'::text) AND ((doc_role)::text = 'O'::text))
  • Rows Removed by Filter: 574399
5. 0.012 0.012 ↑ 1.0 1 968

Index Scan using arinv_pkey on arinv (cost=0.08..3.97 rows=1 width=21) (actual time=0.012..0.012 rows=1 loops=968)

  • Index Cond: ((intran.doc_aid)::text = (autoid)::text)