Current query looks over all project deployments
and aggregates by environment_id

New query loops over project's environments and
tries to find existing deployment for it

We also add a dedicated index on
[environment_id, ref] to speed up this new query.

Changelog: added