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

namespace metadata queries are eating database CPU

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • None
    • Unspecified
    • Backend

    Description

      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 ...

      Attachments

        Issue Links

          blocks

          Bug - A problem that impairs or prevents the functions of the product. AAH-2413 Performance testing: error when getting collection versions for Ansible galaxy - ansible2.13 from beta environment

          • Normal - To be worked after urgent and high priorities are resolved. This term is chosen when the severity of an issue is relatively close to the level of effort to fix it. The existence of an easily implemented workaround can also lead to this priority level instead of a higher priority.
          • Closed
          is blocked by

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. AAH-313 Namespace and Logo Sync

          • Normal - To be worked after urgent and high priorities are resolved. This term is chosen when the severity of an issue is relatively close to the level of effort to fix it. The existence of an easily implemented workaround can also lead to this priority level instead of a higher priority.
          • Backlog

          Task - Represents a small unit of work that is not end-user facing. AAH-2293 Namespace search APIs

          • Undefined - Priority not specified.
          • Code Review

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: