Openbravo Issue Tracking System - Retail Modules | |||||
View Issue Details | |||||
ID | Project | Category | View Status | Date Submitted | Last Update |
0047314 | Retail Modules | Web POS | public | 2021-07-01 13:34 | 2021-07-27 11:09 |
Reporter | shuehner | ||||
Assigned To | ranjith_qualiantech_com | ||||
Priority | normal | Severity | minor | Reproducibility | have not tried |
Status | closed | Resolution | fixed | ||
Platform | OS | 5 | OS Version | ||
Product Version | |||||
Target Version | Fixed in Version | RR21Q4 | |||
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 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) | ||||
Proposed Solution | |||||
Additional Information | |||||
Tags | NOR | ||||
Relationships | |||||
Attached Files | |||||
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 |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|