Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-64237

SCORM scorm_scoes_track index on element is massive and unsused

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.5.3, 3.6, 3.7
    • Fix Version/s: 3.7
    • Component/s: SCORM

      Description

      The scorm_scoes_track table has an index on the "element" field that doesn't appear to be used at all - and is quite large in some of our larger sites.

      For example - the query here:
      https://wiki.postgresql.org/wiki/Index_Maintenance#Index_size.2Fusage_statistics

      Returns results like:
      Table size: 4604MB
      Index size: 1705MB
      number_of_scans: 0

      We do have a couple of sites that have less than 10 scans on the index. But the impact of having to maintain this index, the lack of use (and the disk usage) suggests we should be deleting this index.

      The longer-term plan is to address: MDL-46279 but in the short-term I think we should drop this index.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                danmarsden Dan Marsden
                Reporter:
                danmarsden Dan Marsden
                Peer reviewer:
                Sara Arjona (@sarjona)
                Integrator:
                Eloy Lafuente (stronk7)
                Tester:
                Eloy Lafuente (stronk7)
                Participants:
                Component watchers:
                Damyon Wiese, Dan Marsden, Matteo Scaramuccia, Adrian Greeve, Mihail Geshoski, Peter Dias
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  20/May/19