<div dir="ltr"><div>Regarding this,<br></div><div>To help others that may find this message inthe future:<br></div><div><br></div><div>Just found this issue: <a href="https://jira.evolveum.com/browse/MID-6232">https://jira.evolveum.com/browse/MID-6232</a><br><br></div><div>Fixed by adding an index to database:<br><br>CREATE INDEX iAuditEventRecordEStageTOid<br>  ON m_audit_event (eventStage, targetOid);</div><div><br></div><div><br></div><div><br> </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Oct 1, 2020 at 11:11 AM Alexandre Zia <<a href="mailto:alexandre.zia@ifood.com.br">alexandre.zia@ifood.com.br</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>We jumped from 3.9 to 4.1 (upgraded at once from 3.9 to 4.0, and from 4.0 to 4.1)<br></div><div>So We didn't use 4.0.<br></div><div></div><div>Since we went to 4.1 consulting history tab for users is insanely slow, take minutes and as midpoint GUI interface doesn't allow opening each item in a new tab (oh man that would be awesome ...) it's impossible to use history tab</div><div><br></div><div>Using postgresql 12<br></div><div><br></div><div>Anyone having the same issue?</div><div>Is there something we can do to fix this? perhaps an index on the database?<br></div><div><div><div><br></div><div>Thanks in advance</div><div><br></div><div>-- <br><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><table style="font-family:arial,sans-serif;font-style:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);color:rgb(0,0,0);font-size:medium" width="450" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td rowspan="6" style="font-family:arial,sans-serif;margin:0px" width="105" valign="top" height="120" align="right"><a href="https://www.ifood.com.br/" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.ifood.com.br/nws/assinatura/iFood_assinatura3.gif" alt="" width="105" height="110"></a></td><td style="font-family:arial,sans-serif;margin:0px" width="18"><br></td><td style="font-family:arial,sans-serif;margin:0px" height="22"><div style="line-height:18px;font-family:Montserrat,"Trebuchet MS","Lucida Grande","Lucida Sans Unicode","Lucida Sans",Tahoma,sans-serif;color:rgb(85,85,85)"><p style="margin:0px;line-height:18px"><span style="font-size:14px">Alexandre R Zia<br></span></p></div></td></tr><tr><td style="font-family:arial,sans-serif;margin:0px" width="18"><br></td><td style="font-family:arial,sans-serif;margin:0px"><div style="font-size:12px;line-height:14px;font-family:Montserrat,"Trebuchet MS","Lucida Grande","Lucida Sans Unicode","Lucida Sans",Tahoma,sans-serif;color:rgb(228,0,43)"><p style="margin:0px;line-height:15px"><span style="line-height:15px"><b>Security</b></span></p></div></td></tr><tr><td style="font-family:arial,sans-serif;margin:0px" width="18" height="10"><br></td><td style="font-family:arial,sans-serif;margin:0px" height="10"><br></td></tr><tr><td style="font-family:arial,sans-serif;margin:0px" width="18"><br></td><td style="font-family:arial,sans-serif;margin:0px"><br></td></tr><tr><td style="font-family:arial,sans-serif;margin:0px" width="18"><br></td><td style="font-family:arial,sans-serif;margin:0px"><div style="font-size:11px;line-height:16px;font-family:Montserrat,"Trebuchet MS","Lucida Grande","Lucida Sans Unicode","Lucida Sans",Tahoma,sans-serif"><a href="https://www.ifood.com.br/" style="color:rgb(119,119,119);line-height:16px" target="_blank">www.ifood.com.br</a></div></td></tr><tr><td colspan="2" style="font-family:arial,sans-serif;margin:0px" height="35"><table width="190" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="font-family:arial,sans-serif;margin:0px" width="12"> </td><td style="font-family:arial,sans-serif;margin:0px"><a href="https://www.facebook.com/iFood?fref=ts" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.ifood.com.br/nws/assinatura/facebook_2x.png" alt="" width="32" height="32"></a></td><td style="font-family:arial,sans-serif;margin:0px"><a href="https://twitter.com/iFood" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.ifood.com.br/nws/assinatura/twitter_2x.png" alt="" width="32" height="32"></a></td><td style="font-family:arial,sans-serif;margin:0px"><a href="https://www.instagram.com/iFoodBrasil/" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.ifood.com.br/nws/assinatura/instagram_2x.png" alt="" width="32" height="32"></a></td><td style="font-family:arial,sans-serif;margin:0px"><a href="https://www.youtube.com/ifood" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.ifood.com.br/nws/assinatura/youtube_2x.png" alt="" width="32" height="32"></a></td></tr></tbody></table></td></tr></tbody></table><table style="color:rgb(34,34,34);font-style:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);font-size:13px;line-height:normal;font-family:tahoma,geneva,sans-serif" width="630" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="font-family:arial,sans-serif;margin:0px"><table width="100%" cellspacing="0" cellpadding="0" border="0"></table></td></tr></tbody></table></div></div></div></div></div></div></div></div>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><table style="font-family:arial,sans-serif;font-style:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);color:rgb(0,0,0);font-size:medium" width="450" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td rowspan="6" style="font-family:arial,sans-serif;margin:0px" width="105" valign="top" height="120" align="right"><a href="https://www.ifood.com.br/" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.ifood.com.br/nws/assinatura/iFood_assinatura3.gif" alt="" width="105" height="110"></a></td><td style="font-family:arial,sans-serif;margin:0px" width="18"><br></td><td style="font-family:arial,sans-serif;margin:0px" height="22"><div style="line-height:18px;font-family:Montserrat,"Trebuchet MS","Lucida Grande","Lucida Sans Unicode","Lucida Sans",Tahoma,sans-serif;color:rgb(85,85,85)"><p style="margin:0px;line-height:18px"><span style="font-size:14px">Alexandre R Zia<br></span></p></div></td></tr><tr><td style="font-family:arial,sans-serif;margin:0px" width="18"><br></td><td style="font-family:arial,sans-serif;margin:0px"><div style="font-size:12px;line-height:14px;font-family:Montserrat,"Trebuchet MS","Lucida Grande","Lucida Sans Unicode","Lucida Sans",Tahoma,sans-serif;color:rgb(228,0,43)"><p style="margin:0px;line-height:15px"><span style="line-height:15px"><b>Security</b></span></p></div></td></tr><tr><td style="font-family:arial,sans-serif;margin:0px" width="18" height="10"><br></td><td style="font-family:arial,sans-serif;margin:0px" height="10"><br></td></tr><tr><td style="font-family:arial,sans-serif;margin:0px" width="18"><br></td><td style="font-family:arial,sans-serif;margin:0px"><br></td></tr><tr><td style="font-family:arial,sans-serif;margin:0px" width="18"><br></td><td style="font-family:arial,sans-serif;margin:0px"><div style="font-size:11px;line-height:16px;font-family:Montserrat,"Trebuchet MS","Lucida Grande","Lucida Sans Unicode","Lucida Sans",Tahoma,sans-serif"><a href="https://www.ifood.com.br/" style="color:rgb(119,119,119);line-height:16px" target="_blank">www.ifood.com.br</a></div></td></tr><tr><td colspan="2" style="font-family:arial,sans-serif;margin:0px" height="35"><table width="190" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="font-family:arial,sans-serif;margin:0px" width="12"> </td><td style="font-family:arial,sans-serif;margin:0px"><a href="https://www.facebook.com/iFood?fref=ts" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.ifood.com.br/nws/assinatura/facebook_2x.png" alt="" width="32" height="32"></a></td><td style="font-family:arial,sans-serif;margin:0px"><a href="https://twitter.com/iFood" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.ifood.com.br/nws/assinatura/twitter_2x.png" alt="" width="32" height="32"></a></td><td style="font-family:arial,sans-serif;margin:0px"><a href="https://www.instagram.com/iFoodBrasil/" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.ifood.com.br/nws/assinatura/instagram_2x.png" alt="" width="32" height="32"></a></td><td style="font-family:arial,sans-serif;margin:0px"><a href="https://www.youtube.com/ifood" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.ifood.com.br/nws/assinatura/youtube_2x.png" alt="" width="32" height="32"></a></td></tr></tbody></table></td></tr></tbody></table><table style="color:rgb(34,34,34);font-style:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);font-size:13px;line-height:normal;font-family:tahoma,geneva,sans-serif" width="630" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="font-family:arial,sans-serif;margin:0px"><table width="100%" cellspacing="0" cellpadding="0" border="0"></table></td></tr></tbody></table></div></div></div></div>