Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-2789

latest report id index makes /nodes queries slow

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: PDB 4.1.2
    • Component/s: None
    • Labels:
    • Template:

      Description

      An index added to the certnames table as part of some optimization for latest_report? with legacy events queries ended up making some queries the console makes against /nodes slow.

      without index: https://explain.depesz.com/s/Jbu8
      with index: https://explain.depesz.com/s/BQ1a

      This index should be removed.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              wyatt Wyatt Alt
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Zendesk Support