Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042364Retail ModulesWeb POSpublic2019-11-21 16:562020-03-02 19:53
ReporterioritzCia 
Assigned ToRetail 
PrioritynormalSeveritymajorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS30OS VersionUbuntu 18.04
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0042364: [Performance] Create index to improve time of query to check if there are services for a product
DescriptionThe query makes a bitmapAnd Index scan and looses a lot of time in the re-check condition in the Bitmap Heap scan making a double partial double column index accelerates this a lot and avoids the re-check.

Plan without index:
https://explain.depesz.com/s/8To9 [^]

Plan with index:
https://explain.depesz.com/s/c6B [^]
Steps To ReproduceAdd a product to a ticket in WebPOS
Proposed Solutioncreate index em_obpos_product_type_org on m_product (ad_org_id, producttype) where producttype = 'S' and islinkedtoproduct = 'Y';

The index is really small and affects very few rows due to producttype = 'S' and islinkedtoproduct = 'Y' clause
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-11-21 16:56ioritzCiaNew Issue
2019-11-21 16:56ioritzCiaAssigned To => Retail
2019-11-21 16:56ioritzCiaTriggers an Emergency Pack => No
2020-03-02 19:51rqueraltaAssigned ToRetail => rqueralta
2020-03-02 19:51rqueraltaStatusnew => scheduled
2020-03-02 19:53rqueraltaStatusscheduled => acknowledged
2020-03-02 19:53rqueraltaAssigned Torqueralta => Retail

There are no notes attached to this issue.