Slow query on 10 millions records of data when applying grouping aggregation

MongoDB Atlas
, ,
6

Your adviced method has returned 3740444, So my index is working fine
I can’t add nothing else to my match query. Maybe restructuring my collection schema could help ?

This is a document from my collection

{
  "_id": {
    "$oid": "662624769fdf3e902efdc912"
  },
  "manager_id": 4,
  "client_id": 826,
  "agent_id": 2388,
  "source": "home_page",
  "property_id": 306351,
  "property_reference": "elegant-2932883",
  "property_personal_reference": "elegant-2932883",
  "property_category_id": 1,
  "property_type_id": 1,
  "property_price_type_id": 1,
  "property_price": 850000,
  "property_community_id": 831,
  "property_district_id": 28,
  "property_province_id": 2,
  "property_bedroom_id": 5,
  "property_bathroom_id": 5,
  "property_area": 400,
  "property_boosted": false,
  "property_listing_level": "standard",
  "created_at": {
    "$date": "2022-10-10T00:00:00.000Z"
  },
  "day_start": {
    "$date": "2022-10-10T00:00:00.000Z"
  }
}