Indexes missing

[jgimenez]

After some time of usage, the dashboard becomes very very slow, up to the point of queries timing out.

I found these two indices help:

ALTER TABLE email_event ADD INDEX timestamp (timestamp);
ALTER TABLE email ADD INDEX project_id_timestamp (project_id,timestamp);

[matt-t-d]

Also consider

ALTER TABLE email ADD INDEX message_id (message_id);