MarkUsProject / Markus

92%

master: 90%

LAST BUILD ON BRANCH TICKET-586_improve_query_speed

branch: TICKET-586_improve_query_speed

CHANGE BRANCH

x

Reset

• TICKET-586_improve_query_speed
• 7642
• 7674
• 7740
• ISSUE-662_add_extra_marks_python_marker
• ISSUE-7298-add-test-results-api
• ISSUE-7449_offer_suggestions_to_partially_matching_ocr_scans
• ISSUE-7677_display_late_penalty_selection
• ISSUE-7687_remove_criteria_level_naming_conflicts
• ISSUE-7707_add_inactive_students_to_group
• ISSUE-7711_group_assignment_test_result_api_route
• ISSUE-7712_enable_zip_download
• ISSUE-7743_import_group_with_inactive_students
• ISSUE-7755_remove_duplicate_insertion_of_csv_graders
• ISSUE-7795_remove_scanned_exam_template_name_size_limit
• TICKET-574_improve_ta_assignment_load_time
• TICKET-575_improve_git_repo_access
• TICKET-578_remove_instructor_from_course
• TICKET-582_updateRepoPermissions_on_rostery_sync
• TICKET-583_lti_sync_due_date
• TICKET-586_fix_next_button_lag
• TICKET-589_seed_file_assign_ta_by_criteria
• TICKET-598_fix_localization_error
• TICKET-599_decrease_admin_user_page_load_time
• TICKET-604_marks_spreadsheet_api
• TICKET-612
• TICKET-614_add_case_sensitivity_to_group_search
• add-data-testid-to-name-search
• add-erb_lint
• add-last-updated-by
• add-ruby-lsp
• add-scheduled-assessment-visibility
• annotation-category-to-json-tests
• annotations-js-refactor
• annotations-overall-comments-style-updates
• api_collect_submission
• assign-grader-querying
• assign_scans_inactive_students
• assignment-group-use-dialog
• assignment-list-rendering-efficiency
• assignment-summary
• assignment-summary-performance-improvements
• assignment-summary-v2
• assignment-view-students
• autotest-form-updates
• autotest-seed-py-marks-metadata
• autotest-testing
• autotester_pass_tags_comments
• batch-test-runs-table-ui-updates
• bump-rubocop
• cache-apt
• cache-playwright-chromium
• canvas_course_name_with_term_suffix
• ci_parallel
• clean-up-javascript
• clean_tmp_job_mtime
• convert-v8-react-table
• create-group-react-component
• create_tag_fix
• csp-updates
• css-build-webpack
• dashboard-course-box-link
• dashboard-query
• database-gems
• decouple-matching-from-scanning
• dependabot.yml-updates
• dependabot/bundler/action_policy-0.7.3
• dependabot/bundler/action_policy-0.7.5
• dependabot/bundler/action_text-trix-2.1.17
• dependabot/bundler/action_text-trix-2.1.18
• dependabot/bundler/actionpack-7.2.2.1
• dependabot/bundler/actionpack-8.1.2.1
• dependabot/bundler/actionview-8.1.2.1
• dependabot/bundler/activerecord-8.0.2.1
• dependabot/bundler/activerecord-session_store-2.2.0
• dependabot/bundler/activestorage-8.1.2.1
• dependabot/bundler/activesupport-8.1.2.1
• dependabot/bundler/addressable-2.9.0
• dependabot/bundler/autoprefixer-rails-10.4.21.0
• dependabot/bundler/binding_of_caller-2.0.0
• dependabot/bundler/bootsnap-1.18.6
• dependabot/bundler/bootsnap-1.24.0
• dependabot/bundler/brakeman-7.0.0
• dependabot/bundler/brakeman-7.0.2
• dependabot/bundler/brakeman-8.0.4
• dependabot/bundler/bullet-8.0.1
• dependabot/bundler/bullet-8.0.5
• dependabot/bundler/bullet-8.0.8
• dependabot/bundler/bullet-8.1.0
• dependabot/bundler/cgi-0.4.2
• dependabot/bundler/combine_pdf-1.0.29
• dependabot/bundler/combine_pdf-1.0.31
• dependabot/bundler/config-5.6.1
• dependabot/bundler/cssbundling-rails-1.4.3
• dependabot/bundler/csv-3.3.2
• dependabot/bundler/csv-3.3.3
• dependabot/bundler/csv-3.3.4
• dependabot/bundler/csv-3.3.5
• dependabot/bundler/debug-1.10.0
• dependabot/bundler/debug-1.11.0
• dependabot/bundler/dry-validation-1.11.1
• dependabot/bundler/erb-6.0.4
• dependabot/bundler/exception_notification-5.0.1
• dependabot/bundler/factory_bot_rails-6.5.0
• dependabot/bundler/factory_bot_rails-6.5.1
• dependabot/bundler/faker-3.5.3
• dependabot/bundler/faker-3.8.0
• dependabot/bundler/i18n-1.14.7
• dependabot/bundler/i18n-1.14.8
• dependabot/bundler/i18n-tasks-1.0.15
• dependabot/bundler/js-routes-2.3.3
• dependabot/bundler/js-routes-2.3.4
• dependabot/bundler/js-routes-2.3.5
• dependabot/bundler/js-routes-2.3.6
• dependabot/bundler/json-2.10.2
• dependabot/bundler/json-2.12.2
• dependabot/bundler/json-2.13.2
• dependabot/bundler/json-2.16.0
• dependabot/bundler/json-2.18.0
• dependabot/bundler/json-2.18.1
• dependabot/bundler/json-2.19.2
• dependabot/bundler/json-2.9.1
• dependabot/bundler/jwt-2.10.1
• dependabot/bundler/loofah-2.25.1
• dependabot/bundler/marcel-1.1.0
• dependabot/bundler/multi-59e81ae8b4
• dependabot/bundler/net-imap-0.5.7
• dependabot/bundler/net-imap-0.6.4
• dependabot/bundler/nokogiri-1.18.3
• dependabot/bundler/nokogiri-1.18.4
• dependabot/bundler/nokogiri-1.18.8
• dependabot/bundler/nokogiri-1.18.9
• dependabot/bundler/nokogiri-1.19.1
• dependabot/bundler/nokogiri-1.19.3
• dependabot/bundler/pg-1.6.1
• dependabot/bundler/pg-1.6.2
• dependabot/bundler/pg-1.6.3
• dependabot/bundler/pghero-3.8.0
• dependabot/bundler/puma-6.6.0
• dependabot/bundler/puma-6.6.1
• dependabot/bundler/puma-7.1.0
• dependabot/bundler/puma-7.2.0
• dependabot/bundler/rack-3.1.10
• dependabot/bundler/rack-3.1.11
• dependabot/bundler/rack-3.1.12
• dependabot/bundler/rack-3.1.14
• dependabot/bundler/rack-3.1.16
• dependabot/bundler/rack-3.2.2
• dependabot/bundler/rack-3.2.3
• dependabot/bundler/rack-3.2.5
• dependabot/bundler/rack-3.2.6
• dependabot/bundler/rack-cors-3.0.0
• dependabot/bundler/rack-session-2.1.1
• dependabot/bundler/rack-session-2.1.2
• dependabot/bundler/rails-8.0.3
• dependabot/bundler/rails-8.1.2
• dependabot/bundler/rails-i18n-7.0.10
• dependabot/bundler/rails-i18n-8.0.2
• dependabot/bundler/rails_performance-1.4.1
• dependabot/bundler/rails_performance-1.4.2
• dependabot/bundler/rails_performance-1.6.0
• dependabot/bundler/redcarpet-3.6.1
• dependabot/bundler/redis-5.4.0
• dependabot/bundler/redis-5.4.1
• dependabot/bundler/resque-2.7.0
• dependabot/bundler/resque-scheduler-4.11.0
• dependabot/bundler/rmagick-6.1.1
• dependabot/bundler/rmagick-6.1.2
• dependabot/bundler/rmagick-6.1.4
• dependabot/bundler/rmagick-6.2.0
• dependabot/bundler/rspec-rails-7.1.0
• dependabot/bundler/rspec-rails-7.1.1
• dependabot/bundler/rspec-rails-8.0.0
• dependabot/bundler/rspec-rails-8.0.1
• dependabot/bundler/rspec-rails-8.0.2
• dependabot/bundler/rspec-rails-8.0.4
• dependabot/bundler/ruby-lsp-0.26.9
• dependabot/bundler/rubyzip-2.4.1
• dependabot/bundler/rubyzip-3.0.2
• dependabot/bundler/rubyzip-3.2.2
• dependabot/bundler/rugged-1.9.0
• dependabot/bundler/selenium-webdriver-4.28.0
• dependabot/bundler/selenium-webdriver-4.30.1
• dependabot/bundler/selenium-webdriver-4.33.0
• dependabot/bundler/selenium-webdriver-4.34.0
• dependabot/bundler/selenium-webdriver-4.35.0
• dependabot/bundler/shoulda-matchers-6.5.0
• dependabot/bundler/shoulda-matchers-7.0.1
• dependabot/bundler/simplecov-lcov-0.9.0
• dependabot/bundler/sinatra-4.1.0
• dependabot/bundler/sinatra-4.2.0
• dependabot/bundler/sprockets-4.2.2
• dependabot/bundler/terser-1.2.5
• dependabot/bundler/terser-1.2.6
• dependabot/bundler/thor-1.4.0
• dependabot/bundler/webmock-3.25.1
• dependabot/bundler/webmock-3.26.1
• dependabot/npm_and_yarn/ajv-8.18.0
• dependabot/npm_and_yarn/babel-006c0f2cd0
• dependabot/npm_and_yarn/babel-51a97170bd
• dependabot/npm_and_yarn/babel-5d6dcf491f
• dependabot/npm_and_yarn/babel-83e862f966
• dependabot/npm_and_yarn/babel-90202a9766
• dependabot/npm_and_yarn/babel-94fd5226d3
• dependabot/npm_and_yarn/babel-9504461c1d
• dependabot/npm_and_yarn/babel-b74abc64a9
• dependabot/npm_and_yarn/babel-d88eda60e7
• dependabot/npm_and_yarn/babel-e25aef143f
• dependabot/npm_and_yarn/babel-f26d23b75e
• dependabot/npm_and_yarn/babel-jest-30.0.2
• dependabot/npm_and_yarn/babel-jest-30.0.5
• dependabot/npm_and_yarn/babel/plugin-transform-modules-systemjs-7.29.4
• dependabot/npm_and_yarn/chart.js-4.4.8
• dependabot/npm_and_yarn/chart.js-4.4.9
• dependabot/npm_and_yarn/chart.js-4.5.0
• dependabot/npm_and_yarn/core-js-3.40.0
• dependabot/npm_and_yarn/core-js-3.41.0
• dependabot/npm_and_yarn/core-js-3.42.0
• dependabot/npm_and_yarn/core-js-3.43.0
• dependabot/npm_and_yarn/dompurify-3.2.3
• dependabot/npm_and_yarn/dompurify-3.2.4
• dependabot/npm_and_yarn/dompurify-3.2.6
• dependabot/npm_and_yarn/dompurify-3.3.1
• dependabot/npm_and_yarn/dompurify-3.3.2
• dependabot/npm_and_yarn/dompurify-3.4.0
• dependabot/npm_and_yarn/fast-uri-3.1.2
• dependabot/npm_and_yarn/fortawesome-5f4d1e9add
• dependabot/npm_and_yarn/fortawesome-bd9870f41a
• dependabot/npm_and_yarn/i18n-js-4.5.1
• dependabot/npm_and_yarn/immutable-5.1.5
• dependabot/npm_and_yarn/jest-30.0.3
• dependabot/npm_and_yarn/jest-30.0.5
• dependabot/npm_and_yarn/jest-environment-jsdom-30.0.2
• dependabot/npm_and_yarn/js-yaml-3.14.2
• dependabot/npm_and_yarn/lodash-4.17.23
• dependabot/npm_and_yarn/lodash-4.18.1
• dependabot/npm_and_yarn/lodash-es-4.17.23
• dependabot/npm_and_yarn/lodash-es-4.18.1
• dependabot/npm_and_yarn/marked-15.0.12
• dependabot/npm_and_yarn/marked-15.0.6
• dependabot/npm_and_yarn/marked-15.0.7
• dependabot/npm_and_yarn/marked-16.0.0
• dependabot/npm_and_yarn/mime-4.0.6
• dependabot/npm_and_yarn/mime-4.0.7
• dependabot/npm_and_yarn/multi-0d13b2d87f
• dependabot/npm_and_yarn/multi-770cfcd984
• dependabot/npm_and_yarn/multi-bf05dc1ecf
• dependabot/npm_and_yarn/nanoid-3.3.8
• dependabot/npm_and_yarn/pdfjs-dist-4.10.38
• dependabot/npm_and_yarn/pdfjs-dist-5.3.31
• dependabot/npm_and_yarn/pdfjs-dist-5.4.149
• dependabot/npm_and_yarn/pdfjs-dist-5.4.296
• dependabot/npm_and_yarn/pdfjs-dist-5.4.449
• dependabot/npm_and_yarn/pdfjs-dist-5.4.624
• dependabot/npm_and_yarn/pdfjs-dist-5.6.205
• dependabot/npm_and_yarn/prismjs-1.30.0
• dependabot/npm_and_yarn/rails-03aecd2357
• dependabot/npm_and_yarn/rails-176e0686ff
• dependabot/npm_and_yarn/rails-261bb587fc
• dependabot/npm_and_yarn/rails-35bce351a2
• dependabot/npm_and_yarn/rails-5af6849718
• dependabot/npm_and_yarn/rails-bf8a19ee32
• dependabot/npm_and_yarn/react-flatpickr-4.0.0
• dependabot/npm_and_yarn/react-flatpickr-4.0.10
• dependabot/npm_and_yarn/rjsf-08241e480f
• dependabot/npm_and_yarn/rjsf-202d0d6297
• dependabot/npm_and_yarn/rjsf-7ad2f758b5
• dependabot/npm_and_yarn/rjsf-7ed21e9566
• dependabot/npm_and_yarn/rjsf-9272efa66e
• dependabot/npm_and_yarn/rjsf-b312aebfc4
• dependabot/npm_and_yarn/rjsf-d7481262e0
• dependabot/npm_and_yarn/rjsf-df087e2f41
• dependabot/npm_and_yarn/sass-1.83.4
• dependabot/npm_and_yarn/sass-1.85.1
• dependabot/npm_and_yarn/sass-1.87.0
• dependabot/npm_and_yarn/sass-1.89.1
• dependabot/npm_and_yarn/sass-1.89.2
• dependabot/npm_and_yarn/sass-loader-16.0.4
• dependabot/npm_and_yarn/sass-loader-16.0.5
• dependabot/npm_and_yarn/testing-library/react-16.3.0
• dependabot/npm_and_yarn/testing-library/user-event-14.6.1
• dependabot/npm_and_yarn/webpack-5.101.0
• dependabot/npm_and_yarn/webpack-5.105.0
• dependabot/npm_and_yarn/webpack-5.97.1
• dependabot/npm_and_yarn/webpack-5.99.9
• dependabot/npm_and_yarn/webpack-cli-6.0.1
• dependabot/pip/mistune-3.1.1
• dependabot/pip/mistune-3.1.2
• dependabot/pip/mistune-3.1.3
• dependabot/pip/nbconvert-7.16.6
• dependabot/pip/nbconvert-7.17.0
• dependabot/pip/nbconvert-7.17.1
• dependabot/pip/playwright-1.49.1
• dependabot/pip/playwright-1.50.0
• dependabot/pip/playwright-1.51.0
• dependabot/pip/playwright-1.52.0
• dependabot/pip/playwright-1.53.0
• dependabot/pip/playwright-1.54.0
• dependabot/pip/playwright-1.55.0
• dependabot/pip/playwright-1.56.0
• dependabot/pip/playwright-1.57.0
• dependabot/pip/playwright-1.58.0
• dependabot/pip/playwright-1.59.0
• dependabot/pip/zxing-cpp-2.3.0
• do_not_sync_inactive_student_grades_with_lms
• docker-dependency-update-service
• docker-updates
• edit-simplecov-coverage
• enable_remove_student
• extra-mark-percentage-of-score
• file_viewer_optional_render_microsoft_files
• fix-api-submission-files-binary
• fix-assignment-summary-group-filter
• fix-changelog-7869
• fix-content-shift
• fix-flaky-test
• fix-foreign-key-violation-deleting-sections
• fix-n+1-SQL-query
• fix-rack-deprecation-warnings
• fix-remote-auth-login-button-spacing
• fix-test-result-table-extra-info-display
• fix-url-viewer-rendering
• fix/missing-null-and-presence-checks
• fix/rubric-criterion-denominator
• fix_branch_part_2
• fix_filter_test_student_when_roster_sync
• fix_original_total_mark
• fix_postgres_client_mismatch
• frontend-assignment-visibility-ui
• get_orphaned_users
• git-hooks-tests-fix
• github-actions-permissions-block
• github-actions-updates
• grade_entry_student_test_fix
• graders-controller-testcvrg
• graders-controller-tests
• graders-name-search
• group-course-by-semester
• group-name-generation
• hide_total_marks_from_graders
• host_authorization_config
• html-rendering-security-hardening
• i18n-precommit
• icons-for-edit-delete
• image-viewer-fixes
• image_annotations_from_test_runs
• implement-late-penalties
• improve-assignment-settings-form
• improve-split-pdf-job-efficiency
• improve-table-no-data-ui
• improve_assignment_settings_form
• improve_pull_request_template
• improvement_to_pull_request_template
• increase-test-coverage-criteria-controller
• issue-7220
• issue-7225
• issue-7785
• issue-7793
• issue-7822
• js-autotest-example
• katex
• keybind-loading
• maintain_font_size_grading_view
• markdown-html-preview
• marks-graders-controller-tests
• marks_graders_controller_randomly_assign_tests
• markus-exam-matcher-v0.4.0
• master
• mateo/fix_dependency_issue
• migrate-course-summary-table
• modernize-i18n-usage
• new-edit-update-rspec-tests
• npm-upkeep
• overall-comments-api
• patch-1
• pdfjs-v5
• pin-mistune-lt-3.1
• pre-commit-ci-update-config
• precommmit_changes_update
• prevent_grade_change_from_scroll_arrowkey
• prune_orphaned_end_users
• py-test-seed-files-add-custom-markers-example
• python_autotester_requirements_file
• qr_scanning_refactor
• quercus_cannot_create_course
• quercus_launch_markus_button
• quercus_roster_sync_student_number
• r-tester-file-metadata
• rails-v7.2.2.1
• rails-v8.0.2.1
• react-dropdownmenu
• react-jsonschema-form-v6.5.2
• react-table-v8-assignment-summary
• react-table-v8-migrate
• react-v18
• refactor-context-menu
• refactor-criterion-subclasses
• refactor-enzyme-to-rtl
• refactor-file-viewer
• refactor-grade-form
• refactor-markspanel-components
• refresh-autotest-schema
• release
• release-process
• release_2.10.0
• release_2.7.0
• release_2.8.0
• release_2.9.0
• remove-active-state-jQuery
• remove-activerecord-session_store
• remove-application.js
• remove-mistune
• remove-zip-previews
• rename-group-dialog
• renaming-jupyter-notebook-functions
• replace-moment-with-dayjs
• resque_host_authorization
• result-context-refactor
• result-generate-print-pdf-refactor
• roster_sync_inactive_students
• rubocop-fixes
• rubocop-rails-v2.33.4
• scss-replace-import-with-use
• section-starter-file-groups-fix
• seed-autotest-script-updates
• set-last-updated-by
• setup_env_notice_flash_style_update
• solution-table-master
• split-test-run-table
• store-start-and-end-date
• ta-memberships-query-refactor
• table-column-refactoring
• table-efficiency
• table-loading
• tag_uniqueness_constraint
• test-message-refactor
• test/global-actions
• test/sign-in-helper
• test_new_and_create_freya
• test_results_group_by_test_id
• timeout-error-display
• toggle-download-test-button
• touch-events-pdf-image-annotations
• unify-arrows-to-chevrons
• update-assignment-status-column
• update-assignment-summary-page
• update-compose.yaml
• update-contributors
• update-deps
• update-gems
• update-react-loader-spinner-v8
• update-seed-autotest-schema-python-versions
• update_changelog
• update_remote_autotest_settings_id_validation
• update_user_info_roster_sync
• upgrade-grade-breakdown-summary-table-v8
• upgrade-student-table
• upload-scanned-test-refactoring
• users-table-refactor
• v2.7.1
• v2.8.1
• v2.8.2
• v2.9.1
• v2.9.2
• v2.9.3
• v2.9.3-changelog
• v2.9.5
• v2.9.6
• webpack-improvements
• zip

Build # 22861915537

Build Type

Pull #7851

github

Committed by web-flow

Commit Message

Merge 03d8e09b0 into 0b84edd29

Pull Request Pull Request #7851: TICKET-586: Add index on results - submission_id column

Coverage Stats

941 of 1840 branches covered (51.14%)

Branch coverage included in aggregate %.

45020 of 48298 relevant lines covered (93.21%)

129.33 hits per line