Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-5133

Loader Subjob Query: Missing index

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 4.10.0, 5.7.0
    • 4.7.2
    • grouperLoader
    • None

    Description

      The 'subjob' query in the Loader/Daemon logs runs SQL with a "parent_job_name=" clause, but we did not have an index on parent_job_name.

      Adding such an index made our grouper-log-listing 1000x faster when looking at subjobs.

      CREATE INDEX ON grouper_loader_log (parent_job_name);

      We also created an index on parent_job_id because it seemed more key'ish, but it's not clear that it'll be used by anything.

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            bert.beelindgren@at.internet2.edu Bert Bee-Lindgren (gatech.edu)
            Chad Redman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: