Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0047314 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | minor | have not tried | 2021-07-01 13:34 | 2021-07-27 11:09 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | ranjith_qualiantech_com | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | RR21Q4 | |||
| 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 | |||||||
| Merge Request Status | approved | |||||||
| Review Assigned To | ||||||||
| OBNetwork customer | Gold | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0047314: Review indexes for obpos_errors_line table | |||||||
| Description | That 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 Reproduce | in 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) | |||||||
| Tags | NOR | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
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 [^] |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 | OBNetwork customer | No => Gold |
| 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 | Merge Request Status | => open |
| 2021-07-26 13:31 | hgbot | Note Added: 0130761 | |
| 2021-07-27 11:09 | hgbot | Merge Request Status | open => approved |
| 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |