[BUG] Daily data page times out for some receivers in production

[victor-chaparro]

User Story

As a ReportStream receiver,
I want to be able to see my reports through the daily data page,
so that I know what reports I should be receiving.

Description/Use Case

Some ReportStream receivers are unable to view their reports through the daily date page. Massachusetts has reported that they're unable to view their reports and have opened a support ticket. The API times out after 30 seconds and an error is presented to the receiver saying data could not be loaded.

Risks/Impacts/Considerations

• Receivers are unable to view their reports

Dev Notes

Steps to reproduce:

1. Login to ReportStream in production (This is not reproduce able in staging)
2. Set ma-phd as your organization
3. Navigate to daily data

Link to transaction failure

By looking at the transaction details it looks like the count query is run twice and takes up to 4 minutes to complete. The query to retrieve the results takes around 2 minutes to complete. The API times out after 30 seconds.

Slack Thread with Proposed changes
It looks like the piece that makes the query run long is the join with the action table. The only reason it joins with the action table is to find the batch step. It may be possible to get the batch step by looking if the next_action is the send step in the report_file table and avoid the join with the action table, but there are other considerations that need to be taken into account if doing that. All that can be found in the slack thread.

Another solution may be to just start logging the current_action in the report_file file table, but all previous entries would need to be updated.

Acceptance Criteria

• Daily data does not time out for receivers

[arnejduranovic]

The recommended solution in the ticket may also fix this issue, please double check: #15644