Most slow queries I have fixed were missing an index that the access pattern made obvious on day one.
Owner first
In multi-tenant tables, every query filters by owner. Lead the index with it.
create index on project (user_id, status);Order by what you sort
If a list is always newest first, the index should say so.