explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QWjo : Optimization for: Optimization for: Optimization for: Optimization for: plan #yjCs; plan #AWhC; plan #WOyF; plan #XyCOD

Settings

Optimization path:

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

Subquery Scan on t1 (cost=73,006.94..73,006.95 rows=1 width=32) (actual time=449.578..449.580 rows=1 loops=1)

2. 0.007 449.576 ↑ 1.0 1 1

Aggregate (cost=73,006.94..73,006.94 rows=1 width=96) (actual time=449.576..449.576 rows=1 loops=1)

3.          

Initplan (forAggregate)

4. 0.005 185.862 ↑ 1.0 1 1

Aggregate (cost=36,255.80..36,255.81 rows=1 width=32) (actual time=185.861..185.862 rows=1 loops=1)

5. 0.001 185.857 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,000.17..36,255.80 rows=1 width=10) (actual time=185.857..185.857 rows=0 loops=1)

  • Filter: ((arinv.progress = '40'::numeric) OR ((COALESCE((inmfg.start_date)::timestamp with time zone, now()) <= now()) AND (inmfg.status <> '1'::numeric)))
6. 0.002 185.856 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,000.08..36,251.71 rows=1 width=30) (actual time=185.856..185.856 rows=0 loops=1)

7. 9.774 185.854 ↓ 0.0 0 1

Gather (cost=1,000.00..36,247.62 rows=1 width=26) (actual time=185.854..185.854 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
8. 176.080 176.080 ↓ 0.0 0 5

Parallel Seq Scan on intran intran_1 (cost=0.00..35,247.52 rows=1 width=26) (actual time=176.080..176.080 rows=0 loops=5)

  • Filter: (((inven)::text = 'MAHORAIWH2X6X192'::text) AND ((warehouse)::text = '1-PLANT'::text) AND ((doc_role)::text = 'O'::text))
  • Rows Removed by Filter: 268542
9. 0.000 0.000 ↓ 0.0 0

Index Scan using arinv_pkey on arinv (cost=0.08..4.09 rows=1 width=21) (never executed)

  • Index Cond: ((intran_1.doc_aid)::text = (autoid)::text)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using inmfg_pkey on inmfg (cost=0.08..4.09 rows=1 width=25) (never executed)

  • Index Cond: ((intran_1.doc_aid)::text = (autoid)::text)
11. 9.493 263.707 ↓ 0.0 0 1

Gather (cost=1,000.00..36,751.13 rows=1 width=15) (actual time=263.707..263.707 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
12. 254.214 254.214 ↓ 0.0 0 5

Parallel Seq Scan on intran (cost=0.00..35,751.03 rows=1 width=15) (actual time=254.214..254.214 rows=0 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 = 'MAHORAIWH2X6X192'::text) AND ((warehouse)::text = '1-PLANT'::text) AND ((doc_status <> '0'::numeric) OR ((doc_role)::text <> 'O'::text)))
  • Rows Removed by Filter: 268542