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

Determine landscape of rhsm-prod database record changes

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • None
    • None
    • 5
    • False
    • Hide

      None

      Show
      None
    • True

      Context
      We need to capture statistics on how our database records change over the course of a month to drive implementation details for our dataverse integration.

      Goal
      Determine how many inserts, updates, and deletes occur per table so we can target which tables need special handling.

      Current WIP (linked github)
      Using Floorist to dump query results to S3 buckets nightly. We can then analyze the data (potentially using Claude, Gemini, or other analysis tools).

      Investigation Notes

      • Looked into AWS RDS insights/CloudWatch for this data but didn't find what we needed
      • May be worth investigating AWS metrics again

      Acceptance Criteria

      • Tooling or documentation to answer: "How many inserts/updates/deletes have happened for table X over a month?"
      • Per-table statistics available for analysis

        1. screenshot-1.png
          165 kB
          Lindsey Burnett

              Unassigned Unassigned
              lburnett0 Lindsey Burnett
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: