explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BVnS : 4

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 1,168.481 ↓ 0.0 0 1

Nested Loop (cost=5.28..1,319.49 rows=1 width=203) (actual time=1,168.481..1,168.481 rows=0 loops=1)

2. 0.026 1,168.301 ↓ 27.0 27 1

Nested Loop Left Join (cost=4.74..1,310.45 rows=1 width=272) (actual time=1,159.319..1,168.301 rows=27 loops=1)

3. 0.007 1,168.221 ↓ 27.0 27 1

Nested Loop Left Join (cost=4.18..1,307.44 rows=1 width=267) (actual time=1,159.314..1,168.221 rows=27 loops=1)

4. 18.902 1,168.133 ↓ 27.0 27 1

Nested Loop (cost=3.63..1,304.44 rows=1 width=262) (actual time=1,159.308..1,168.133 rows=27 loops=1)

5. 6.408 880.036 ↓ 53,839.0 53,839 1

Nested Loop (cost=3.07..1,301.43 rows=1 width=294) (actual time=0.090..880.036 rows=53,839 loops=1)

6. 7.187 765.950 ↓ 53,839.0 53,839 1

Nested Loop (cost=2.79..1,298.96 rows=1 width=326) (actual time=0.084..765.950 rows=53,839 loops=1)

7. 28.407 651.085 ↓ 53,839.0 53,839 1

Nested Loop (cost=2.51..1,296.57 rows=1 width=273) (actual time=0.078..651.085 rows=53,839 loops=1)

8. 19.383 461.161 ↓ 53,839.0 53,839 1

Nested Loop (cost=2.09..1,293.94 rows=1 width=163) (actual time=0.068..461.161 rows=53,839 loops=1)

9. 13.828 118.744 ↓ 53,839.0 53,839 1

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

10. 4.395 51.676 ↓ 6,655.0 6,655 1

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

11. 7.351 7.351 ↓ 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.027..7.351 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.005..0.006 rows=1 loops=6,655)

  • Index Cond: (((site_id_)::text = 'VA2301'::text) AND ((order_id_)::text = (orderinfo.order_id_)::text))
13. 53.240 53.240 ↑ 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.008 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.005..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.001..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.001..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..3.00 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))
  • Filter: (quantity_ > 0::numeric)
19. 0.081 0.081 ↓ 0.0 0 27

Index Scan using order_item_progress_idx01 on order_item_progress alloorderitrmproqty (cost=0.56..2.99 rows=1 width=42) (actual time=0.003..0.003 rows=0 loops=27)

  • Index Cond: (((order_item_id_)::text = (orderitem.order_item_id_)::text) AND ((order_item_progress_type_id_)::text = 'C041ALLOCATEDQTY'::text))
20. 0.054 0.054 ↓ 0.0 0 27

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=27)

  • Index Cond: (((order_item_id_)::text = (orderitem.order_item_id_)::text) AND ((order_item_progress_type_id_)::text = 'C041ONSHIPPINGQTY'::text))
21. 0.162 0.162 ↓ 0.0 0 27

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.006..0.006 rows=0 loops=27)

  • 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: 0
22.          

SubPlan (forNested Loop)

23. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_facility_info on facility_info (cost=0.14..4.17 rows=1 width=22) (never executed)

  • Index Cond: ((facility_id_)::text = (orderinfo.delivery_facility_)::text)
24. 0.000 0.000 ↓ 0.0 0

Seq Scan on color_info colorinfo (cost=0.00..1.56 rows=1 width=98) (never executed)

  • Filter: ((color_id_)::text = (product.color_id_)::text)
Planning time : 10.290 ms
Execution time : 1,168.698 ms