The code is issuing a lot of queries like:
SELECT DISTINCT nature
FROM tracker_changeset_value_artifactlink
WHERE group_id = N
ORDER BY nature ASC;
or
UPDATE tracker_changeset_value_artifactlink SET keyword='S' WHERE keyword='S' AND group_id='S'
We need an index to cover that