explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eeoo : 4

Settings
# exclusive inclusive rows x rows loops node
1. 54.583 1,892.565 ↓ 10,317.0 10,317 1

Nested Loop (cost=5.28..1,319.49 rows=1 width=203) (actual time=2.290..1,892.565 rows=10,317 loops=1)

2. 33.205 1,540.090 ↓ 53,839.0 53,839 1

Nested Loop Left Join (cost=4.74..1,310.44 rows=1 width=272) (actual time=0.118..1,540.090 rows=53,839 loops=1)

3. 39.597 1,399.207 ↓ 53,839.0 53,839 1

Nested Loop Left Join (cost=4.18..1,307.44 rows=1 width=267) (actual time=0.115..1,399.207 rows=53,839 loops=1)

4. 45.038 1,251.932 ↓ 53,839.0 53,839 1

Nested Loop Left Join (cost=3.63..1,304.43 rows=1 width=262) (actual time=0.113..1,251.932 rows=53,839 loops=1)

5. 13.589 937.699 ↓ 53,839.0 53,839 1

Nested Loop (cost=3.07..1,301.43 rows=1 width=257) (actual time=0.102..937.699 rows=53,839 loops=1)

6. 14.132 816.432 ↓ 53,839.0 53,839 1

Nested Loop (cost=2.79..1,298.96 rows=1 width=289) (actual time=0.096..816.432 rows=53,839 loops=1)

7. 44.199 694.622 ↓ 53,839.0 53,839 1

Nested Loop (cost=2.51..1,296.57 rows=1 width=236) (actual time=0.087..694.622 rows=53,839 loops=1)

8. 38.417 488.906 ↓ 53,839.0 53,839 1

Nested Loop (cost=2.09..1,293.94 rows=1 width=126) (actual time=0.078..488.906 rows=53,839 loops=1)

9. 12.854 127.455 ↓ 53,839.0 53,839 1

Nested Loop (cost=1.54..1,291.06 rows=1 width=82) (actual time=0.065..127.455 rows=53,839 loops=1)

10. 6.716 54.706 ↓ 6,655.0 6,655 1

Nested Loop (cost=0.99..1,286.49 rows=1 width=119) (actual time=0.046..54.706 rows=6,655 loops=1)

11. 8.060 8.060 ↓ 47.9 6,655 1

Index Scan using order_info_idx01 on order_info orderinfo (cost=0.42..648.13 rows=139 width=81) (actual time=0.033..8.060 rows=6,655 loops=1)

  • Index Cond: (((site_id_)::text = 'VA2301'::text) AND ((order_category_id_)::text = 'C044ODTYPESO'::text) AND ((serial_item_flag_)::text = '1'::text))
12. 39.930 39.930 ↑ 1.0 1 6,655

Index Scan using sales_order_idx02 on sales_order salesorder (cost=0.56..4.58 rows=1 width=38) (actual time=0.006..0.006 rows=1 loops=6,655)

  • Index Cond: (((site_id_)::text = 'VA2301'::text) AND ((order_id_)::text = (orderinfo.order_id_)::text))
13. 59.895 59.895 ↑ 1.5 8 6,655

Index Only Scan using sales_order_item_idx02 on sales_order_item salordite (cost=0.55..4.46 rows=12 width=68) (actual time=0.007..0.009 rows=8 loops=6,655)

  • Index Cond: ((sales_order_id_ = (salesorder.order_id_)::text) AND (site_id_ = 'VA2301'::text))
  • Heap Fetches: 79
14. 323.034 323.034 ↑ 1.0 1 53,839

Index Scan using order_item_idx03 on order_item orderitem (cost=0.56..2.87 rows=1 width=81) (actual time=0.006..0.006 rows=1 loops=53,839)

  • Index Cond: (((site_id_)::text = 'VA2301'::text) AND ((order_item_id_)::text = (salordite.order_item_id_)::text))
15. 161.517 161.517 ↑ 1.0 1 53,839

Index Scan using pk_product on product (cost=0.42..2.61 rows=1 width=110) (actual time=0.003..0.003 rows=1 loops=53,839)

  • Index Cond: ((product_id_)::text = (orderitem.product_id_)::text)
16. 107.678 107.678 ↑ 1.0 1 53,839

Index Scan using pk_organization_info on organization_info originfo (cost=0.28..2.38 rows=1 width=53) (actual time=0.002..0.002 rows=1 loops=53,839)

  • Index Cond: ((party_id_)::text = (salesorder.customer_id_)::text)
17. 107.678 107.678 ↑ 1.0 1 53,839

Index Scan using pk_party_info on party_info partyinfo (cost=0.28..2.46 rows=1 width=41) (actual time=0.002..0.002 rows=1 loops=53,839)

  • Index Cond: ((party_id_)::text = (salesorder.customer_id_)::text)
18. 269.195 269.195 ↓ 0.0 0 53,839

Index Scan using order_item_progress_idx01 on order_item_progress boorderitrmproqty (cost=0.56..2.99 rows=1 width=42) (actual time=0.005..0.005 rows=0 loops=53,839)

  • Index Cond: (((order_item_id_)::text = (orderitem.order_item_id_)::text) AND ((order_item_progress_type_id_)::text = 'C041BACKORDERQTY'::text))
19. 107.678 107.678 ↓ 0.0 0 53,839

Index Scan using order_item_progress_idx01 on order_item_progress alloorderitrmproqty (cost=0.56..2.99 rows=1 width=42) (actual time=0.002..0.002 rows=0 loops=53,839)

  • Index Cond: (((order_item_id_)::text = (orderitem.order_item_id_)::text) AND ((order_item_progress_type_id_)::text = 'C041ALLOCATEDQTY'::text))
20. 107.678 107.678 ↓ 0.0 0 53,839

Index Scan using order_item_progress_idx01 on order_item_progress pickorderitrmproqty (cost=0.56..2.99 rows=1 width=42) (actual time=0.002..0.002 rows=0 loops=53,839)

  • Index Cond: (((order_item_id_)::text = (orderitem.order_item_id_)::text) AND ((order_item_progress_type_id_)::text = 'C041ONSHIPPINGQTY'::text))
21. 215.356 215.356 ↓ 0.0 0 53,839

Index Only Scan using product_stock_status_idx02 on product_stock_status prostosta (cost=0.55..3.31 rows=1 width=78) (actual time=0.004..0.004 rows=0 loops=53,839)

  • Index Cond: ((site_id_ = 'VA2301'::text) AND (facility_id_ = (orderinfo.delivery_facility_)::text) AND (product_id_ = (product.product_id_)::text) AND (product_stock_status_type_id_ = 'C071ONHANDQTY'::text) AND (quantity_ > 0::numeric))
  • Heap Fetches: 10317
22.          

SubPlan (forNested Loop)

23. 20.634 20.634 ↑ 1.0 1 10,317

Index Scan using pk_facility_info on facility_info (cost=0.14..4.17 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=10,317)

  • Index Cond: ((facility_id_)::text = (orderinfo.delivery_facility_)::text)
24. 61.902 61.902 ↑ 1.0 1 10,317

Seq Scan on color_info colorinfo (cost=0.00..1.56 rows=1 width=98) (actual time=0.002..0.006 rows=1 loops=10,317)

  • Filter: ((color_id_)::text = (product.color_id_)::text)
  • Rows Removed by Filter: 44