Hey, is anyone able to look at these database (9ba874c7-30f8-436c-a357-2b674e0a2e79) metrics please?

Hey, is anyone able to look at these database (9ba874c7-30f8-436c-a357-2b674e0a2e79) metrics please?
Apparently I've gone through 2.16B Rows read this month on a database with a total of about ~20k rows.
I've checked the insights and this is the main culprit, but running this command returns about 6k rows (total of ~12k reads as the join is pretty much a 1 to 1).

npx wrangler d1 insights DB --env="preview" --timePeriod="7d" --sort-by="reads" --json

{
    "query": "select \"entry\".\"uuid\", \"entry\".\"type\", \"entry\".\"description\", \"entry\".\"userId\", \"entry\".\"createdOn\", \"entry\".\"updatedOn\", \"engineeringEntry\".\"planType\", \"engineeringEntry\".\"location\", \"engineeringEntry\".\"suburb\", \"engineeringEntry\".\"planStatus\", \"engineeringEntry\".\"designer\", \"engineeringEntry\".\"date\", \"engineeringEntry\".\"subdNumber\", \"engineeringEntry\".\"planRegister\" from \"entry\" left join \"engineeringEntry\" on \"entry\".\"uuid\" = \"engineeringEntry\".\"entryUuid\" where \"entry\".\"type\" = ?",
    "avgRowsRead": 37357286,
    "totalRowsRead": 2316151764,
    "avgRowsWritten": 0,
    "totalRowsWritten": 0,
    "avgDurationMs": 4197.161798387097,
    "totalDurationMs": 260224.0315,
    "numberOfTimesRun": 62,
    "queryEfficiency": 0.00016227088873640338
  }

npx wrangler d1 execute DB --command="select count(*) from entry" --env="preview"
┌──────────┐
│ count(*) │
├──────────┤
│ 6266     │
└──────────┘

npx wrangler d1 execute DB --command="select count(*) from engineeringEntry" --env="preview"
┌──────────┐
│ count(*) │
├──────────┤
│ 6265     │
└──────────┘

Thanks
Was this page helpful?