Some index are missing in order to achieve acceptable performances in git repositories listing.
ALTER TABLE plugin_git ADD INDEX idx_project_repository(project_id, repository_id);
ALTER TABLE plugin_git_log ADD INDEX idx_repository_date(repository_id, push_date);