This seems to be related to MDL-46279.

Recent Moodle upgrade from 4.2 to 4.4 took 1 hour and 40 mins to complete one SCORM upgrade step that has this DB insert: https://github.com/moodle/moodle/blob/ddc7c93a3c237f3d2838676746f42c9639bf9e3e/mod/scorm/db/upgrade.php#L135-L141

The source table mdl_scorm_scoes_track is already dropped https://github.com/moodle/moodle/blob/ddc7c93a3c237f3d2838676746f42c9639bf9e3e/mod/scorm/db/upgrade.php#L143-L149 in both Production and non-Production environments so it would take some time to restore a db backup to get insight on the number of records.

mdl_scorm_element has 7K records and mdl_scorm_scoes_value has 7.6M.