-
Task
-
Resolution: Unresolved
-
Normal
-
None
-
None
-
None
-
3
-
False
-
-
False
-
Impediment
-
subs-swatch-thunder
-
-
- Before executing org in prod it will be great if we can do similar test on stage
- In prod execute the backfill REST API endpoint for org ID 6340056.
- Ensure processing is limited strictly to the specified org.
- Run Gabi queries on the updated data set.
- Perform EXPLAIN ANALYZE to validate query plans and index usage.
- Capture execution results and observations.
AC:
- Backfill REST endpoint runs successfully for org 6340056 only and for tally_snapshots. It can be by org and product_id.
- No unintended data changes outside the target org.
- EXPLAIN ANALYZE is executed on relevant Gabi queries.
- Expected indexes are used with no performance regression.
- Analyze the data changed by executing this end point. Make sure there is no outliers
- Results and findings are documented and reviewed with the team.
- is blocked by
-
SWATCH-4493 Add REST endpoint to backfill is_primary in tally_snapshots
-
- Backlog
-