Pre-calculate total geo area and time max limit for project groups

[thenav56]

Changes

• Add two new columns in the groups table to use in aggregated data calculation. We are currently calculating this in fly for each calculation run
  • total_area float
  • time_spent_max_allowed float

Why

Caching the geo areas decreases stat calculation time significantly. For eg: For the whole 2022 year data (by calculating 1 month at a time), It took more than 5 days. After the current implementation, it took around 1-2 hours and the majority of time was spent on initial cache calculation.

Deployment steps

• Run SQL migration script

  postgres/scripts/v2_to_v3/06_alter_groups_data_add_total_area_and_time_limit_columns.sql

• Run aggregated data collection (Optional)

  docker-compose run --rm django ./manage.py update_aggregated_data