explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K6BF

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 20,820.414 ↑ 4.6 5 1

Limit (cost=250,630.41..250,630.47 rows=23 width=1,969) (actual time=20,820.410..20,820.414 rows=5 loops=1)

  • Output: product1_.em_obretss_hassequence, product1_.em_obretss_hasownsequence, ((SubPlan 1)), product1_.em_phbutpg_giftcardsubtype, product1_.em_phinum_amountmax, product1_.em_phinum_amountmin, ((COALE
  • Buffers: shared hit=193302 read=62115
2. 0.067 20,820.410 ↑ 4.6 5 1

Sort (cost=250,630.41..250,630.47 rows=23 width=1,969) (actual time=20,820.408..20,820.410 rows=5 loops=1)

  • Output: product1_.em_obretss_hassequence, product1_.em_obretss_hasownsequence, ((SubPlan 1)), product1_.em_phbutpg_giftcardsubtype, product1_.em_phinum_amountmax, product1_.em_phinum_amountmin, ((COALESCE((SubPlan 2), '0'::numeric) * product_co8_.em_phieco_dea_qty)), ((COALESCE((SubPlan 3), '0'::numeric) * product_co8_.em_phieco_deee_qty)), product1_.em_phieco_dea, product1_.em_phieco_deee, product1_.em_gcnv_giftcardtype, obretco_pr0_.em_butimas_productfollowed, pricingpro4_.em_obbutf_purchaseprice, product1_.em_obrdc_delivery_condition, product1_.em_obrdc_delivery_cond_lyw, product1_.em_obrdc_isdeliveryservice, product1_.em_obrcifp_itemdeclaration, obretco_pr0_.em_obpr_ranking_id, obretco_pr0_.em_obrpr_relevance, obretco_pr0_.bestseller, ((SubPlan 4)), product1_.em_obpgc_printcard, ((SubPlan 5)), ((SubPlan 6)), product1_.em_obgcne_expirationdays, product1_.em_phieco_dea_qty, product1_.em_phieco_deee_qty, ((SubPlan 7)), ((SubPlan 8)), ((SubPlan 9)), product1_.em_butimas_gcn_label, product1_.em_butimas_gcn_typevalue, product1_.em_butimas_gcn_is_product, product1_.m_product_id, product1_.value, product1_.name, product1_.m_product_category_id, product1_.em_obpos_scale, product1_.c_uom_id, uom18_.uomsymbol, (COALESCE(uom18_.stdprecision)), product1_.upc, product1_.description, product1_.em_obpos_groupedproduct, product1_.isstocked, product1_.em_obpos_showstock, product1_.isgeneric, product1_.islocked, product1_.issalediscontinued, product1_.generic_product_id, product1_.m_brand_id, product1_.characteristic_desc, product1_.em_obpos_show_ch_desc, product1_.producttype, product1_.prod_cat_selection, product1_.product_selection, product1_.print_description, product1_.em_obpos_allowanonymoussale, product1_.returnable, product1_.overdue_return_days, product1_.ispricerulebased, product1_.em_obpos_proposal_type, product1_.em_obpos_ismultiselectable, product1_.islinkedtoproduct, product1_.ismodifytax, product1_.allow_deferred_sell, product1_.deferred_sell_max_days, product1_.quantity_rule, product1_.em_obpos_printservices, product1_.em_obpos_editable_price, pricingpro4_.pricestd, product1_.c_taxcategory_id, adimage2_.binarydata, adimage2_.ad_image_id, obretco_pr0_.issalediscontinued, ('false'), pricingpro4_.pricelist, pricingpro4_.pricelimit, pricingpro4_.cost, pricingpro4_.algorithm, (CASE WHEN ((product1_.isactive = 'Y'::bpchar) AND (obretco_pr0_.isactive IS NOT NULL)) THEN obretco_pr0_.isactive ELSE product1_.isactive END), obretco_pr0_.m_product_id
  • Sort Key: product1_.name, product1_.m_product_id
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=193302 read=62115
3. 0.190 20,820.343 ↑ 4.6 5 1

Nested Loop (cost=2.23..250,629.89 rows=23 width=1,969) (actual time=6,558.528..20,820.343 rows=5 loops=1)

  • Output: product1_.em_obretss_hassequence, product1_.em_obretss_hasownsequence, (SubPlan 1), product1_.em_phbutpg_giftcardsubtype, product1_.em_phinum_amountmax, product1_.em_phinum_amountmin, (COALESCE((SubPlan 2), '0'::numeric) * product_co8_.em_phieco_dea_qty), (COALESCE((SubPlan 3), '0'::numeric) * product_co8_.em_phieco_deee_qty), product1_.em_phieco_dea, product1_.em_phieco_deee, product1_.em_gcnv_giftcardtype, obretco_pr0_.em_butimas_productfollowed, pricingpro4_.em_obbutf_purchaseprice, product1_.em_obrdc_delivery_condition, product1_.em_obrdc_delivery_cond_lyw, product1_.em_obrdc_isdeliveryservice, product1_.em_obrcifp_itemdeclaration, obretco_pr0_.em_obpr_ranking_id, obretco_pr0_.em_obrpr_relevance, obretco_pr0_.bestseller, (SubPlan 4), product1_.em_obpgc_printcard, (SubPlan 5), (SubPlan 6), product1_.em_obgcne_expirationdays, product1_.em_phieco_dea_qty, product1_.em_phieco_deee_qty, (SubPlan 7), (SubPlan 8), (SubPlan 9), product1_.em_butimas_gcn_label, product1_.em_butimas_gcn_typevalue, product1_.em_butimas_gcn_is_product, product1_.m_product_id, product1_.value, product1_.name, product1_.m_product_category_id, product1_.em_obpos_scale, product1_.c_uom_id, uom18_.uomsymbol, COALESCE(uom18_.stdprecision), product1_.upc, product1_.description, product1_.em_obpos_groupedproduct, product1_.isstocked, product1_.em_obpos_showstock, product1_.isgeneric, product1_.islocked, product1_.issalediscontinued, product1_.generic_product_id, product1_.m_brand_id, product1_.characteristic_desc, product1_.em_obpos_show_ch_desc, product1_.producttype, product1_.prod_cat_selection, product1_.product_selection, product1_.print_description, product1_.em_obpos_allowanonymoussale, product1_.returnable, product1_.overdue_return_days, product1_.ispricerulebased, product1_.em_obpos_proposal_type, product1_.em_obpos_ismultiselectable, product1_.islinkedtoproduct, product1_.ismodifytax, product1_.allow_deferred_sell, product1_.deferred_sell_max_days, product1_.quantity_rule, product1_.em_obpos_printservices, product1_.em_obpos_editable_price, pricingpro4_.pricestd, product1_.c_taxcategory_id, adimage2_.binarydata, adimage2_.ad_image_id, obretco_pr0_.issalediscontinued, 'false', pricingpro4_.pricelist, pricingpro4_.pricelimit, pricingpro4_.cost, pricingpro4_.algorithm, CASE WHEN ((product1_.isactive = 'Y'::bpchar) AND (obretco_pr0_.isactive IS NOT NULL)) THEN obretco_pr0_.isactive ELSE product1_.isactive END, obretco_pr0_.m_product_id
  • Join Filter: ((product1_.c_uom_id)::text = (uom18_.c_uom_id)::text)
  • Rows Removed by Join Filter: 70
  • Buffers: shared hit=193299 read=62115
4. 2.412 20,799.373 ↑ 4.6 5 1

Nested Loop Left Join (cost=2.23..244,729.03 rows=23 width=1,961) (actual time=6,553.688..20,799.373 rows=5 loops=1)

  • Output: obretco_pr0_.obretco_productlist_id, obretco_pr0_.em_butimas_productfollowed, obretco_pr0_.em_obpr_ranking_id, obretco_pr0_.em_obrpr_relevance, obretco_pr0_.bestseller, obretco_pr0_.issalediscontinued, obretco_pr0_.isactive, obretco_pr0_.m_product_id, product1_.em_obretss_hassequence, product1_.em_obretss_hasownsequence, product1_.em_butintp_idproduit, product1_.em_phbutpg_giftcardsubtype, product1_.em_phinum_amountmax, product1_.em_phinum_amountmin, product1_.em_phieco_dea, product1_.em_phieco_deee, product1_.em_gcnv_giftcardtype, product1_.em_obrdc_delivery_condition, product1_.em_obrdc_delivery_cond_lyw, product1_.em_obrdc_isdeliveryservice, product1_.em_obrcifp_itemdeclaration, product1_.em_obpgc_printtemplate_id, product1_.em_obpgc_printcard, product1_.em_obgcne_expirationdays, product1_.em_phieco_dea_qty, product1_.em_phieco_deee_qty, product1_.m_product_id, product1_.em_butimas_gcn_label, product1_.em_butimas_gcn_typevalue, product1_.em_butimas_gcn_is_product, product1_.value, product1_.name, product1_.m_product_category_id, product1_.em_obpos_scale, product1_.c_uom_id, product1_.upc, product1_.description, product1_.em_obpos_groupedproduct, product1_.isstocked, product1_.em_obpos_showstock, product1_.isgeneric, product1_.islocked, product1_.issalediscontinued, product1_.generic_product_id, product1_.m_brand_id, product1_.characteristic_desc, product1_.em_obpos_show_ch_desc, product1_.producttype, product1_.prod_cat_selection, product1_.product_selection, product1_.print_description, product1_.em_obpos_allowanonymoussale, product1_.returnable, product1_.overdue_return_days, product1_.ispricerulebased, product1_.em_obpos_proposal_type, product1_.em_obpos_ismultiselectable, product1_.islinkedtoproduct, product1_.ismodifytax, product1_.allow_deferred_sell, product1_.deferred_sell_max_days, product1_.quantity_rule, product1_.em_obpos_printservices, product1_.em_obpos_editable_price, product1_.c_taxcategory_id, product1_.isactive, adimage2_.binarydata, adimage2_.ad_image_id, product_co8_.em_phieco_dea, product_co8_.em_phieco_dea_qty, product_co8_.em_phieco_deee, product_co8_.em_phieco_deee_qty, pricingpro4_.em_obbutf_purchaseprice, pricingpro4_.pricestd, pricingpro4_.pricelist, pricingpro4_.pricelimit, pricingpro4_.cost, pricingpro4_.algorithm
  • Join Filter: ((product1_.ad_image_id)::text = (adimage2_.ad_image_id)::text)
  • Rows Removed by Join Filter: 20420
  • Buffers: shared hit=192654 read=62071
5. 0.036 20,779.221 ↑ 4.6 5 1

Nested Loop (cost=2.23..242,875.00 rows=23 width=1,514) (actual time=6,537.194..20,779.221 rows=5 loops=1)

  • Output: obretco_pr0_.obretco_productlist_id, obretco_pr0_.em_butimas_productfollowed, obretco_pr0_.em_obpr_ranking_id, obretco_pr0_.em_obrpr_relevance, obretco_pr0_.bestseller, obretco_pr0_.issalediscontinued, obretco_pr0_.isactive, obretco_pr0_.m_product_id, product1_.em_obretss_hassequence, product1_.em_obretss_hasownsequence, product1_.em_butintp_idproduit, product1_.em_phbutpg_giftcardsubtype, product1_.em_phinum_amountmax, product1_.em_phinum_amountmin, product1_.em_phieco_dea, product1_.em_phieco_deee, product1_.em_gcnv_giftcardtype, product1_.em_obrdc_delivery_condition, product1_.em_obrdc_delivery_cond_lyw, product1_.em_obrdc_isdeliveryservice, product1_.em_obrcifp_itemdeclaration, product1_.em_obpgc_printtemplate_id, product1_.em_obpgc_printcard, product1_.em_obgcne_expirationdays, product1_.em_phieco_dea_qty, product1_.em_phieco_deee_qty, product1_.m_product_id, product1_.em_butimas_gcn_label, product1_.em_butimas_gcn_typevalue, product1_.em_butimas_gcn_is_product, product1_.value, product1_.name, product1_.m_product_category_id, product1_.em_obpos_scale, product1_.c_uom_id, product1_.upc, product1_.description, product1_.em_obpos_groupedproduct, product1_.isstocked, product1_.em_obpos_showstock, product1_.isgeneric, product1_.islocked, product1_.issalediscontinued, product1_.generic_product_id, product1_.m_brand_id, product1_.characteristic_desc, product1_.em_obpos_show_ch_desc, product1_.producttype, product1_.prod_cat_selection, product1_.product_selection, product1_.print_description, product1_.em_obpos_allowanonymoussale, product1_.returnable, product1_.overdue_return_days, product1_.ispricerulebased, product1_.em_obpos_proposal_type, product1_.em_obpos_ismultiselectable, product1_.islinkedtoproduct, product1_.ismodifytax, product1_.allow_deferred_sell, product1_.deferred_sell_max_days, product1_.quantity_rule, product1_.em_obpos_printservices, product1_.em_obpos_editable_price, product1_.c_taxcategory_id, product1_.isactive, product1_.ad_image_id, product_co8_.em_phieco_dea, product_co8_.em_phieco_dea_qty, product_co8_.em_phieco_deee, product_co8_.em_phieco_deee_qty, pricingpro4_.em_obbutf_purchaseprice, pricingpro4_.pricestd, pricingpro4_.pricelist, pricingpro4_.pricelimit, pricingpro4_.cost, pricingpro4_.algorithm
  • Join Filter: ((obretco_pr0_.m_product_id)::text = (pricingpro4_.m_product_id)::text)
  • Buffers: shared hit=192648 read=61683
6. 0.027 20,772.030 ↑ 7.0 5 1

Nested Loop (cost=1.67..242,802.09 rows=35 width=1,520) (actual time=6,534.666..20,772.030 rows=5 loops=1)

  • Output: obretco_pr0_.obretco_productlist_id, obretco_pr0_.em_butimas_productfollowed, obretco_pr0_.em_obpr_ranking_id, obretco_pr0_.em_obrpr_relevance, obretco_pr0_.bestseller, obretco_pr0_.issalediscontinued, obretco_pr0_.isactive, obretco_pr0_.m_product_id, product1_.em_obretss_hassequence, product1_.em_obretss_hasownsequence, product1_.em_butintp_idproduit, product1_.em_phbutpg_giftcardsubtype, product1_.em_phinum_amountmax, product1_.em_phinum_amountmin, product1_.em_phieco_dea, product1_.em_phieco_deee, product1_.em_gcnv_giftcardtype, product1_.em_obrdc_delivery_condition, product1_.em_obrdc_delivery_cond_lyw, product1_.em_obrdc_isdeliveryservice, product1_.em_obrcifp_itemdeclaration, product1_.em_obpgc_printtemplate_id, product1_.em_obpgc_printcard, product1_.em_obgcne_expirationdays, product1_.em_phieco_dea_qty, product1_.em_phieco_deee_qty, product1_.m_product_id, product1_.em_butimas_gcn_label, product1_.em_butimas_gcn_typevalue, product1_.em_butimas_gcn_is_product, product1_.value, product1_.name, product1_.m_product_category_id, product1_.em_obpos_scale, product1_.c_uom_id, product1_.upc, product1_.description, product1_.em_obpos_groupedproduct, product1_.isstocked, product1_.em_obpos_showstock, product1_.isgeneric, product1_.islocked, product1_.issalediscontinued, product1_.generic_product_id, product1_.m_brand_id, product1_.characteristic_desc, product1_.em_obpos_show_ch_desc, product1_.producttype, product1_.prod_cat_selection, product1_.product_selection, product1_.print_description, product1_.em_obpos_allowanonymoussale, product1_.returnable, product1_.overdue_return_days, product1_.ispricerulebased, product1_.em_obpos_proposal_type, product1_.em_obpos_ismultiselectable, product1_.islinkedtoproduct, product1_.ismodifytax, product1_.allow_deferred_sell, product1_.deferred_sell_max_days, product1_.quantity_rule, product1_.em_obpos_printservices, product1_.em_obpos_editable_price, product1_.c_taxcategory_id, product1_.isactive, product1_.ad_image_id, product_co8_.em_phieco_dea, product_co8_.em_phieco_dea_qty, product_co8_.em_phieco_deee, product_co8_.em_phieco_deee_qty, product_co8_.m_product_id
  • Buffers: shared hit=192640 read=61665
7. 34.186 20,771.983 ↑ 7.0 5 1

Nested Loop (cost=1.12..242,568.19 rows=35 width=1,411) (actual time=6,534.655..20,771.983 rows=5 loops=1)

  • Output: obretco_pr0_.obretco_productlist_id, obretco_pr0_.em_butimas_productfollowed, obretco_pr0_.em_obpr_ranking_id, obretco_pr0_.em_obrpr_relevance, obretco_pr0_.bestseller, obretco_pr0_.issalediscontinued, obretco_pr0_.isactive, obretco_pr0_.m_product_id, product1_.em_obretss_hassequence, product1_.em_obretss_hasownsequence, product1_.em_butintp_idproduit, product1_.em_phbutpg_giftcardsubtype, product1_.em_phinum_amountmax, product1_.em_phinum_amountmin, product1_.em_phieco_dea, product1_.em_phieco_deee, product1_.em_gcnv_giftcardtype, product1_.em_obrdc_delivery_condition, product1_.em_obrdc_delivery_cond_lyw, product1_.em_obrdc_isdeliveryservice, product1_.em_obrcifp_itemdeclaration, product1_.em_obpgc_printtemplate_id, product1_.em_obpgc_printcard, product1_.em_obgcne_expirationdays, product1_.em_phieco_dea_qty, product1_.em_phieco_deee_qty, product1_.m_product_id, product1_.em_butimas_gcn_label, product1_.em_butimas_gcn_typevalue, product1_.em_butimas_gcn_is_product, product1_.value, product1_.name, product1_.m_product_category_id, product1_.em_obpos_scale, product1_.c_uom_id, product1_.upc, product1_.description, product1_.em_obpos_groupedproduct, product1_.isstocked, product1_.em_obpos_showstock, product1_.isgeneric, product1_.islocked, product1_.issalediscontinued, product1_.generic_product_id, product1_.m_brand_id, product1_.characteristic_desc, product1_.em_obpos_show_ch_desc, product1_.producttype, product1_.prod_cat_selection, product1_.product_selection, product1_.print_description, product1_.em_obpos_allowanonymoussale, product1_.returnable, product1_.overdue_return_days, product1_.ispricerulebased, product1_.em_obpos_proposal_type, product1_.em_obpos_ismultiselectable, product1_.islinkedtoproduct, product1_.ismodifytax, product1_.allow_deferred_sell, product1_.deferred_sell_max_days, product1_.quantity_rule, product1_.em_obpos_printservices, product1_.em_obpos_editable_price, product1_.c_taxcategory_id, product1_.isactive, product1_.ad_image_id
  • Buffers: shared hit=192615 read=61665
8. 14,742.841 14,742.841 ↓ 1.7 42,218 1

Index Scan using obretco_prol_product_act_pl on public.obretco_prol_product obretco_pr0_ (cost=0.56..80,859.79 rows=24,134 width=110) (actual time=1.956..14,742.841 rows=42,218 loops=1)

  • Output: obretco_pr0_.obretco_prol_product_id, obretco_pr0_.ad_client_id, obretco_pr0_.ad_org_id, obretco_pr0_.isactive, obretco_pr0_.created, obretco_pr0_.createdby, obretco_pr0_.updated, obretco_pr0_.updatedby, obretco_pr0_.obretco_productlist_id, obretco_pr0_.m_product_id, obretco_pr0_.bestseller, obretco_pr0_.issalediscontinued, obretco_pr0_.em_obpr_ranking_id, obretco_pr0_.em_obrpr_relevance, obretco_pr0_.em_butimas_productfollowed, obretco_pr0_.em_butimas_date_extraction
  • Index Cond: ((obretco_pr0_.isactive = 'Y'::bpchar) AND ((obretco_pr0_.obretco_productlist_id)::text = '1365D84C84BC4BE6812B1CB40A810B97'::text))
  • Buffers: shared hit=2962 read=39655
9. 5,994.956 5,994.956 ↓ 0.0 0 42,218

Index Scan using m_product_key on public.m_product product1_ (cost=0.56..6.69 rows=1 width=1,301) (actual time=0.142..0.142 rows=0 loops=42,218)

  • Output: product1_.m_product_id, product1_.ad_client_id, product1_.ad_org_id, product1_.isactive, product1_.created, product1_.createdby, product1_.updated, product1_.updatedby, product1_.value, product1_.name, product1_.description, product1_.documentnote, product1_.help, product1_.upc, product1_.sku, product1_.c_uom_id, product1_.salesrep_id, product1_.issummary, product1_.isstocked, product1_.ispurchased, product1_.issold, product1_.isbom, product1_.isinvoiceprintdetails, product1_.ispicklistprintdetails, product1_.isverified, product1_.m_product_category_id, product1_.classification, product1_.volume, product1_.weight, product1_.shelfwidth, product1_.shelfheight, product1_.shelfdepth, product1_.unitsperpallet, product1_.c_taxcategory_id, product1_.s_resource_id, product1_.discontinued, product1_.discontinuedby, product1_.processing, product1_.s_expensetype_id, product1_.producttype, product1_.imageurl, product1_.descriptionurl, product1_.guaranteedays, product1_.versionno, product1_.m_attributeset_id, product1_.m_attributesetinstance_id, product1_.downloadurl, product1_.m_freightcategory_id, product1_.m_locator_id, product1_.ad_image_id, product1_.c_bpartner_id, product1_.ispriceprinted, product1_.name2, product1_.costtype, product1_.coststd, product1_.stock_min, product1_.enforce_attribute, product1_.calculated, product1_.ma_processplan_id, product1_.production, product1_.capacity, product1_.delaymin, product1_.mrp_planner_id, product1_.mrp_planningmethod_id, product1_.qtymax, product1_.qtymin, product1_.qtystd, product1_.qtytype, product1_.stockmin, product1_.attrsetvaluetype, product1_.isquantityvariable, product1_.isdeferredrevenue, product1_.revplantype, product1_.periodnumber, product1_.isdeferredexpense, product1_.expplantype, product1_.periodnumber_exp, product1_.defaultperiod, product1_.defaultperiod_exp, product1_.bookusingpoprice, product1_.c_uom_weight_id, product1_.m_brand_id, product1_.isgeneric, product1_.generic_product_id, product1_.createvariants, product1_.characteristic_desc, product1_.updateinvariants, product1_.managevariants, product1_.prod_cat_selection, product1_.product_selection, product1_.print_description, product1_.returnable, product1_.overdue_return_days, product1_.ispricerulebased, product1_.unique_per_document, product1_.relateprodcattoservice, product1_.relateprodtoservice, product1_.islinkedtoproduct, product1_.quantity_rule, product1_.allow_deferred_sell, product1_.deferred_sell_max_days, product1_.islocked, product1_.issalediscontinued, product1_.em_butimas_date_extraction, product1_.em_butimas_gcn_label, product1_.em_butimas_gcn_typevalue, product1_.em_butimas_gcn_is_product, product1_.em_butintp_idproduit, product1_.em_butintp_islocal, product1_.em_butintp_nosica_storeid, product1_.em_butintp_inassortment, product1_.em_phieco_deee, product1_.em_phieco_dea, product1_.em_phieco_deee_qty, product1_.em_phieco_dea_qty, product1_.em_obrcifp_itemdeclaration, product1_.em_obrdc_delivery_condition, product1_.em_obrdc_delivery_cond_lyw, product1_.em_obgcne_expirationdays, product1_.em_obpgc_printcard, product1_.em_obpgc_printtemplate_id, product1_.em_gcnv_giftcardtype, product1_.em_gcnv_amount, product1_.em_gcnv_allowpartialreturn, product1_.em_obpos_scale, product1_.em_obpos_groupedproduct, product1_.em_obpos_showstock, product1_.em_obpos_show_ch_desc, product1_.em_obpos_proposal_type, product1_.em_obpos_ismultiselectable, product1_.em_obpos_allowanonymoussale, product1_.em_obpos_printservices, product1_.em_obpos_editable_price, product1_.em_obrotf_otf, product1_.em_obrotf_source_product_id, product1_.em_obretss_hassequence, product1_.em_obretss_hasownsequence, product1_.em_phbutpg_giftcardsubtype, product1_.em_butiop_reservations, product1_.ismodifytax, product1_.relateprodcattaxtoservice, product1_.copyservicemodifytaxconfig, product1_.em_butimas_charhash, product1_.em_butimas_charvaluehash, product1_.em_phinum_amountmin, product1_.em_phinum_amountmax, product1_.em_obrdc_isdeliveryservice
  • Index Cond: ((product1_.m_product_id)::text = (obretco_pr0_.m_product_id)::text)
  • Filter: ((product1_.isactive = 'Y'::bpchar) AND ((upper((product1_.value)::text) ~~ '%%MALONE%TA%%%'::text) OR (upper((product1_.upc)::text) ~~ '%%MALONE%TA%%%'::text) OR (upper((product1_.name)::text) ~~ '%%MALONE%TA%%%'::text)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=189653 read=22010
10. 0.020 0.020 ↑ 1.0 1 5

Index Scan using m_product_key on public.m_product product_co8_ (cost=0.56..6.67 rows=1 width=109) (actual time=0.004..0.004 rows=1 loops=5)

  • Output: product_co8_.m_product_id, product_co8_.ad_client_id, product_co8_.ad_org_id, product_co8_.isactive, product_co8_.created, product_co8_.createdby, product_co8_.updated, product_co8_.updatedby, product_co8_.value, product_co8_.name, product_co8_.description, product_co8_.documentnote, product_co8_.help, product_co8_.upc, product_co8_.sku, product_co8_.c_uom_id, product_co8_.salesrep_id, product_co8_.issummary, product_co8_.isstocked, product_co8_.ispurchased, product_co8_.issold, product_co8_.isbom, product_co8_.isinvoiceprintdetails, product_co8_.ispicklistprintdetails, product_co8_.isverified, product_co8_.m_product_category_id, product_co8_.classification, product_co8_.volume, product_co8_.weight, product_co8_.shelfwidth, product_co8_.shelfheight, product_co8_.shelfdepth, product_co8_.unitsperpallet, product_co8_.c_taxcategory_id, product_co8_.s_resource_id, product_co8_.discontinued, product_co8_.discontinuedby, product_co8_.processing, product_co8_.s_expensetype_id, product_co8_.producttype, product_co8_.imageurl, product_co8_.descriptionurl, product_co8_.guaranteedays, product_co8_.versionno, product_co8_.m_attributeset_id, product_co8_.m_attributesetinstance_id, product_co8_.downloadurl, product_co8_.m_freightcategory_id, product_co8_.m_locator_id, product_co8_.ad_image_id, product_co8_.c_bpartner_id, product_co8_.ispriceprinted, product_co8_.name2, product_co8_.costtype, product_co8_.coststd, product_co8_.stock_min, product_co8_.enforce_attribute, product_co8_.calculated, product_co8_.ma_processplan_id, product_co8_.production, product_co8_.capacity, product_co8_.delaymin, product_co8_.mrp_planner_id, product_co8_.mrp_planningmethod_id, product_co8_.qtymax, product_co8_.qtymin, product_co8_.qtystd, product_co8_.qtytype, product_co8_.stockmin, product_co8_.attrsetvaluetype, product_co8_.isquantityvariable, product_co8_.isdeferredrevenue, product_co8_.revplantype, product_co8_.periodnumber, product_co8_.isdeferredexpense, product_co8_.expplantype, product_co8_.periodnumber_exp, product_co8_.defaultperiod, product_co8_.defaultperiod_exp, product_co8_.bookusingpoprice, product_co8_.c_uom_weight_id, product_co8_.m_brand_id, product_co8_.isgeneric, product_co8_.generic_product_id, product_co8_.createvariants, product_co8_.characteristic_desc, product_co8_.updateinvariants, product_co8_.managevariants, product_co8_.prod_cat_selection, product_co8_.product_selection, product_co8_.print_description, product_co8_.returnable, product_co8_.overdue_return_days, product_co8_.ispricerulebased, product_co8_.unique_per_document, product_co8_.relateprodcattoservice, product_co8_.relateprodtoservice, product_co8_.islinkedtoproduct, product_co8_.quantity_rule, product_co8_.allow_deferred_sell, product_co8_.deferred_sell_max_days, product_co8_.islocked, product_co8_.issalediscontinued, product_co8_.em_butimas_date_extraction, product_co8_.em_butimas_gcn_label, product_co8_.em_butimas_gcn_typevalue, product_co8_.em_butimas_gcn_is_product, product_co8_.em_butintp_idproduit, product_co8_.em_butintp_islocal, product_co8_.em_butintp_nosica_storeid, product_co8_.em_butintp_inassortment, product_co8_.em_phieco_deee, product_co8_.em_phieco_dea, product_co8_.em_phieco_deee_qty, product_co8_.em_phieco_dea_qty, product_co8_.em_obrcifp_itemdeclaration, product_co8_.em_obrdc_delivery_condition, product_co8_.em_obrdc_delivery_cond_lyw, product_co8_.em_obgcne_expirationdays, product_co8_.em_obpgc_printcard, product_co8_.em_obpgc_printtemplate_id, product_co8_.em_gcnv_giftcardtype, product_co8_.em_gcnv_amount, product_co8_.em_gcnv_allowpartialreturn, product_co8_.em_obpos_scale, product_co8_.em_obpos_groupedproduct, product_co8_.em_obpos_showstock, product_co8_.em_obpos_show_ch_desc, product_co8_.em_obpos_proposal_type, product_co8_.em_obpos_ismultiselectable, product_co8_.em_obpos_allowanonymoussale, product_co8_.em_obpos_printservices, product_co8_.em_obpos_editable_price, product_co8_.em_obrotf_otf, product_co8_.em_obrotf_source_product_id, product_co8_.em_obretss_hassequence, product_co8_.em_obretss_hasownsequence, product_co8_.em_phbutpg_giftcardsubtype, product_co8_.em_butiop_reservations, product_co8_.ismodifytax, product_co8_.relateprodcattaxtoservice, product_co8_.copyservicemodifytaxconfig, product_co8_.em_butimas_charhash, product_co8_.em_butimas_charvaluehash, product_co8_.em_phinum_amountmin, product_co8_.em_phinum_amountmax, product_co8_.em_obrdc_isdeliveryservice
  • Index Cond: ((product_co8_.m_product_id)::text = (obretco_pr0_.m_product_id)::text)
  • Buffers: shared hit=25
11. 7.155 7.155 ↑ 1.0 1 5

Index Scan using m_productprice_act_plv_pro on public.m_productprice pricingpro4_ (cost=0.56..2.07 rows=1 width=60) (actual time=1.430..1.431 rows=1 loops=5)

  • Output: pricingpro4_.m_productprice_id, pricingpro4_.m_pricelist_version_id, pricingpro4_.m_product_id, pricingpro4_.ad_client_id, pricingpro4_.ad_org_id, pricingpro4_.isactive, pricingpro4_.created, pricingpro4_.createdby, pricingpro4_.updated, pricingpro4_.updatedby, pricingpro4_.pricelist, pricingpro4_.pricestd, pricingpro4_.pricelimit, pricingpro4_.cost, pricingpro4_.algorithm, pricingpro4_.em_obbutf_purchaseprice, pricingpro4_.em_butimas_date_extract_price
  • Index Cond: ((pricingpro4_.isactive = 'Y'::bpchar) AND ((pricingpro4_.m_pricelist_version_id)::text = '3A0A9F505FD34C2593140E326D1BF8E2'::text) AND ((pricingpro4_.m_product_id)::text = (product_co8_.m_product_id)::text))
  • Buffers: shared hit=8 read=18
12. 3.694 17.740 ↑ 1.0 4,084 5

Materialize (cost=0.00..455.26 rows=4,084 width=529) (actual time=0.004..3.548 rows=4,084 loops=5)

  • Output: adimage2_.binarydata, adimage2_.ad_image_id
  • Buffers: shared hit=6 read=388
13. 14.046 14.046 ↑ 1.0 4,084 1

Seq Scan on public.ad_image adimage2_ (cost=0.00..434.84 rows=4,084 width=529) (actual time=0.014..14.046 rows=4,084 loops=1)

  • Output: adimage2_.binarydata, adimage2_.ad_image_id
  • Buffers: shared hit=6 read=388
14. 0.013 0.020 ↑ 1.0 15 5

Materialize (cost=0.00..1.22 rows=15 width=23) (actual time=0.002..0.004 rows=15 loops=5)

  • Output: uom18_.uomsymbol, uom18_.stdprecision, uom18_.c_uom_id
  • Buffers: shared hit=1
15. 0.007 0.007 ↑ 1.0 15 1

Seq Scan on public.c_uom uom18_ (cost=0.00..1.15 rows=15 width=23) (actual time=0.005..0.007 rows=15 loops=1)

  • Output: uom18_.uomsymbol, uom18_.stdprecision, uom18_.c_uom_id
  • Buffers: shared hit=1
16.          

SubPlan (forNested Loop)

17. 0.060 10.330 ↑ 1.0 1 5

HashAggregate (cost=189.71..189.72 rows=1 width=8) (actual time=2.066..2.066 rows=1 loops=5)

  • Output: sum(butismd_mi5_.available_stock), butismd_mi5_.nosica_store
  • Group Key: butismd_mi5_.nosica_store
  • Buffers: shared hit=519 read=14
18. 0.670 10.270 ↑ 1.0 1 5

Hash Join (cost=16.89..189.70 rows=1 width=8) (actual time=1.646..2.054 rows=1 loops=5)

  • Output: butismd_mi5_.nosica_store, butismd_mi5_.available_stock
  • Hash Cond: ((warehouse6_.em_butimwh_noswarehouse_id)::text = (butismd_mi5_.nosica_warehouse)::text)
  • Buffers: shared hit=519 read=14
19. 4.475 4.475 ↑ 1.2 1,303 5

Seq Scan on public.m_warehouse warehouse6_ (cost=0.00..167.18 rows=1,500 width=14) (actual time=0.008..0.895 rows=1,303 loops=5)

  • Output: warehouse6_.m_warehouse_id, warehouse6_.ad_client_id, warehouse6_.ad_org_id, warehouse6_.isactive, warehouse6_.created, warehouse6_.createdby, warehouse6_.updated, warehouse6_.updatedby, warehouse6_.value, warehouse6_.name, warehouse6_.description, warehouse6_.c_location_id, warehouse6_.separator, warehouse6_.isshipper, warehouse6_.shippercode, warehouse6_.fromdocumentno, warehouse6_.todocumentno, warehouse6_.m_returnlocator_id, warehouse6_.m_warehouse_rule_id, warehouse6_.isallocated, warehouse6_.em_obbutf_issalesarea, warehouse6_.em_butimwh_noswarehouse_id, warehouse6_.em_butimwh_type_code, warehouse6_.em_butimwh_type_name, warehouse6_.em_butintp_nosica_storeid, warehouse6_.em_butintp_isdefault, warehouse6_.em_butintp_isbookable, warehouse6_.em_butintp_issellable, warehouse6_.em_butintp_isreturnable, warehouse6_.em_butintp_isactive, warehouse6_.em_butimwh_date_extraction
  • Filter: ((warehouse6_.em_butimwh_type_code = '2'::numeric) OR (warehouse6_.em_butimwh_type_code = '12'::numeric))
  • Rows Removed by Filter: 1107
  • Buffers: shared hit=489
20. 0.020 5.125 ↓ 2.0 2 5

Hash (cost=16.88..16.88 rows=1 width=22) (actual time=1.025..1.025 rows=2 loops=5)

  • Output: butismd_mi5_.nosica_store, butismd_mi5_.available_stock, butismd_mi5_.nosica_warehouse
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=30 read=14
21. 0.030 5.105 ↓ 2.0 2 5

Nested Loop (cost=0.83..16.88 rows=1 width=22) (actual time=0.650..1.021 rows=2 loops=5)

  • Output: butismd_mi5_.nosica_store, butismd_mi5_.available_stock, butismd_mi5_.nosica_warehouse
  • Buffers: shared hit=30 read=14
22. 0.440 0.440 ↑ 1.0 1 5

Index Scan using obretco_pl_key on public.obretco_productlist obretco_pr7_ (cost=0.27..8.29 rows=1 width=4) (actual time=0.088..0.088 rows=1 loops=5)

  • Output: obretco_pr7_.obretco_productlist_id, obretco_pr7_.ad_client_id, obretco_pr7_.ad_org_id, obretco_pr7_.isactive, obretco_pr7_.created, obretco_pr7_.createdby, obretco_pr7_.updated, obretco_pr7_.updatedby, obretco_pr7_.name, obretco_pr7_.description, obretco_pr7_.includeall_product, obretco_pr7_.em_butintp_nosica_storeid
  • Index Cond: ((obretco_pr0_.obretco_productlist_id)::text = (obretco_pr7_.obretco_productlist_id)::text)
  • Buffers: shared hit=13 read=2
23. 4.635 4.635 ↓ 2.0 2 5

Index Scan using butismd_ministock_unique on public.butismd_ministock butismd_mi5_ (cost=0.56..8.57 rows=1 width=22) (actual time=0.557..0.927 rows=2 loops=5)

  • Output: butismd_mi5_.butismd_ministock_id, butismd_mi5_.ad_client_id, butismd_mi5_.ad_org_id, butismd_mi5_.isactive, butismd_mi5_.created, butismd_mi5_.createdby, butismd_mi5_.updated, butismd_mi5_.updatedby, butismd_mi5_.update_time, butismd_mi5_.available_stock, butismd_mi5_.reserved_stock, butismd_mi5_.real_stock, butismd_mi5_.nosica_warehouse, butismd_mi5_.nosica_product, butismd_mi5_.nosica_store, butismd_mi5_.retro_reserved_stock, butismd_mi5_.not_available_stock, butismd_mi5_.isexpo
  • Index Cond: (((butismd_mi5_.nosica_store)::text = (obretco_pr7_.em_butintp_nosica_storeid)::text) AND ((butismd_mi5_.nosica_product)::text = (product1_.em_butintp_idproduit)::text))
  • Buffers: shared hit=17 read=12
24. 1.075 1.075 ↑ 1.0 1 5

Index Scan using phieco_taxcategory_key on public.phieco_taxcategory eco (cost=0.41..8.43 rows=1 width=6) (actual time=0.214..0.215 rows=1 loops=5)

  • Output: eco.taxamt
  • Index Cond: ((eco.phieco_taxcategory_id)::text = (product_co8_.em_phieco_dea)::text)
  • Buffers: shared hit=17 read=3
25. 0.325 0.325 ↑ 1.0 1 5

Index Scan using phieco_taxcategory_key on public.phieco_taxcategory eco_1 (cost=0.41..8.43 rows=1 width=6) (actual time=0.064..0.065 rows=1 loops=5)

  • Output: eco_1.taxamt
  • Index Cond: ((eco_1.phieco_taxcategory_id)::text = (product_co8_.em_phieco_deee)::text)
  • Buffers: shared hit=19 read=1
26. 0.050 0.050 ↓ 0.0 0 5

Seq Scan on public.obpos_print_template obpos_prin10_ (cost=0.00..2.50 rows=1 width=42) (actual time=0.010..0.010 rows=0 loops=5)

  • Output: obpos_prin10_.template_path
  • Filter: ((product1_.em_obpgc_printtemplate_id)::text = (obpos_prin10_.obpos_print_template_id)::text)
  • Rows Removed by Filter: 40
  • Buffers: shared hit=10
27. 0.020 0.020 ↓ 0.0 0 5

Seq Scan on public.obpos_print_template obpos_prin11_ (cost=0.00..2.50 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=5)

  • Output: obpos_prin11_.print_type
  • Filter: ((product1_.em_obpgc_printtemplate_id)::text = (obpos_prin11_.obpos_print_template_id)::text)
  • Rows Removed by Filter: 40
  • Buffers: shared hit=10
28. 0.020 0.020 ↓ 0.0 0 5

Seq Scan on public.obpos_print_template obpos_prin12_ (cost=0.00..2.50 rows=1 width=5) (actual time=0.004..0.004 rows=0 loops=5)

  • Output: obpos_prin12_.printer
  • Filter: ((product1_.em_obpgc_printtemplate_id)::text = (obpos_prin12_.obpos_print_template_id)::text)
  • Rows Removed by Filter: 40
  • Buffers: shared hit=10
29. 0.015 0.015 ↑ 1.0 1 5

Index Scan using phieco_taxcategory_key on public.phieco_taxcategory phieco_tax13_ (cost=0.41..8.43 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=5)

  • Output: phieco_tax13_.taxamt
  • Index Cond: ((product1_.em_phieco_dea)::text = (phieco_tax13_.phieco_taxcategory_id)::text)
  • Buffers: shared hit=20
30. 0.015 0.015 ↑ 1.0 1 5

Index Scan using phieco_taxcategory_key on public.phieco_taxcategory phieco_tax14_ (cost=0.41..8.43 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=5)

  • Output: phieco_tax14_.taxamt
  • Index Cond: ((product1_.em_phieco_deee)::text = (phieco_tax14_.phieco_taxcategory_id)::text)
  • Buffers: shared hit=20
31. 0.015 8.910 ↓ 0.0 0 5

Nested Loop (cost=1.26..25.34 rows=1 width=13) (actual time=1.781..1.782 rows=0 loops=5)

  • Output: characteri16_.name
  • Buffers: shared hit=19 read=26
32. 0.015 7.045 ↓ 0.0 0 5

Nested Loop (cost=0.83..16.88 rows=1 width=33) (actual time=1.408..1.409 rows=0 loops=5)

  • Output: productcha15_.m_ch_value_id
  • Buffers: shared hit=17 read=20
33. 0.435 0.435 ↑ 1.0 1 5

Index Scan using em_butintp_ch_name_client on public.m_characteristic characteri17_ (cost=0.28..8.29 rows=1 width=33) (actual time=0.086..0.087 rows=1 loops=5)

  • Output: characteri17_.m_characteristic_id, characteri17_.ad_client_id, characteri17_.ad_org_id, characteri17_.isactive, characteri17_.created, characteri17_.createdby, characteri17_.updated, characteri17_.updatedby, characteri17_.name, characteri17_.description, characteri17_.ad_tree_id, characteri17_.isvariant, characteri17_.isexplodeconf, characteri17_.em_obpos_filteronwebpos, characteri17_.em_obpos_useonwebpos
  • Index Cond: ((characteri17_.name)::text = 'Produit.DispoPce'::text)
  • Buffers: shared hit=13 read=2
34. 6.595 6.595 ↓ 0.0 0 5

Index Scan using em_repdf_product_ch_rep on public.m_product_ch_value productcha15_ (cost=0.56..8.58 rows=1 width=66) (actual time=1.319..1.319 rows=0 loops=5)

  • Output: productcha15_.m_product_ch_value_id, productcha15_.ad_client_id, productcha15_.ad_org_id, productcha15_.isactive, productcha15_.created, productcha15_.createdby, productcha15_.updated, productcha15_.updatedby, productcha15_.m_product_id, productcha15_.m_characteristic_id, productcha15_.m_ch_value_id
  • Index Cond: (((productcha15_.m_product_id)::text = (product1_.m_product_id)::text) AND ((productcha15_.m_characteristic_id)::text = (characteri17_.m_characteristic_id)::text))
  • Buffers: shared hit=4 read=18
35. 1.850 1.850 ↑ 1.0 1 2

Index Scan using m_ch_value_key on public.m_ch_value characteri16_ (cost=0.42..8.44 rows=1 width=46) (actual time=0.925..0.925 rows=1 loops=2)

  • Output: characteri16_.m_ch_value_id, characteri16_.ad_client_id, characteri16_.ad_org_id, characteri16_.isactive, characteri16_.created, characteri16_.createdby, characteri16_.updated, characteri16_.updatedby, characteri16_.m_characteristic_id, characteri16_.name, characteri16_.issummary, characteri16_.skcode, characteri16_.description, characteri16_.add_products
  • Index Cond: ((characteri16_.m_ch_value_id)::text = (productcha15_.m_ch_value_id)::text)
  • Buffers: shared hit=2 read=6