Uploaded image for project: 'Subscription Watch'
  1. Subscription Watch
  2. SWATCH-4497

Run Backfill Endpoint for Org 6340056 and Validate Query Performance for tally_snapshots

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Unresolved
    • Icon: Normal Normal
    • None
    • None
    • swatch-tally
    • None
    • 3
    • False
    • Hide

      None

      Show
      None
    • 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.

              Unassigned Unassigned
              karshah@redhat.com Kartik Shah
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: