bug: GetWorkspaceAppStatusesByAppIDs and GetLatestWorkspaceAppStatusByAppID use sequential scans #1175
Description
During a scale test of task status updates, the database goes to 100% CPU and things break
The two queries in the title are the most expensive:
They cause sequential scans because we don't have an index on (app_id, created_at).