<div dir="ltr"><div>No worries, <br></div><div>thanks for having fixed this</div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Oct 5, 2020 at 8:16 AM Richard Richter via midPoint <<a href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</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><div style="font-family:arial,helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)"><div>Hi<br></div><div><br></div><div>I recently fixed the issue you mentioned, but I totally forgot it was about History tab during the process. It didn't click into place at all when I was reading your mail. I'm really sorry about it.<br></div><div><br></div><div>I'm glad you figured it out eventually.<br></div><div><br></div><div>Best regards<br></div><div><br></div><div>Richard Richter<br></div><div>midPoint developer<br></div><div><br></div><hr id="gmail-m_6460485309060318858zwchr"><div><b>From: </b>"midPoint General Discussion" <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br><b>To: </b>"midPoint General Discussion" <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br><b>Cc: </b>"Alexandre Zia" <<a href="mailto:alexandre.zia@ifood.com.br" target="_blank">alexandre.zia@ifood.com.br</a>><br><b>Sent: </b>Friday, October 2, 2020 4:20:54 PM<br><b>Subject: </b>Re: [midPoint] History tab in GUI is insanely slow<br></div><div><br></div><div><div dir="ltr"><div>Regarding this,<br></div><div>To help others that may find this message inthe future:<br></div><br><div>Just found this issue: <a href="https://jira.evolveum.com/browse/MID-6232" rel="nofollow noopener noreferrer" target="_blank">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><br><br><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" rel="nofollow noopener noreferrer" target="_blank">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>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><br><div>Using postgresql 12<br></div><br><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><br><div>Thanks in advance</div><br><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-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)" rel="nofollow noopener noreferrer" target="_blank"><img alt="" src="https://www.ifood.com.br/nws/assinatura/iFood_assinatura3.gif" width="105" height="110"></a><br></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" rel="nofollow noopener noreferrer" target="_blank">www.ifood.com.br</a><br></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)" rel="nofollow noopener noreferrer" target="_blank"><img alt="" src="https://www.ifood.com.br/nws/assinatura/facebook_2x.png" width="32" height="32"></a><br></td><td style="font-family:"arial",sans-serif;margin:0px"><a href="https://twitter.com/iFood" style="color:rgb(17,85,204)" rel="nofollow noopener noreferrer" target="_blank"><img alt="" src="https://www.ifood.com.br/nws/assinatura/twitter_2x.png" width="32" height="32"></a><br></td><td style="font-family:"arial",sans-serif;margin:0px"><a href="https://www.instagram.com/iFoodBrasil/" style="color:rgb(17,85,204)" rel="nofollow noopener noreferrer" target="_blank"><img alt="" src="https://www.ifood.com.br/nws/assinatura/instagram_2x.png" width="32" height="32"></a><br></td><td style="font-family:"arial",sans-serif;margin:0px"><a href="https://www.youtube.com/ifood" style="color:rgb(17,85,204)" rel="nofollow noopener noreferrer" target="_blank"><img alt="" src="https://www.ifood.com.br/nws/assinatura/youtube_2x.png" width="32" height="32"></a><br></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-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"><div dir="ltr"><div><div dir="ltr"><table style="font-family:"arial",sans-serif;font-style:normal;font-weight:400;letter-spacing:normal;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)" rel="nofollow noopener noreferrer" target="_blank"><img alt="" src="https://www.ifood.com.br/nws/assinatura/iFood_assinatura3.gif" width="105" height="110"></a><br></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" rel="nofollow noopener noreferrer" target="_blank">www.ifood.com.br</a><br></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)" rel="nofollow noopener noreferrer" target="_blank"><img alt="" src="https://www.ifood.com.br/nws/assinatura/facebook_2x.png" width="32" height="32"></a><br></td><td style="font-family:"arial",sans-serif;margin:0px"><a href="https://twitter.com/iFood" style="color:rgb(17,85,204)" rel="nofollow noopener noreferrer" target="_blank"><img alt="" src="https://www.ifood.com.br/nws/assinatura/twitter_2x.png" width="32" height="32"></a><br></td><td style="font-family:"arial",sans-serif;margin:0px"><a href="https://www.instagram.com/iFoodBrasil/" style="color:rgb(17,85,204)" rel="nofollow noopener noreferrer" target="_blank"><img alt="" src="https://www.ifood.com.br/nws/assinatura/instagram_2x.png" width="32" height="32"></a><br></td><td style="font-family:"arial",sans-serif;margin:0px"><a href="https://www.youtube.com/ifood" style="color:rgb(17,85,204)" rel="nofollow noopener noreferrer" target="_blank"><img alt="" src="https://www.ifood.com.br/nws/assinatura/youtube_2x.png" width="32" height="32"></a><br></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-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>
<br>_______________________________________________<br>midPoint mailing list<br><a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br><a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br></div></div></div>_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</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>