explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eps8

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 1,078.434 ↑ 1.0 1 1

Subquery Scan on t1 (cost=150,474.79..150,474.80 rows=1 width=32) (actual time=1,078.432..1,078.434 rows=1 loops=1)

2. 0.026 1,078.430 ↑ 1.0 1 1

Aggregate (cost=150,474.79..150,474.80 rows=1 width=96) (actual time=1,078.429..1,078.430 rows=1 loops=1)

3.          

Initplan (forAggregate)

4. 0.018 497.486 ↑ 1.0 1 1

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

5. 15.248 497.468 ↓ 4.0 4 1

Gather (cost=1,000.08..74,774.40 rows=1 width=10) (actual time=493.425..497.468 rows=4 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
6. 4.970 482.220 ↑ 1.0 1 5

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

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

Parallel Seq Scan on intran intran_1 (cost=0.00..73,599.19 rows=44 width=40) (actual time=16.834..477.234 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
8. 0.016 0.016 ↑ 1.0 1 968

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

  • Index Cond: ((intran_1.doc_aid)::text = (autoid)::text)
9. 5.285 580.918 ↑ 77.0 3 1

Gather (cost=1,000.00..75,699.69 rows=231 width=15) (actual time=577.104..580.918 rows=3 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
10. 575.633 575.633 ↑ 58.0 1 5

Parallel Seq Scan on intran (cost=0.00..74,676.59 rows=58 width=15) (actual time=574.537..575.633 rows=1 loops=5)

  • Filter: ((COALESCE(q_order_in, '0'::numeric) <> COALESCE(q_linked_p, '0'::numeric)) AND (COALESCE(q_ship_in, '0'::numeric) <> '0'::numeric) AND ((inven)::text = 'BSMOD-200REGWH36X6'::text) AND ((warehouse)::text = '1-PLANT'::text) AND ((doc_status <> '0'::numeric) OR ((doc_role)::text <> 'O'::text)))
  • Rows Removed by Filter: 574592