Add eventlog.event index

[jamoore]

OMERO4.2__0=# explain analyze select logs0_.event as event117_1_, logs0_.id as id1_, logs0_.id as id30_0_, logs0_.action as action30_0_, logs0_.external_id as external6_30_0_, logs0_.permissions as permissi3_30_0_, logs0_.entityId as entityId30_0_, logs0_.entityType as entityType30_0_, logs0_.event as event30_0_ from eventlog logs0_ where logs0_.event=5;
c                                                      QUERY PLAN                                                       
-----------------------------------------------------------------------------------------------------------------------
 Seq Scan on eventlog logs0_  (cost=0.00..226184.53 rows=988 width=82) (actual time=1193.294..2978.840 rows=2 loops=1)
   Filter: (event = 5)
 Total runtime: 2978.983 ms
(3 rows)

OMERO4.2__0=# create index eventlog_event on eventlog (event);
CREATE INDEX
OMERO4.2__0=# explain analyze select logs0_.event as event117_1_, logs0_.id as id1_, logs0_.id as id30_0_, logs0_.action as action30_0_, logs0_.external_id as external6_30_0_, logs0_.permissions as permissi3_30_0_, logs0_.entityId as entityId30_0_, logs0_.entityType as entityType30_0_, logs0_.event as event30_0_ from eventlog logs0_ where logs0_.event=5;
                                                             QUERY PLAN                                                              
-------------------------------------------------------------------------------------------------------------------------------------
 Index Scan using eventlog_event on eventlog logs0_  (cost=0.00..47.78 rows=1003 width=82) (actual time=0.123..0.124 rows=2 loops=1)
   Index Cond: (event = 5)
 Total runtime: 0.159 ms
(3 rows)

OMERO4.2__0=# select count(id) from eventlog;  count  ---------
 8822539
(1 row)

I was seeing quite long hangs locally during UpdateServiceTest due to extensive eventlogs, similarly to how the OmeroJava job has been failing:

Error Message

Method public void integration.UpdateServiceTest.testChannelMoveWithSpaceFillsSpace() throws java.lang.Exception didn't finish within the time-out 30000

Stacktrace

org.testng.internal.thread.ThreadTimeoutException: Method public void integration.UpdateServiceTest.testChannelMoveWithSpaceFillsSpace() throws java.lang.Exception didn't finish within the time-out 30000
  java.lang.Object.wait(Native Method)
  java.lang.Object.wait(Object.java:485)
  IceInternal.Outgoing.invoke(Outgoing.java:109)
  omero.api._IUpdateDelM.saveAndReturnObject(_IUpdateDelM.java:241)
  omero.api.IUpdatePrxHelper.saveAndReturnObject(IUpdatePrxHelper.java:322)

[jmoore]

Referencing ticket #2568 has changed sprint.

[jmoore]

Replaced by #4900