[ { "Plan": { "Node Type": "Limit", "Parallel Aware": false, "Startup Cost": 147865.67, "Total Cost": 2176559.11, "Plan Rows": 34939, "Plan Width": 3417, "Actual Startup Time": 208625.558, "Actual Total Time": 208625.558, "Actual Rows": 0, "Actual Loops": 1, "Output": ["product3_.em_obretur_notusereturnreason", "(COALESCE((SubPlan 2), product3_.c_taxcategory_id))", "product3_.em_obrdm_delivery_mode", "product3_.em_obrdm_delivery_mode_lyw", "product3_.em_obrdm_isdeliveryservice", "product3_.m_product_id", "product3_.ad_org_id", "product3_.value", "(COALESCE((SubPlan 3), product3_.name))", "product3_.m_product_category_id", "product3_.em_obpos_scale", "product3_.c_uom_id", "uom9_.uomsymbol", "(COALESCE(uom9_.stdprecision))", "(upper((product3_.upc)::text))", "product3_.description", "product3_.em_obpos_groupedproduct", "product3_.isstocked", "product3_.em_obpos_showstock", "product3_.isgeneric", "product3_.m_product_status_id", "product3_.generic_product_id", "product3_.characteristic_desc", "(((product3_.characteristic_desc)::text || ','::text))", "product3_.em_obpos_show_ch_desc", "product3_.producttype", "product3_.prod_cat_selection", "product3_.product_selection", "product3_.print_description", "product3_.em_obpos_allowanonymoussale", "product3_.returnable", "product3_.overdue_return_days", "product3_.ispricerulebased", "product3_.em_obpos_proposal_type", "product3_.em_obpos_ismultiselectable", "product3_.islinkedtoproduct", "product3_.ismodifytax", "product3_.allow_deferred_sell", "product3_.deferred_sell_max_days", "product3_.quantity_rule", "product3_.em_obpos_printservices", "product3_.weight", "false", "product3_.em_obpos_maxpriceassocprod", "product3_.em_obpos_minpriceassocprod", "adimage2_.binarydata", "adimage2_.ad_image_id", "adimage2_.mimetype", "obretco_pr0_.bestseller", "obretco_pr0_.m_product_status_id", "pricingpro5_.pricelist", "pricingpro5_.pricestd", "pricingpro5_.pricelimit", "pricingpro5_.cost", "pricingpro5_.algorithm", "(CASE WHEN ((product3_.isactive = 'Y'::bpchar) AND (obretco_pr0_.isactive IS NOT NULL)) THEN obretco_pr0_.isactive ELSE product3_.isactive END)", "product3_.em_obpos_editable_price", "'false'::text", "(CASE WHEN (product3_.m_attributeset_id IS NOT NULL) THEN true ELSE false END)", "(CASE WHEN (attributes4_.isserno = 'Y'::bpchar) THEN true ELSE false END)", "((COALESCE((SubPlan 4), '0'::numeric) * product_co11_.em_phieco_dea_qty))", "((COALESCE((SubPlan 5), '0'::numeric) * product_co11_.em_phieco_deee_qty))", "product3_.em_phieco_dea", "product3_.em_phieco_deee", "product3_.em_obmupc_multiupc_desc", "((SubPlan 6))", "product3_.em_obpgc_printcard", "((SubPlan 7))", "((SubPlan 8))", "product3_.em_obgcne_expirationdays", "product3_.em_gcnv_giftcardtype", "product3_.em_gcnv_amount"], "Shared Hit Blocks": 1531536, "Shared Read Blocks": 274223, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 2849, "Temp Written Blocks": 2860, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 147865.67, "Total Cost": 2176559.11, "Plan Rows": 34939, "Plan Width": 3417, "Actual Startup Time": 208625.556, "Actual Total Time": 208625.556, "Actual Rows": 0, "Actual Loops": 1, "Output": ["product3_.em_obretur_notusereturnreason", "COALESCE((SubPlan 2), product3_.c_taxcategory_id)", "product3_.em_obrdm_delivery_mode", "product3_.em_obrdm_delivery_mode_lyw", "product3_.em_obrdm_isdeliveryservice", "product3_.m_product_id", "product3_.ad_org_id", "product3_.value", "COALESCE((SubPlan 3), product3_.name)", "product3_.m_product_category_id", "product3_.em_obpos_scale", "product3_.c_uom_id", "uom9_.uomsymbol", "COALESCE(uom9_.stdprecision)", "upper((product3_.upc)::text)", "product3_.description", "product3_.em_obpos_groupedproduct", "product3_.isstocked", "product3_.em_obpos_showstock", "product3_.isgeneric", "product3_.m_product_status_id", "product3_.generic_product_id", "product3_.characteristic_desc", "((product3_.characteristic_desc)::text || ','::text)", "product3_.em_obpos_show_ch_desc", "product3_.producttype", "product3_.prod_cat_selection", "product3_.product_selection", "product3_.print_description", "product3_.em_obpos_allowanonymoussale", "product3_.returnable", "product3_.overdue_return_days", "product3_.ispricerulebased", "product3_.em_obpos_proposal_type", "product3_.em_obpos_ismultiselectable", "product3_.islinkedtoproduct", "product3_.ismodifytax", "product3_.allow_deferred_sell", "product3_.deferred_sell_max_days", "product3_.quantity_rule", "product3_.em_obpos_printservices", "product3_.weight", "false", "product3_.em_obpos_maxpriceassocprod", "product3_.em_obpos_minpriceassocprod", "adimage2_.binarydata", "adimage2_.ad_image_id", "adimage2_.mimetype", "obretco_pr0_.bestseller", "obretco_pr0_.m_product_status_id", "pricingpro5_.pricelist", "pricingpro5_.pricestd", "pricingpro5_.pricelimit", "pricingpro5_.cost", "pricingpro5_.algorithm", "CASE WHEN ((product3_.isactive = 'Y'::bpchar) AND (obretco_pr0_.isactive IS NOT NULL)) THEN obretco_pr0_.isactive ELSE product3_.isactive END", "product3_.em_obpos_editable_price", "'false'::text", "CASE WHEN (product3_.m_attributeset_id IS NOT NULL) THEN true ELSE false END", "CASE WHEN (attributes4_.isserno = 'Y'::bpchar) THEN true ELSE false END", "(COALESCE((SubPlan 4), '0'::numeric) * product_co11_.em_phieco_dea_qty)", "(COALESCE((SubPlan 5), '0'::numeric) * product_co11_.em_phieco_deee_qty)", "product3_.em_phieco_dea", "product3_.em_phieco_deee", "product3_.em_obmupc_multiupc_desc", "(SubPlan 6)", "product3_.em_obpgc_printcard", "(SubPlan 7)", "(SubPlan 8)", "product3_.em_obgcne_expirationdays", "product3_.em_gcnv_giftcardtype", "product3_.em_gcnv_amount"], "Inner Unique": true, "Join Filter": "((obretco_pr0_.m_product_id)::text = (product_co11_.m_product_id)::text)", "Rows Removed by Join Filter": 0, "Shared Hit Blocks": 1531536, "Shared Read Blocks": 274223, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 2849, "Temp Written Blocks": 2860, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Left", "Startup Cost": 147865.25, "Total Cost": 796539.50, "Plan Rows": 34939, "Plan Width": 2817, "Actual Startup Time": 208625.555, "Actual Total Time": 208625.555, "Actual Rows": 0, "Actual Loops": 1, "Output": ["obretco_pr0_.bestseller", "obretco_pr0_.m_product_status_id", "obretco_pr0_.isactive", "obretco_pr0_.m_product_id", "adimage2_.binarydata", "adimage2_.ad_image_id", "adimage2_.mimetype", "product3_.em_obretur_notusereturnreason", "product3_.ad_client_id", "product3_.m_product_id", "product3_.c_taxcategory_id", "product3_.em_obrdm_delivery_mode", "product3_.em_obrdm_delivery_mode_lyw", "product3_.em_obrdm_isdeliveryservice", "product3_.ad_org_id", "product3_.value", "product3_.name", "product3_.m_product_category_id", "product3_.em_obpos_scale", "product3_.c_uom_id", "product3_.upc", "product3_.description", "product3_.em_obpos_groupedproduct", "product3_.isstocked", "product3_.em_obpos_showstock", "product3_.isgeneric", "product3_.m_product_status_id", "product3_.generic_product_id", "product3_.characteristic_desc", "product3_.em_obpos_show_ch_desc", "product3_.producttype", "product3_.prod_cat_selection", "product3_.product_selection", "product3_.print_description", "product3_.em_obpos_allowanonymoussale", "product3_.returnable", "product3_.overdue_return_days", "product3_.ispricerulebased", "product3_.em_obpos_proposal_type", "product3_.em_obpos_ismultiselectable", "product3_.islinkedtoproduct", "product3_.ismodifytax", "product3_.allow_deferred_sell", "product3_.deferred_sell_max_days", "product3_.quantity_rule", "product3_.em_obpos_printservices", "product3_.weight", "product3_.em_obpos_maxpriceassocprod", "product3_.em_obpos_minpriceassocprod", "product3_.isactive", "product3_.em_obpos_editable_price", "product3_.m_attributeset_id", "product3_.em_phieco_dea", "product3_.em_phieco_deee", "product3_.em_obmupc_multiupc_desc", "product3_.em_obpgc_printtemplate_id", "product3_.em_obpgc_printcard", "product3_.em_obgcne_expirationdays", "product3_.em_gcnv_giftcardtype", "product3_.em_gcnv_amount", "attributes4_.isserno", "pricingpro5_.pricelist", "pricingpro5_.pricestd", "pricingpro5_.pricelimit", "pricingpro5_.cost", "pricingpro5_.algorithm", "pricingpro5_.m_product_id", "uom9_.uomsymbol", "uom9_.stdprecision"], "Inner Unique": true, "Join Filter": "((product3_.m_attributeset_id)::text = (attributes4_.m_attributeset_id)::text)", "Rows Removed by Join Filter": 0, "Shared Hit Blocks": 1531536, "Shared Read Blocks": 274223, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 2849, "Temp Written Blocks": 2860, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Left", "Startup Cost": 147865.25, "Total Cost": 796014.41, "Plan Rows": 34939, "Plan Width": 2809, "Actual Startup Time": 208625.555, "Actual Total Time": 208625.555, "Actual Rows": 0, "Actual Loops": 1, "Output": ["obretco_pr0_.bestseller", "obretco_pr0_.m_product_status_id", "obretco_pr0_.isactive", "obretco_pr0_.m_product_id", "adimage2_.binarydata", "adimage2_.ad_image_id", "adimage2_.mimetype", "product3_.em_obretur_notusereturnreason", "product3_.ad_client_id", "product3_.m_product_id", "product3_.c_taxcategory_id", "product3_.em_obrdm_delivery_mode", "product3_.em_obrdm_delivery_mode_lyw", "product3_.em_obrdm_isdeliveryservice", "product3_.ad_org_id", "product3_.value", "product3_.name", "product3_.m_product_category_id", "product3_.em_obpos_scale", "product3_.c_uom_id", "product3_.upc", "product3_.description", "product3_.em_obpos_groupedproduct", "product3_.isstocked", "product3_.em_obpos_showstock", "product3_.isgeneric", "product3_.m_product_status_id", "product3_.generic_product_id", "product3_.characteristic_desc", "product3_.em_obpos_show_ch_desc", "product3_.producttype", "product3_.prod_cat_selection", "product3_.product_selection", "product3_.print_description", "product3_.em_obpos_allowanonymoussale", "product3_.returnable", "product3_.overdue_return_days", "product3_.ispricerulebased", "product3_.em_obpos_proposal_type", "product3_.em_obpos_ismultiselectable", "product3_.islinkedtoproduct", "product3_.ismodifytax", "product3_.allow_deferred_sell", "product3_.deferred_sell_max_days", "product3_.quantity_rule", "product3_.em_obpos_printservices", "product3_.weight", "product3_.em_obpos_maxpriceassocprod", "product3_.em_obpos_minpriceassocprod", "product3_.isactive", "product3_.em_obpos_editable_price", "product3_.m_attributeset_id", "product3_.em_phieco_dea", "product3_.em_phieco_deee", "product3_.em_obmupc_multiupc_desc", "product3_.em_obpgc_printtemplate_id", "product3_.em_obpgc_printcard", "product3_.em_obgcne_expirationdays", "product3_.em_gcnv_giftcardtype", "product3_.em_gcnv_amount", "pricingpro5_.pricelist", "pricingpro5_.pricestd", "pricingpro5_.pricelimit", "pricingpro5_.cost", "pricingpro5_.algorithm", "pricingpro5_.m_product_id", "uom9_.uomsymbol", "uom9_.stdprecision"], "Inner Unique": true, "Shared Hit Blocks": 1531536, "Shared Read Blocks": 274223, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 2849, "Temp Written Blocks": 2860, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Left", "Startup Cost": 147865.11, "Total Cost": 780815.44, "Plan Rows": 34939, "Plan Width": 2703, "Actual Startup Time": 208625.554, "Actual Total Time": 208625.554, "Actual Rows": 0, "Actual Loops": 1, "Output": ["obretco_pr0_.bestseller", "obretco_pr0_.m_product_status_id", "obretco_pr0_.isactive", "obretco_pr0_.m_product_id", "product1_.ad_image_id", "product3_.em_obretur_notusereturnreason", "product3_.ad_client_id", "product3_.m_product_id", "product3_.c_taxcategory_id", "product3_.em_obrdm_delivery_mode", "product3_.em_obrdm_delivery_mode_lyw", "product3_.em_obrdm_isdeliveryservice", "product3_.ad_org_id", "product3_.value", "product3_.name", "product3_.m_product_category_id", "product3_.em_obpos_scale", "product3_.c_uom_id", "product3_.upc", "product3_.description", "product3_.em_obpos_groupedproduct", "product3_.isstocked", "product3_.em_obpos_showstock", "product3_.isgeneric", "product3_.m_product_status_id", "product3_.generic_product_id", "product3_.characteristic_desc", "product3_.em_obpos_show_ch_desc", "product3_.producttype", "product3_.prod_cat_selection", "product3_.product_selection", "product3_.print_description", "product3_.em_obpos_allowanonymoussale", "product3_.returnable", "product3_.overdue_return_days", "product3_.ispricerulebased", "product3_.em_obpos_proposal_type", "product3_.em_obpos_ismultiselectable", "product3_.islinkedtoproduct", "product3_.ismodifytax", "product3_.allow_deferred_sell", "product3_.deferred_sell_max_days", "product3_.quantity_rule", "product3_.em_obpos_printservices", "product3_.weight", "product3_.em_obpos_maxpriceassocprod", "product3_.em_obpos_minpriceassocprod", "product3_.isactive", "product3_.em_obpos_editable_price", "product3_.m_attributeset_id", "product3_.em_phieco_dea", "product3_.em_phieco_deee", "product3_.em_obmupc_multiupc_desc", "product3_.em_obpgc_printtemplate_id", "product3_.em_obpgc_printcard", "product3_.em_obgcne_expirationdays", "product3_.em_gcnv_giftcardtype", "product3_.em_gcnv_amount", "pricingpro5_.pricelist", "pricingpro5_.pricestd", "pricingpro5_.pricelimit", "pricingpro5_.cost", "pricingpro5_.algorithm", "pricingpro5_.m_product_id", "uom9_.uomsymbol", "uom9_.stdprecision"], "Inner Unique": true, "Shared Hit Blocks": 1531536, "Shared Read Blocks": 274223, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 2849, "Temp Written Blocks": 2860, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 147864.68, "Total Cost": 724323.57, "Plan Rows": 34939, "Plan Width": 2621, "Actual Startup Time": 208625.554, "Actual Total Time": 208625.554, "Actual Rows": 0, "Actual Loops": 1, "Output": ["obretco_pr0_.bestseller", "obretco_pr0_.m_product_status_id", "obretco_pr0_.isactive", "obretco_pr0_.m_product_id", "product3_.em_obretur_notusereturnreason", "product3_.ad_client_id", "product3_.m_product_id", "product3_.c_taxcategory_id", "product3_.em_obrdm_delivery_mode", "product3_.em_obrdm_delivery_mode_lyw", "product3_.em_obrdm_isdeliveryservice", "product3_.ad_org_id", "product3_.value", "product3_.name", "product3_.m_product_category_id", "product3_.em_obpos_scale", "product3_.c_uom_id", "product3_.upc", "product3_.description", "product3_.em_obpos_groupedproduct", "product3_.isstocked", "product3_.em_obpos_showstock", "product3_.isgeneric", "product3_.m_product_status_id", "product3_.generic_product_id", "product3_.characteristic_desc", "product3_.em_obpos_show_ch_desc", "product3_.producttype", "product3_.prod_cat_selection", "product3_.product_selection", "product3_.print_description", "product3_.em_obpos_allowanonymoussale", "product3_.returnable", "product3_.overdue_return_days", "product3_.ispricerulebased", "product3_.em_obpos_proposal_type", "product3_.em_obpos_ismultiselectable", "product3_.islinkedtoproduct", "product3_.ismodifytax", "product3_.allow_deferred_sell", "product3_.deferred_sell_max_days", "product3_.quantity_rule", "product3_.em_obpos_printservices", "product3_.weight", "product3_.em_obpos_maxpriceassocprod", "product3_.em_obpos_minpriceassocprod", "product3_.isactive", "product3_.em_obpos_editable_price", "product3_.m_attributeset_id", "product3_.em_phieco_dea", "product3_.em_phieco_deee", "product3_.em_obmupc_multiupc_desc", "product3_.em_obpgc_printtemplate_id", "product3_.em_obpgc_printcard", "product3_.em_obgcne_expirationdays", "product3_.em_gcnv_giftcardtype", "product3_.em_gcnv_amount", "pricingpro5_.pricelist", "pricingpro5_.pricestd", "pricingpro5_.pricelimit", "pricingpro5_.cost", "pricingpro5_.algorithm", "pricingpro5_.m_product_id", "uom9_.uomsymbol", "uom9_.stdprecision"], "Inner Unique": true, "Join Filter": "((product3_.updated > '2020-08-26 11:07:23.994'::timestamp without time zone) OR (obretco_pr0_.updated > '2020-08-26 11:07:23.994'::timestamp without time zone) OR (pricingpro5_.updated > '2020-08-26 11:07:23.994'::timestamp without time zone) OR (uom9_.updated > '2020-08-26 11:07:23.994'::timestamp without time zone))", "Rows Removed by Join Filter": 248333, "Shared Hit Blocks": 1531536, "Shared Read Blocks": 274223, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 2849, "Temp Written Blocks": 2860, "Plans": [ { "Node Type": "Merge Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 147864.54, "Total Cost": 706030.63, "Plan Rows": 104755, "Plan Width": 2613, "Actual Startup Time": 67881.204, "Actual Total Time": 207832.130, "Actual Rows": 248333, "Actual Loops": 1, "Output": ["obretco_pr0_.bestseller", "obretco_pr0_.m_product_status_id", "obretco_pr0_.isactive", "obretco_pr0_.m_product_id", "obretco_pr0_.updated", "product3_.em_obretur_notusereturnreason", "product3_.ad_client_id", "product3_.m_product_id", "product3_.c_taxcategory_id", "product3_.em_obrdm_delivery_mode", "product3_.em_obrdm_delivery_mode_lyw", "product3_.em_obrdm_isdeliveryservice", "product3_.ad_org_id", "product3_.value", "product3_.name", "product3_.m_product_category_id", "product3_.em_obpos_scale", "product3_.c_uom_id", "product3_.upc", "product3_.description", "product3_.em_obpos_groupedproduct", "product3_.isstocked", "product3_.em_obpos_showstock", "product3_.isgeneric", "product3_.m_product_status_id", "product3_.generic_product_id", "product3_.characteristic_desc", "product3_.em_obpos_show_ch_desc", "product3_.producttype", "product3_.prod_cat_selection", "product3_.product_selection", "product3_.print_description", "product3_.em_obpos_allowanonymoussale", "product3_.returnable", "product3_.overdue_return_days", "product3_.ispricerulebased", "product3_.em_obpos_proposal_type", "product3_.em_obpos_ismultiselectable", "product3_.islinkedtoproduct", "product3_.ismodifytax", "product3_.allow_deferred_sell", "product3_.deferred_sell_max_days", "product3_.quantity_rule", "product3_.em_obpos_printservices", "product3_.weight", "product3_.em_obpos_maxpriceassocprod", "product3_.em_obpos_minpriceassocprod", "product3_.isactive", "product3_.em_obpos_editable_price", "product3_.m_attributeset_id", "product3_.em_phieco_dea", "product3_.em_phieco_deee", "product3_.em_obmupc_multiupc_desc", "product3_.em_obpgc_printtemplate_id", "product3_.em_obpgc_printcard", "product3_.em_obgcne_expirationdays", "product3_.em_gcnv_giftcardtype", "product3_.em_gcnv_amount", "product3_.updated", "pricingpro5_.pricelist", "pricingpro5_.pricestd", "pricingpro5_.pricelimit", "pricingpro5_.cost", "pricingpro5_.algorithm", "pricingpro5_.m_product_id", "pricingpro5_.updated"], "Inner Unique": true, "Merge Cond": "((obretco_pr0_.m_product_id)::text = (pricingpro5_.m_product_id)::text)", "Shared Hit Blocks": 1034872, "Shared Read Blocks": 274221, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 2849, "Temp Written Blocks": 2860, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 0.98, "Total Cost": 552910.18, "Plan Rows": 246530, "Plan Width": 2552, "Actual Startup Time": 0.075, "Actual Total Time": 139009.774, "Actual Rows": 249599, "Actual Loops": 1, "Output": ["obretco_pr0_.bestseller", "obretco_pr0_.m_product_status_id", "obretco_pr0_.isactive", "obretco_pr0_.m_product_id", "obretco_pr0_.updated", "product3_.em_obretur_notusereturnreason", "product3_.ad_client_id", "product3_.m_product_id", "product3_.c_taxcategory_id", "product3_.em_obrdm_delivery_mode", "product3_.em_obrdm_delivery_mode_lyw", "product3_.em_obrdm_isdeliveryservice", "product3_.ad_org_id", "product3_.value", "product3_.name", "product3_.m_product_category_id", "product3_.em_obpos_scale", "product3_.c_uom_id", "product3_.upc", "product3_.description", "product3_.em_obpos_groupedproduct", "product3_.isstocked", "product3_.em_obpos_showstock", "product3_.isgeneric", "product3_.m_product_status_id", "product3_.generic_product_id", "product3_.characteristic_desc", "product3_.em_obpos_show_ch_desc", "product3_.producttype", "product3_.prod_cat_selection", "product3_.product_selection", "product3_.print_description", "product3_.em_obpos_allowanonymoussale", "product3_.returnable", "product3_.overdue_return_days", "product3_.ispricerulebased", "product3_.em_obpos_proposal_type", "product3_.em_obpos_ismultiselectable", "product3_.islinkedtoproduct", "product3_.ismodifytax", "product3_.allow_deferred_sell", "product3_.deferred_sell_max_days", "product3_.quantity_rule", "product3_.em_obpos_printservices", "product3_.weight", "product3_.em_obpos_maxpriceassocprod", "product3_.em_obpos_minpriceassocprod", "product3_.isactive", "product3_.em_obpos_editable_price", "product3_.m_attributeset_id", "product3_.em_phieco_dea", "product3_.em_phieco_deee", "product3_.em_obmupc_multiupc_desc", "product3_.em_obpgc_printtemplate_id", "product3_.em_obpgc_printcard", "product3_.em_obgcne_expirationdays", "product3_.em_gcnv_giftcardtype", "product3_.em_gcnv_amount", "product3_.updated"], "Inner Unique": true, "Shared Hit Blocks": 1034872, "Shared Read Blocks": 216896, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "obretco_prol_product_un", "Relation Name": "obretco_prol_product", "Schema": "public", "Alias": "obretco_pr0_", "Startup Cost": 0.55, "Total Cost": 154302.85, "Plan Rows": 246530, "Plan Width": 78, "Actual Startup Time": 0.056, "Actual Total Time": 43811.070, "Actual Rows": 249599, "Actual 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_.m_product_status_id"], "Index Cond": "((obretco_pr0_.obretco_productlist_id)::text = 'C06EAFD88D824598988B59E197F7B5C3'::text)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 151468, "Shared Read Blocks": 101899, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "m_product_key", "Relation Name": "m_product", "Schema": "public", "Alias": "product3_", "Startup Cost": 0.42, "Total Cost": 1.62, "Plan Rows": 1, "Plan Width": 2474, "Actual Startup Time": 0.379, "Actual Total Time": 0.379, "Actual Rows": 1, "Actual Loops": 249599, "Output": ["product3_.m_product_id", "product3_.ad_client_id", "product3_.ad_org_id", "product3_.isactive", "product3_.created", "product3_.createdby", "product3_.updated", "product3_.updatedby", "product3_.value", "product3_.name", "product3_.description", "product3_.documentnote", "product3_.help", "product3_.upc", "product3_.sku", "product3_.c_uom_id", "product3_.salesrep_id", "product3_.issummary", "product3_.isstocked", "product3_.ispurchased", "product3_.issold", "product3_.isbom", "product3_.isinvoiceprintdetails", "product3_.ispicklistprintdetails", "product3_.isverified", "product3_.m_product_category_id", "product3_.classification", "product3_.volume", "product3_.weight", "product3_.shelfwidth", "product3_.shelfheight", "product3_.shelfdepth", "product3_.unitsperpallet", "product3_.c_taxcategory_id", "product3_.s_resource_id", "product3_.discontinued", "product3_.discontinuedby", "product3_.processing", "product3_.s_expensetype_id", "product3_.producttype", "product3_.imageurl", "product3_.descriptionurl", "product3_.guaranteedays", "product3_.versionno", "product3_.m_attributeset_id", "product3_.m_attributesetinstance_id", "product3_.downloadurl", "product3_.m_freightcategory_id", "product3_.m_locator_id", "product3_.ad_image_id", "product3_.c_bpartner_id", "product3_.ispriceprinted", "product3_.name2", "product3_.stock_min", "product3_.enforce_attribute", "product3_.calculated", "product3_.ma_processplan_id", "product3_.production", "product3_.capacity", "product3_.delaymin", "product3_.mrp_planner_id", "product3_.mrp_planningmethod_id", "product3_.qtymax", "product3_.qtymin", "product3_.qtystd", "product3_.qtytype", "product3_.stockmin", "product3_.attrsetvaluetype", "product3_.isquantityvariable", "product3_.isdeferredrevenue", "product3_.revplantype", "product3_.periodnumber", "product3_.isdeferredexpense", "product3_.expplantype", "product3_.periodnumber_exp", "product3_.defaultperiod", "product3_.defaultperiod_exp", "product3_.bookusingpoprice", "product3_.c_uom_weight_id", "product3_.m_brand_id", "product3_.isgeneric", "product3_.generic_product_id", "product3_.createvariants", "product3_.characteristic_desc", "product3_.updateinvariants", "product3_.managevariants", "product3_.prod_cat_selection", "product3_.product_selection", "product3_.print_description", "product3_.returnable", "product3_.overdue_return_days", "product3_.ispricerulebased", "product3_.unique_per_document", "product3_.relateprodcattoservice", "product3_.relateprodtoservice", "product3_.islinkedtoproduct", "product3_.quantity_rule", "product3_.allow_deferred_sell", "product3_.deferred_sell_max_days", "product3_.m_product_status_id", "product3_.ismodifytax", "product3_.relateprodcattaxtoservice", "product3_.copyservicemodifytaxconfig", "product3_.em_aeat347_isleasebusiness", "product3_.em_aeat347_situation", "product3_.em_aeat347_referenceid", "product3_.em_aeat347_locationtype", "product3_.em_aeat347_streetname", "product3_.em_aeat347_streetnumbertype", "product3_.em_aeat347_streetnumber", "product3_.em_aeat347_streetnumberqua", "product3_.em_aeat347_building", "product3_.em_aeat347_hall", "product3_.em_aeat347_hallway", "product3_.em_aeat347_floor", "product3_.em_aeat347_apartment", "product3_.em_aeat347_complement", "product3_.em_aeat347_location", "product3_.em_aeat347_county", "product3_.em_aeat347_countycode", "product3_.em_aeat347_regioncode", "product3_.em_aeat347_zipcode", "product3_.em_obpos_scale", "product3_.em_obpos_groupedproduct", "product3_.em_obpos_showstock", "product3_.em_obpos_show_ch_desc", "product3_.em_obpos_proposal_type", "product3_.em_obpos_ismultiselectable", "product3_.em_obpos_allowanonymoussale", "product3_.em_obpos_printservices", "product3_.em_obpos_editable_price", "product3_.em_obrdm_delivery_mode", "product3_.em_obrdm_delivery_mode_lyw", "product3_.em_obrdm_isdeliveryservice", "product3_.em_gcnv_giftcardtype", "product3_.em_gcnv_amount", "product3_.em_gcnv_allowpartialreturn", "product3_.em_obgcne_expirationdays", "product3_.em_obpgc_printcard", "product3_.em_obpgc_printtemplate_id", "product3_.em_obpbomv_issubstitute", "product3_.em_obpbomv_substituteprocess", "product3_.em_phieco_deee", "product3_.em_phieco_dea", "product3_.em_phieco_deee_qty", "product3_.em_phieco_dea_qty", "product3_.em_obmupc_multiupc_desc", "product3_.em_obpos_maxpriceassocprod", "product3_.em_obpos_minpriceassocprod", "product3_.em_obretur_notusereturnreason"], "Index Cond": "((product3_.m_product_id)::text = (obretco_pr0_.m_product_id)::text)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 883404, "Shared Read Blocks": 114997, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] }, { "Node Type": "Sort", "Parent Relationship": "Inner", "Parallel Aware": false, "Startup Cost": 147863.40, "Total Cost": 148704.68, "Plan Rows": 336513, "Plan Width": 61, "Actual Startup Time": 67881.121, "Actual Total Time": 68430.557, "Actual Rows": 313645, "Actual Loops": 1, "Output": ["pricingpro5_.pricelist", "pricingpro5_.pricestd", "pricingpro5_.pricelimit", "pricingpro5_.cost", "pricingpro5_.algorithm", "pricingpro5_.m_product_id", "pricingpro5_.updated"], "Sort Key": ["pricingpro5_.m_product_id"], "Sort Method": "external merge", "Sort Space Used": 22792, "Sort Space Type": "Disk", "Shared Hit Blocks": 0, "Shared Read Blocks": 57325, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 2849, "Temp Written Blocks": 2860, "Plans": [ { "Node Type": "Bitmap Heap Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Relation Name": "m_productprice", "Schema": "public", "Alias": "pricingpro5_", "Startup Cost": 8188.83, "Total Cost": 109560.24, "Plan Rows": 336513, "Plan Width": 61, "Actual Startup Time": 81.174, "Actual Total Time": 67137.645, "Actual Rows": 313645, "Actual Loops": 1, "Output": ["pricingpro5_.pricelist", "pricingpro5_.pricestd", "pricingpro5_.pricelimit", "pricingpro5_.cost", "pricingpro5_.algorithm", "pricingpro5_.m_product_id", "pricingpro5_.updated"], "Recheck Cond": "((pricingpro5_.m_pricelist_version_id)::text = '7749C48ADC184AFDB11602527908782D'::text)", "Rows Removed by Index Recheck": 0, "Exact Heap Blocks": 52441, "Lossy Heap Blocks": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 57325, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Index Name": "m_productprice_pricelist_ve_un", "Startup Cost": 0.00, "Total Cost": 8104.70, "Plan Rows": 336513, "Plan Width": 0, "Actual Startup Time": 70.621, "Actual Total Time": 70.621, "Actual Rows": 323075, "Actual Loops": 1, "Index Cond": "((pricingpro5_.m_pricelist_version_id)::text = '7749C48ADC184AFDB11602527908782D'::text)", "Shared Hit Blocks": 0, "Shared Read Blocks": 4884, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "c_uom_key", "Relation Name": "c_uom", "Schema": "public", "Alias": "uom9_", "Startup Cost": 0.14, "Total Cost": 0.16, "Plan Rows": 1, "Plan Width": 122, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 1, "Actual Loops": 248333, "Output": ["uom9_.c_uom_id", "uom9_.ad_client_id", "uom9_.ad_org_id", "uom9_.isactive", "uom9_.created", "uom9_.updated", "uom9_.createdby", "uom9_.updatedby", "uom9_.x12de355", "uom9_.uomsymbol", "uom9_.name", "uom9_.description", "uom9_.stdprecision", "uom9_.costingprecision", "uom9_.isdefault", "uom9_.breakdown", "uom9_.uom_type", "uom9_.useinproduction"], "Index Cond": "((uom9_.c_uom_id)::text = (product3_.c_uom_id)::text)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 496664, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "m_product_key", "Relation Name": "m_product", "Schema": "public", "Alias": "product1_", "Startup Cost": 0.42, "Total Cost": 1.62, "Plan Rows": 1, "Plan Width": 115, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "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_.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_.m_product_status_id", "product1_.ismodifytax", "product1_.relateprodcattaxtoservice", "product1_.copyservicemodifytaxconfig", "product1_.em_aeat347_isleasebusiness", "product1_.em_aeat347_situation", "product1_.em_aeat347_referenceid", "product1_.em_aeat347_locationtype", "product1_.em_aeat347_streetname", "product1_.em_aeat347_streetnumbertype", "product1_.em_aeat347_streetnumber", "product1_.em_aeat347_streetnumberqua", "product1_.em_aeat347_building", "product1_.em_aeat347_hall", "product1_.em_aeat347_hallway", "product1_.em_aeat347_floor", "product1_.em_aeat347_apartment", "product1_.em_aeat347_complement", "product1_.em_aeat347_location", "product1_.em_aeat347_county", "product1_.em_aeat347_countycode", "product1_.em_aeat347_regioncode", "product1_.em_aeat347_zipcode", "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_obrdm_delivery_mode", "product1_.em_obrdm_delivery_mode_lyw", "product1_.em_obrdm_isdeliveryservice", "product1_.em_gcnv_giftcardtype", "product1_.em_gcnv_amount", "product1_.em_gcnv_allowpartialreturn", "product1_.em_obgcne_expirationdays", "product1_.em_obpgc_printcard", "product1_.em_obpgc_printtemplate_id", "product1_.em_obpbomv_issubstitute", "product1_.em_obpbomv_substituteprocess", "product1_.em_phieco_deee", "product1_.em_phieco_dea", "product1_.em_phieco_deee_qty", "product1_.em_phieco_dea_qty", "product1_.em_obmupc_multiupc_desc", "product1_.em_obpos_maxpriceassocprod", "product1_.em_obpos_minpriceassocprod", "product1_.em_obretur_notusereturnreason"], "Index Cond": "((obretco_pr0_.m_product_id)::text = (product1_.m_product_id)::text)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "ad_image_key", "Relation Name": "ad_image", "Schema": "public", "Alias": "adimage2_", "Startup Cost": 0.14, "Total Cost": 0.44, "Plan Rows": 1, "Plan Width": 188, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["adimage2_.ad_image_id", "adimage2_.ad_client_id", "adimage2_.ad_org_id", "adimage2_.isactive", "adimage2_.created", "adimage2_.createdby", "adimage2_.updated", "adimage2_.updatedby", "adimage2_.name", "adimage2_.imageurl", "adimage2_.binarydata", "adimage2_.width", "adimage2_.height", "adimage2_.mimetype"], "Index Cond": "((product1_.ad_image_id)::text = (adimage2_.ad_image_id)::text)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] }, { "Node Type": "Materialize", "Parent Relationship": "Inner", "Parallel Aware": false, "Startup Cost": 0.00, "Total Cost": 1.01, "Plan Rows": 1, "Plan Width": 90, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["attributes4_.isserno", "attributes4_.m_attributeset_id"], "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Relation Name": "m_attributeset", "Schema": "public", "Alias": "attributes4_", "Startup Cost": 0.00, "Total Cost": 1.01, "Plan Rows": 1, "Plan Width": 90, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["attributes4_.isserno", "attributes4_.m_attributeset_id"], "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "m_product_key", "Relation Name": "m_product", "Schema": "public", "Alias": "product_co11_", "Startup Cost": 0.42, "Total Cost": 1.52, "Plan Rows": 1, "Plan Width": 157, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["product_co11_.m_product_id", "product_co11_.ad_client_id", "product_co11_.ad_org_id", "product_co11_.isactive", "product_co11_.created", "product_co11_.createdby", "product_co11_.updated", "product_co11_.updatedby", "product_co11_.value", "product_co11_.name", "product_co11_.description", "product_co11_.documentnote", "product_co11_.help", "product_co11_.upc", "product_co11_.sku", "product_co11_.c_uom_id", "product_co11_.salesrep_id", "product_co11_.issummary", "product_co11_.isstocked", "product_co11_.ispurchased", "product_co11_.issold", "product_co11_.isbom", "product_co11_.isinvoiceprintdetails", "product_co11_.ispicklistprintdetails", "product_co11_.isverified", "product_co11_.m_product_category_id", "product_co11_.classification", "product_co11_.volume", "product_co11_.weight", "product_co11_.shelfwidth", "product_co11_.shelfheight", "product_co11_.shelfdepth", "product_co11_.unitsperpallet", "product_co11_.c_taxcategory_id", "product_co11_.s_resource_id", "product_co11_.discontinued", "product_co11_.discontinuedby", "product_co11_.processing", "product_co11_.s_expensetype_id", "product_co11_.producttype", "product_co11_.imageurl", "product_co11_.descriptionurl", "product_co11_.guaranteedays", "product_co11_.versionno", "product_co11_.m_attributeset_id", "product_co11_.m_attributesetinstance_id", "product_co11_.downloadurl", "product_co11_.m_freightcategory_id", "product_co11_.m_locator_id", "product_co11_.ad_image_id", "product_co11_.c_bpartner_id", "product_co11_.ispriceprinted", "product_co11_.name2", "product_co11_.stock_min", "product_co11_.enforce_attribute", "product_co11_.calculated", "product_co11_.ma_processplan_id", "product_co11_.production", "product_co11_.capacity", "product_co11_.delaymin", "product_co11_.mrp_planner_id", "product_co11_.mrp_planningmethod_id", "product_co11_.qtymax", "product_co11_.qtymin", "product_co11_.qtystd", "product_co11_.qtytype", "product_co11_.stockmin", "product_co11_.attrsetvaluetype", "product_co11_.isquantityvariable", "product_co11_.isdeferredrevenue", "product_co11_.revplantype", "product_co11_.periodnumber", "product_co11_.isdeferredexpense", "product_co11_.expplantype", "product_co11_.periodnumber_exp", "product_co11_.defaultperiod", "product_co11_.defaultperiod_exp", "product_co11_.bookusingpoprice", "product_co11_.c_uom_weight_id", "product_co11_.m_brand_id", "product_co11_.isgeneric", "product_co11_.generic_product_id", "product_co11_.createvariants", "product_co11_.characteristic_desc", "product_co11_.updateinvariants", "product_co11_.managevariants", "product_co11_.prod_cat_selection", "product_co11_.product_selection", "product_co11_.print_description", "product_co11_.returnable", "product_co11_.overdue_return_days", "product_co11_.ispricerulebased", "product_co11_.unique_per_document", "product_co11_.relateprodcattoservice", "product_co11_.relateprodtoservice", "product_co11_.islinkedtoproduct", "product_co11_.quantity_rule", "product_co11_.allow_deferred_sell", "product_co11_.deferred_sell_max_days", "product_co11_.m_product_status_id", "product_co11_.ismodifytax", "product_co11_.relateprodcattaxtoservice", "product_co11_.copyservicemodifytaxconfig", "product_co11_.em_aeat347_isleasebusiness", "product_co11_.em_aeat347_situation", "product_co11_.em_aeat347_referenceid", "product_co11_.em_aeat347_locationtype", "product_co11_.em_aeat347_streetname", "product_co11_.em_aeat347_streetnumbertype", "product_co11_.em_aeat347_streetnumber", "product_co11_.em_aeat347_streetnumberqua", "product_co11_.em_aeat347_building", "product_co11_.em_aeat347_hall", "product_co11_.em_aeat347_hallway", "product_co11_.em_aeat347_floor", "product_co11_.em_aeat347_apartment", "product_co11_.em_aeat347_complement", "product_co11_.em_aeat347_location", "product_co11_.em_aeat347_county", "product_co11_.em_aeat347_countycode", "product_co11_.em_aeat347_regioncode", "product_co11_.em_aeat347_zipcode", "product_co11_.em_obpos_scale", "product_co11_.em_obpos_groupedproduct", "product_co11_.em_obpos_showstock", "product_co11_.em_obpos_show_ch_desc", "product_co11_.em_obpos_proposal_type", "product_co11_.em_obpos_ismultiselectable", "product_co11_.em_obpos_allowanonymoussale", "product_co11_.em_obpos_printservices", "product_co11_.em_obpos_editable_price", "product_co11_.em_obrdm_delivery_mode", "product_co11_.em_obrdm_delivery_mode_lyw", "product_co11_.em_obrdm_isdeliveryservice", "product_co11_.em_gcnv_giftcardtype", "product_co11_.em_gcnv_amount", "product_co11_.em_gcnv_allowpartialreturn", "product_co11_.em_obgcne_expirationdays", "product_co11_.em_obpgc_printcard", "product_co11_.em_obpgc_printtemplate_id", "product_co11_.em_obpbomv_issubstitute", "product_co11_.em_obpbomv_substituteprocess", "product_co11_.em_phieco_deee", "product_co11_.em_phieco_dea", "product_co11_.em_phieco_deee_qty", "product_co11_.em_phieco_dea_qty", "product_co11_.em_obmupc_multiupc_desc", "product_co11_.em_obpos_maxpriceassocprod", "product_co11_.em_obpos_minpriceassocprod", "product_co11_.em_obretur_notusereturnreason"], "Index Cond": "((product_co11_.m_product_id)::text = (product3_.m_product_id)::text)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "SubPlan", "Subplan Name": "SubPlan 2", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "obfmtc_product_taxcat_orgidx", "Relation Name": "obfmtc_product_taxcategory", "Schema": "public", "Alias": "obfmtc_pro6_", "Startup Cost": 13.95, "Total Cost": 26.03, "Plan Rows": 1, "Plan Width": 33, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["obfmtc_pro6_.c_taxcategory_id"], "Index Cond": "((obfmtc_pro6_.m_product_id)::text = (product3_.m_product_id)::text)", "Rows Removed by Index Recheck": 0, "Filter": "((obfmtc_pro6_.isactive = 'Y'::bpchar) AND (ad_isorgincluded('05DC508527714EDA9AC0B5DA58124FBC'::character varying, obfmtc_pro6_.ad_org_id, product3_.ad_client_id) = $2))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Aggregate", "Strategy": "Plain", "Partial Mode": "Simple", "Parent Relationship": "InitPlan", "Subplan Name": "InitPlan 1 (returns $2)", "Parallel Aware": false, "Startup Cost": 13.39, "Total Cost": 13.40, "Plan Rows": 1, "Plan Width": 32, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["min(ad_isorgincluded('05DC508527714EDA9AC0B5DA58124FBC'::character varying, obfmtc_pro7_.ad_org_id, product3_.ad_client_id))"], "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "obfmtc_product_taxcat_orgidx", "Relation Name": "obfmtc_product_taxcategory", "Schema": "public", "Alias": "obfmtc_pro7_", "Startup Cost": 0.55, "Total Cost": 12.63, "Plan Rows": 3, "Plan Width": 33, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["obfmtc_pro7_.obfmtc_product_taxcategory_id", "obfmtc_pro7_.ad_client_id", "obfmtc_pro7_.ad_org_id", "obfmtc_pro7_.isactive", "obfmtc_pro7_.created", "obfmtc_pro7_.createdby", "obfmtc_pro7_.updated", "obfmtc_pro7_.updatedby", "obfmtc_pro7_.m_product_id", "obfmtc_pro7_.c_taxcategory_id", "obfmtc_pro7_.em_norcus_tva_code"], "Index Cond": "((obfmtc_pro7_.m_product_id)::text = (product3_.m_product_id)::text)", "Rows Removed by Index Recheck": 0, "Filter": "((obfmtc_pro7_.isactive = 'Y'::bpchar) AND (ad_isorgincluded('05DC508527714EDA9AC0B5DA58124FBC'::character varying, obfmtc_pro7_.ad_org_id, product3_.ad_client_id) >= '0'::numeric))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Index Scan", "Parent Relationship": "SubPlan", "Subplan Name": "SubPlan 3", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "m_product_trl_product_langu_un", "Relation Name": "m_product_trl", "Schema": "public", "Alias": "producttrl8_", "Startup Cost": 0.55, "Total Cost": 2.77, "Plan Rows": 1, "Plan Width": 25, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["producttrl8_.name"], "Index Cond": "(((producttrl8_.m_product_id)::text = (product3_.m_product_id)::text) AND ((producttrl8_.ad_language)::text = 'fr_FR'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "SubPlan", "Subplan Name": "SubPlan 4", "Parallel Aware": false, "Relation Name": "phieco_taxcategory", "Schema": "public", "Alias": "eco", "Startup Cost": 0.00, "Total Cost": 1.04, "Plan Rows": 1, "Plan Width": 32, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["eco.taxamt"], "Filter": "((eco.phieco_taxcategory_id)::text = (product_co11_.em_phieco_dea)::text)", "Rows Removed by Filter": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "SubPlan", "Subplan Name": "SubPlan 5", "Parallel Aware": false, "Relation Name": "phieco_taxcategory", "Schema": "public", "Alias": "eco_1", "Startup Cost": 0.00, "Total Cost": 1.04, "Plan Rows": 1, "Plan Width": 32, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["eco_1.taxamt"], "Filter": "((eco_1.phieco_taxcategory_id)::text = (product_co11_.em_phieco_deee)::text)", "Rows Removed by Filter": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "SubPlan", "Subplan Name": "SubPlan 6", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "obpos_printtemplate_pk", "Relation Name": "obpos_print_template", "Schema": "public", "Alias": "obpos_prin13_", "Startup Cost": 0.14, "Total Cost": 2.36, "Plan Rows": 1, "Plan Width": 516, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["obpos_prin13_.template_path"], "Index Cond": "((product3_.em_obpgc_printtemplate_id)::text = (obpos_prin13_.obpos_print_template_id)::text)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "SubPlan", "Subplan Name": "SubPlan 7", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "obpos_printtemplate_pk", "Relation Name": "obpos_print_template", "Schema": "public", "Alias": "obpos_prin14_", "Startup Cost": 0.14, "Total Cost": 2.36, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["obpos_prin14_.ispdf"], "Index Cond": "((product3_.em_obpgc_printtemplate_id)::text = (obpos_prin14_.obpos_print_template_id)::text)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "SubPlan", "Subplan Name": "SubPlan 8", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "obpos_printtemplate_pk", "Relation Name": "obpos_print_template", "Schema": "public", "Alias": "obpos_prin15_", "Startup Cost": 0.14, "Total Cost": 2.36, "Plan Rows": 1, "Plan Width": 32, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 0, "Actual Loops": 0, "Output": ["obpos_prin15_.printer"], "Index Cond": "((product3_.em_obpgc_printtemplate_id)::text = (obpos_prin15_.obpos_print_template_id)::text)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, "Planning Time": 11.340, "Triggers": [], "Execution Time": 208628.052 } ]