explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FPdz : Optimization for: plan #eps8

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 11.178 ↑ 1.0 1 1

Subquery Scan on t1 (cost=1,617.91..1,617.92 rows=1 width=32) (actual time=11.177..11.178 rows=1 loops=1)

2. 0.011 11.176 ↑ 1.0 1 1

Aggregate (cost=1,617.91..1,617.92 rows=1 width=96) (actual time=11.175..11.176 rows=1 loops=1)

3.          

Initplan (forAggregate)

4. 0.008 9.151 ↑ 1.0 1 1

Aggregate (cost=1,158.66..1,158.66 rows=1 width=32) (actual time=9.151..9.151 rows=1 loops=1)

5. 1.926 9.143 ↓ 5.0 5 1

Nested Loop Left Join (cost=4.64..1,158.66 rows=1 width=10) (actual time=9.039..9.143 rows=5 loops=1)

  • 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: 963
6. 1.177 1.409 ↓ 5.5 968 1

Bitmap Heap Scan on intran intran_1 (cost=4.56..458.20 rows=176 width=40) (actual time=0.371..1.409 rows=968 loops=1)

  • Recheck Cond: (((inven)::text = 'BSMOD-200REGWH36X6'::text) AND ((warehouse)::text = '1-PLANT'::text))
  • Filter: ((doc_role)::text = 'O'::text)
  • Rows Removed by Filter: 443
  • Heap Blocks: exact=1312
7. 0.232 0.232 ↓ 6.1 1,411 1

Bitmap Index Scan on idx_btree_inven_warehouse (cost=0.00..4.55 rows=233 width=0) (actual time=0.232..0.232 rows=1,411 loops=1)

  • Index Cond: (((inven)::text = 'BSMOD-200REGWH36X6'::text) AND ((warehouse)::text = '1-PLANT'::text))
8. 5.808 5.808 ↑ 1.0 1 968

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

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

Bitmap Heap Scan on intran (cost=4.56..458.55 rows=231 width=15) (actual time=1.973..2.014 rows=3 loops=1)

  • Recheck Cond: (((inven)::text = 'BSMOD-200REGWH36X6'::text) AND ((warehouse)::text = '1-PLANT'::text))
  • Filter: ((COALESCE(q_order_in, '0'::numeric) <> COALESCE(q_linked_p, '0'::numeric)) AND (COALESCE(q_ship_in, '0'::numeric) <> '0'::numeric) AND ((doc_status <> '0'::numeric) OR ((doc_role)::text <> 'O'::text)))
  • Rows Removed by Filter: 1408
  • Heap Blocks: exact=1312
10. 0.249 0.249 ↓ 6.1 1,411 1

Bitmap Index Scan on idx_btree_inven_warehouse (cost=0.00..4.55 rows=233 width=0) (actual time=0.249..0.249 rows=1,411 loops=1)

  • Index Cond: (((inven)::text = 'BSMOD-200REGWH36X6'::text) AND ((warehouse)::text = '1-PLANT'::text))