Uploaded image for project: 'Automation Hub'
  1. Automation Hub
  2. AAH-2346

namespace metadata queries are eating database CPU

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • None
    • Unspecified
    • Backend
    • False
    • Hide

      None

      Show
      None
    • False
    • Approved

      This is what the RDS insights reports as the largest contributor to CPU utilization:

      SELECT "ansible_ansiblenamespacemetadata"."name", "ansible_ansiblenamespacemetadata"."metadata_sha256" FROM "ansible_ansiblenamespacemetadata" WHERE "ansible_ansiblenamespacemetadata"."content_ptr_id" IN (SELECT V0."pulp_id" FROM "core_content" V0 INNER JOIN "core_repositorycontent" V1 ON (V0."pulp_id" = V1."content_id") WHERE V1."pulp_id" IN (SELECT U0."pulp_id" FROM "core_repositorycontent" U0 INNER JOIN "core_repositoryversion" U2 ON (U0."version_added_id" = U2."pulp_id") LEFT OUTER JOIN "cor ...

        1. image-2023-05-11-14-25-55-504.png
          image-2023-05-11-14-25-55-504.png
          228 kB

              dnewswan David Newswanger
              jtanner@redhat.com James Tanner
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: