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

latest report id index makes /nodes queries slow

    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

              jsd-sla-details-panel

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved: