Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0044911 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | have not tried | 2020-08-27 15:05 | 2020-09-11 08:01 | |||
| Reporter | AugustoMauch | View Status | public | |||||
| Assigned To | ranjith_qualiantech_com | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | RR20Q4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0044911: Incremental refresh of Product cannot use index on updated | |||||||
| Description | This is part of the query done to do an incremental refresh of products: hql += "AND ((product.$incrementalUpdateCriteria) OR (pli.$incrementalUpdateCriteria) OR (ppp.$incrementalUpdateCriteria) OR (product.uOM.$incrementalUpdateCriteria))"; This means that a product will be returned if any of these have been modified: - the product itself - its entry in the assortment - its entry in the price list - its unit of measure This is very complete, but it does not have good performance with big volumes, because the OR clauses prevents the use of indexes. An index should be added to m_product.updated | |||||||
| Steps To Reproduce | To reproduce this just do an incremental refresh, and check the explain plan that results when executing the product query. I attached one to this issue | |||||||
| Proposed Solution | Create a new preference that allows to check only the "updated" column of m_product when doing an incremental refresh. Then each integration module should be in charge of making sure that the m_product.updated column is updated when needed | |||||||
| Tags | NOR | |||||||
| Attached Files |  productIncrementalRefresh.sql [^] (7,042 bytes) 2020-08-27 15:06 productIncrementalRefreshExplainPlan.txt [^] (73,727 bytes) 2020-08-27 15:07 [Show Content] [Hide Content][
{
"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
}
]
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0122434) rafaroda (developer) 2020-08-28 15:43 |
See comment on 0044590: triggers required in order to updated the M_PRODUCT.UPDATED column as it exists nowadays in Multi UPC table and Multiple Tax Category table |
|
(0122939) hgbot (developer) 2020-09-11 07:34 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/94 [^] |
|
(0122940) hgbot (developer) 2020-09-11 08:01 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/94 [^] |
|
(0122941) hgbot (developer) 2020-09-11 08:01 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^] Changeset: 0d22ec64d6071f68b79c8a25f4cf32314d6385b8 Author: Ranjith S R <ranjith@qualiantech.com> Date: 2020-09-11T11:03:13+05:30 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/0d22ec64d6071f68b79c8a25f4cf32314d6385b8 [^] Fixed ISSUE-44911: Filter MasterData Product by Related Entities on doing refresh --- M src-db/database/sourcedata/AD_PREFERENCE.xml M src-db/database/sourcedata/AD_REF_LIST.xml M src/org/openbravo/retail/posterminal/master/Product.java --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2020-08-27 15:05 | AugustoMauch | New Issue | |
| 2020-08-27 15:05 | AugustoMauch | Assigned To | => Retail |
| 2020-08-27 15:05 | AugustoMauch | Triggers an Emergency Pack | => No |
| 2020-08-27 15:06 | AugustoMauch | Resolution time | => 1599688800 |
| 2020-08-27 15:06 | AugustoMauch | File Added: productIncrementalRefresh.sql | |
| 2020-08-27 15:07 | AugustoMauch | File Added: productIncrementalRefreshExplainPlan.txt | |
| 2020-08-27 15:08 | AugustoMauch | Description Updated | View Revisions |
| 2020-08-28 09:50 | rafaroda | Tag Attached: NOR | |
| 2020-08-28 15:41 | rafaroda | Relationship added | related to 0044590 |
| 2020-08-28 15:43 | rafaroda | Note Added: 0122434 | |
| 2020-09-04 04:55 | ranjith_qualiantech_com | Assigned To | Retail => ranjith_qualiantech_com |
| 2020-09-10 10:43 | ranjith_qualiantech_com | Status | new => scheduled |
| 2020-09-11 07:34 | hgbot | Note Added: 0122939 | |
| 2020-09-11 08:01 | hgbot | Resolution | open => fixed |
| 2020-09-11 08:01 | hgbot | Status | scheduled => closed |
| 2020-09-11 08:01 | hgbot | Note Added: 0122940 | |
| 2020-09-11 08:01 | hgbot | Fixed in Version | => RR20Q4 |
| 2020-09-11 08:01 | hgbot | Note Added: 0122941 | |
| 2020-09-15 14:56 | rafaroda | Relationship added | related to 0045055 |
| 2020-09-15 14:59 | rafaroda | Relationship added | related to 0045056 |
| 2020-09-25 12:22 | rafaroda | Relationship added | related to 0045144 |
| 2020-10-05 11:37 | rafaroda | Relationship added | related to 0045187 |
| 2021-02-22 09:34 | rafaroda | Relationship added | related to 0045467 |
| 2021-02-22 10:47 | rafaroda | Relationship added | duplicate of 0045919 |
| 2021-02-22 10:47 | rafaroda | Relationship added | related to 0045922 |
| 2021-07-21 22:31 | rafaroda | Relationship added | related to 0047423 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |