I eventually fix it by running:
ANALYZE TABLE project_reports; (query from 26 seconds down to 17 seconds)
AND adding composite indexes (query from 17 seconds down to 900ms)