Twilio Status Override Celery Task: SQL Performance Update

[mchlwellman]

User Story - Business Need

The Twilio status updating Celery job is querying the database for Notifications, and it is taking far too long to return results. See this example below where it took 12 seconds:

This query needs to be revisited to be more performant, possibly by:

• Removing the ordering

• Adding an index on some of the where conditions, sent_at and notification_status

• Ticket is understood, and QA has been contacted (if the ticket has a QA label).

User Story(ies)

As a VANotify developer
I want backend tasks to run as efficiently as possible
So that resources have high availability

Additional Info and Resources

• The SQL query is here

Acceptance Criteria

• The Celery task database query executes in a reasonable amount of time (TBD)
• This work is added to the sprint review slide deck (key win bullet point and demo slide)

QA Considerations

• Should be no functional changes, just performance

Potential Dependencies