Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0049617 | Openbravo ERP | I. Performance | public | 2022-06-21 13:43 | 2022-08-18 08:30 |
| Reporter | shankarb | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 30 | OS Version | Openbravo Appliance 14.04 | |
| Product Version | |||||
| Target Version | Fixed in Version | PR22Q4 | |||
| Merge Request Status | approved | ||||
| Review Assigned To | |||||
| OBNetwork customer | OBPS | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | 41898 | ||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0049617: performance imporovement on the ad_session table | ||||
| Description | On environment with lot of concurrency and lot of external calls to the server we have identified a query that is executed continuously and reading lot of information from the disk. The query is the following: select max(adsession0_.Created) as col_0_0_ from AD_Session adsession0_ where adsession0_.Username=$1 and adsession0_.Login_Status<>'F' Adding an index (username,login_status) on the ad_session table improves the performance across the System during API calls. Noticed this while analyzing the query performance in CSU customers. Contact Egoitz if there are any doubts. | ||||
| Steps To Reproduce | Having pg_stat_statements installed on the database of a customer with lot of concurrencies, we have taken some statistics about the information read. The result is that for the query on the ad-sesion table, many TB of disk are readed. The data read per execution is 788MB but as the query is executed many times, the accumulated data read is really high. To enable pg_stat_statemnts: http://wiki.openbravo.com/wiki/Finding_Perfomance_Issues#Tracking_SQL_Statements [^] | ||||
| Proposed Solution | Add the index (username,login_status) on the ad_session | ||||
| Additional Information | |||||
| Tags | NOR | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2022-06-21 13:43 | shankarb | New Issue | |||
| 2022-06-21 13:43 | shankarb | Assigned To | => Triage Platform Base | ||
| 2022-06-21 13:43 | shankarb | OBNetwork customer | => OBPS | ||
| 2022-06-21 13:43 | shankarb | Modules | => Core | ||
| 2022-06-21 13:43 | shankarb | Support ticket | => 41898 | ||
| 2022-06-21 13:43 | shankarb | Triggers an Emergency Pack | => No | ||
| 2022-06-21 13:58 | shankarb | Description Updated | bug_revision_view_page.php?rev_id=24328#r24328 | ||
| 2022-06-21 13:58 | shankarb | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=24330#r24330 | ||
| 2022-06-22 14:38 | rafaroda | Tag Attached: NOR | |||
| 2022-07-18 09:45 | egoitz | Severity | minor => major | ||
| 2022-07-18 09:45 | egoitz | Summary | Index in session table => performance imporovement on the ad_session table | ||
| 2022-07-18 09:45 | egoitz | Description Updated | bug_revision_view_page.php?rev_id=24507#r24507 | ||
| 2022-07-18 09:45 | egoitz | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=24508#r24508 | ||
| 2022-08-16 13:23 | hgbot | Merge Request Status | => open | ||
| 2022-08-16 13:23 | hgbot | Note Added: 0140153 | |||
| 2022-08-17 00:02 | hgbot | Merge Request Status | open => approved | ||
| 2022-08-17 00:02 | hgbot | Merge Request Status | approved => open | ||
| 2022-08-17 13:27 | hgbot | Merge Request Status | open => approved | ||
| 2022-08-18 08:30 | hgbot | Resolution | open => fixed | ||
| 2022-08-18 08:30 | hgbot | Status | new => closed | ||
| 2022-08-18 08:30 | hgbot | Fixed in Version | => PR22Q4 | ||
| 2022-08-18 08:30 | hgbot | Note Added: 0140214 | |||
| 2022-08-18 08:30 | hgbot | Note Added: 0140215 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||