Uploaded image for project: 'OCP Technical Release Team'
  1. OCP Technical Release Team
  2. TRT-1419

Investigate ci-data bigquery data usage

XMLWordPrintable

    • Icon: Story Story
    • Resolution: Done
    • Icon: Major Major
    • None
    • None
    • None
    • None
    • False
    • Hide

      None

      Show
      None
    • False
    • None
    • None
    • None
    • None

      We keep tripping the alert. Many of the top queries are something linked to David's account we don't understand.

      the top hitter looks like it might be fixable as well.

      Top query results this morning: https://drive.google.com/file/d/1fe27BSBZCXYGSiAFKPwcPzspsUCJBx8a/view?usp=sharing

      The first one, 400 gb, could that be improved with a date range filter to make better use of partitions?

      Then all the 200gb ones linked to deads@redhat.com, nobody knows what these are including him. Should we just kill the service account and see what breaks?

        1. image-2024-01-24-07-44-40-925.png
          image-2024-01-24-07-44-40-925.png
          78 kB
        2. image-2024-01-22-11-41-46-956.png
          image-2024-01-22-11-41-46-956.png
          130 kB
        3. image-2024-01-12-08-50-16-047.png
          image-2024-01-12-08-50-16-047.png
          102 kB
        4. image-2024-01-10-10-43-26-429.png
          image-2024-01-10-10-43-26-429.png
          104 kB
        5. image-2024-01-09-16-45-13-382.png
          image-2024-01-09-16-45-13-382.png
          95 kB
        6. image-2024-01-09-16-36-52-587.png
          image-2024-01-09-16-36-52-587.png
          20 kB

              rh-ee-fbabcock Forrest Babcock
              rhn-engineering-dgoodwin Devan Goodwin
              None
              None
              None
              None
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: