Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0023648 | Openbravo ERP | A. Platform | public | 2013-04-25 18:25 | 2013-04-30 12:05 |
| Reporter | egoitz | ||||
| Assigned To | alostale | ||||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | shankarb | ||||
| OBNetwork customer | No | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0023648: index missing on ad_session | ||||
| Description | Index missing on ad_session | ||||
| Steps To Reproduce | In a professional instance with limitation on concurrent users. Execute select * from pg_stat_reset(); Then login the application then execute: select * from pg_stat_user_tables order by seq_tup_read desc; See that a sequencial read is done | ||||
| Proposed Solution | CREATE INDEX ad_session_logstatus ON ad_session USING btree (Login_Status); | ||||
| Additional Information | |||||
| Tags | Performance | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2013-04-25 18:25 | egoitz | New Issue | |||
| 2013-04-25 18:25 | egoitz | Assigned To | => AugustoMauch | ||
| 2013-04-25 18:25 | egoitz | Modules | => Core | ||
| 2013-04-25 18:25 | egoitz | OBNetwork customer | => No | ||
| 2013-04-25 18:25 | egoitz | Triggers an Emergency Pack | => No | ||
| 2013-04-25 18:26 | egoitz | Proposed Solution updated | |||
| 2013-04-26 07:42 | alostale | Tag Attached: Performance | |||
| 2013-04-26 10:15 | alostale | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=4618#r4618 | ||
| 2013-04-26 10:15 | alostale | Assigned To | AugustoMauch => alostale | ||
| 2013-04-26 10:19 | hgbot | Checkin | |||
| 2013-04-26 10:19 | hgbot | Note Added: 0058272 | |||
| 2013-04-26 10:19 | hgbot | Status | new => resolved | ||
| 2013-04-26 10:19 | hgbot | Resolution | open => fixed | ||
| 2013-04-26 10:19 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/cc13ee201af82e14856d3c496deeaa4780b8a6a2 [^] | ||
| 2013-04-26 10:20 | alostale | Review Assigned To | => shankarb | ||
| 2013-04-26 23:54 | hudsonbot | Checkin | |||
| 2013-04-26 23:54 | hudsonbot | Note Added: 0058293 | |||
| 2013-04-30 12:05 | shankarb | Note Added: 0058341 | |||
| 2013-04-30 12:05 | shankarb | Status | resolved => closed | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||