Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0047314
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSminorhave not tried2021-07-01 13:342021-07-27 11:09
ReportershuehnerView Statuspublic 
Assigned Toranjith_qualiantech_com 
PrioritynormalResolutionfixedFixed in VersionRR21Q4
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0047314: Review indexes for obpos_errors_line table

DescriptionThat table was added without any indexes created.

That leads to id being access via sequential scan on every query which is not efficient (if table grows).

All queries should be reviewed and the required indexes created.

For queries at least check for
- PaidReceipts
- likely indexes
  - obpos_errors_id
  - maybe record_id (to check plans with real data)
Steps To Reproducein a webpos production instance:
select * from pg_stat_user_tables order by seq_tup_read desc;

Data shown:
- 4.2M seq scans
- 5B tuples read
- only 4k index scans (via pk)
TagsNOR
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0130761)
hgbot (developer)
2021-07-26 13:31

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/524 [^]
(0130775)
hgbot (developer)
2021-07-27 11:09

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: c120ab3ef405e1ced14c009c4b16deef25bec991
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 2021-07-26T13:27:07+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/c120ab3ef405e1ced14c009c4b16deef25bec991 [^]

Fixed ISSUE-47314: Added index to OBPOS_Errors, OBPOS_Errors_Line table

---
M src-db/database/model/tables/OBPOS_ERRORS.xml
M src-db/database/model/tables/OBPOS_ERRORS_LINE.xml
---
(0130776)
hgbot (developer)
2021-07-27 11:09

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/524 [^]

- Issue History
Date Modified Username Field Change
2021-07-01 13:34 shuehner New Issue
2021-07-01 13:34 shuehner Assigned To => Retail
2021-07-01 13:34 shuehner Triggers an Emergency Pack => No
2021-07-01 13:37 shuehner Tag Attached: NOR
2021-07-01 13:37 shuehner Resolution time => 1626904800
2021-07-07 11:18 rafaroda Issue Monitored: rafaroda
2021-07-08 08:30 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2021-07-08 11:00 sebastien_liron Issue Monitored: sebastien_liron
2021-07-16 09:30 guilleaer Status new => scheduled
2021-07-26 13:31 hgbot Note Added: 0130761
2021-07-27 11:09 hgbot Resolution open => fixed
2021-07-27 11:09 hgbot Status scheduled => closed
2021-07-27 11:09 hgbot Fixed in Version => RR21Q4
2021-07-27 11:09 hgbot Note Added: 0130775
2021-07-27 11:09 hgbot Note Added: 0130776


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker