explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ghx2

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 0.118 ↑ 23.5 4 1

Nested Loop (cost=343.00..105,099.74 rows=94 width=842) (actual time=0.042..0.118 rows=4 loops=1)

  • Output: item.crsmain_pk1, grade.gradebook_main_pk1, item.grading_term_pk1, grade.course_users_pk1, attempt.pk1, attempt.group_attempt_pk1, attempt.override_ind, grade.status, attempt.status, attempt.score, attempt.grade, (CASE WHEN (grade.last_attempt_date IS NOT NULL) THEN grade.last_attempt_date WHEN (attempt.attempt_date IS NOT NULL) THEN attempt.attempt_date ELSE NULL::timestamp without time zone END), (CASE WHEN (attempt.last_graded_date IS NOT NULL) THEN attempt.last_graded_date WHEN (attempt.first_graded_date IS NOT NULL) THEN attempt.first_graded_date WHEN (attempt.date_modified IS NOT NULL) THEN attempt.date_modified ELSE attempt.attempt_date END), grade.last_override_date, grade.manual_score, grade.pending_manual_score, grade.manual_grade, grade.pending_manual_grade, grade.version, grade.comments, grade.notes_format_type, attempt.comment_public_ind, attempt.instructor_comments, attempt.feedback_format_type, attempt.instructor_notes, attempt.notes_format_type, grade.for_student_comments, grade.feedback_format_type, grade.exempt_ind, grade.excluded_ind, grade.exempt_attempt_ind, (CASE WHEN (grade.first_attempt_pk1 IS NULL) THEN '0'::text WHEN (grade.first_attempt_pk1 = grade.last_attempt_pk1) THEN '1'::text ELSE 'M'::text END), attempt.graded_anonymously_ind, attempt.show_staged_feedback, attempt.ready_to_post_ind, grade.perf_code_pk1, grade.automatic_zero, grade.pk1, CASE WHEN ((COALESCE(gm.delegated_grading_ind, 'N'::bpchar) = 'N'::bpchar) OR (SubPlan 1)) THEN 'Y'::text ELSE 'N'::text END, gm.anonymous_grading_ind
  • Buffers: shared hit=139
2. 0.001 0.105 ↑ 23.5 4 1

Append (cost=258.00..73,278.86 rows=94 width=808) (actual time=0.035..0.105 rows=4 loops=1)

  • Buffers: shared hit=123
3. 0.013 0.061 ↑ 22.5 4 1

Nested Loop Left Join (cost=258.00..21,414.52 rows=90 width=990) (actual time=0.035..0.061 rows=4 loops=1)

  • Output: grade.pk1, item.crsmain_pk1, grade.gradebook_main_pk1, item.grading_term_pk1, grade.course_users_pk1, grade.comments, grade.notes_format_type, grade.for_student_comments, grade.feedback_format_type, grade.status, attempt.status, attempt.score, attempt.grade, CASE WHEN (grade.last_attempt_date IS NOT NULL) THEN grade.last_attempt_date WHEN (attempt.attempt_date IS NOT NULL) THEN attempt.attempt_date ELSE NULL::timestamp without time zone END, CASE WHEN (attempt.last_graded_date IS NOT NULL) THEN attempt.last_graded_date WHEN (attempt.first_graded_date IS NOT NULL) THEN attempt.first_graded_date WHEN (attempt.date_modified IS NOT NULL) THEN attempt.date_modified ELSE attempt.attempt_date END, attempt.comment_public_ind, attempt.instructor_comments, attempt.feedback_format_type, attempt.instructor_notes, attempt.notes_format_type, attempt.pk1, attempt.group_attempt_pk1, attempt.override_ind, grade.manual_score, grade.manual_grade, grade.pending_manual_score, grade.pending_manual_grade, grade.perf_code_pk1, grade.last_override_date, grade.version, grade.exempt_ind, grade.excluded_ind, grade.exempt_attempt_ind, CASE WHEN (grade.first_attempt_pk1 IS NULL) THEN '0'::text WHEN (grade.first_attempt_pk1 = grade.last_attempt_pk1) THEN '1'::text ELSE 'M'::text END, attempt.graded_anonymously_ind, attempt.show_staged_feedback, attempt.ready_to_post_ind, grade.automatic_zero
  • Buffers: shared hit=31
4. 0.004 0.040 ↑ 22.5 4 1

Nested Loop (cost=171.50..12,729.07 rows=90 width=480) (actual time=0.028..0.040 rows=4 loops=1)

  • Output: grade.pk1, grade.gradebook_main_pk1, grade.course_users_pk1, grade.comments, grade.notes_format_type, grade.for_student_comments, grade.feedback_format_type, grade.status, grade.last_attempt_date, grade.manual_score, grade.manual_grade, grade.pending_manual_score, grade.pending_manual_grade, grade.perf_code_pk1, grade.last_override_date, grade.version, grade.exempt_ind, grade.excluded_ind, grade.exempt_attempt_ind, grade.first_attempt_pk1, grade.last_attempt_pk1, grade.automatic_zero, grade.last_graded_attempt_pk1, item.crsmain_pk1, item.grading_term_pk1
  • Buffers: shared hit=23
5. 0.016 0.016 ↑ 32.5 4 1

Index Scan using gradebook_grade_if1 on public.gradebook_grade grade (cost=86.50..313.42 rows=130 width=464) (actual time=0.013..0.016 rows=4 loops=1)

  • Output: grade.pk1, grade.gradebook_main_pk1, grade.course_users_pk1, grade.batch_uid, grade.comments, grade.notes_format_type, grade.for_student_comments, grade.feedback_format_type, grade.date_added, grade.date_modified, grade.last_override_date, grade.last_attempt_date, grade.status, grade.highest_attempt_pk1, grade.up_highest_attempt_pk1, grade.lowest_attempt_pk1, grade.up_lowest_attempt_pk1, grade.last_attempt_pk1, grade.first_attempt_pk1, grade.last_graded_attempt_pk1, grade.up_last_graded_attempt_pk1, grade.first_graded_attempt_pk1, grade.up_first_graded_attempt_pk1, grade.exempt_attempt_ind, grade.average_score, grade.up_average_score, grade.manual_grade, grade.manual_score, grade.version, grade.exempt_ind, grade.excluded_ind, grade.pending_manual_grade, grade.pending_manual_score, grade.perf_code_pk1, grade.automatic_zero
  • Index Cond: (grade.course_users_pk1 = '1727337'::bigint)
  • Buffers: shared hit=7
6. 0.020 0.020 ↑ 1.0 1 4

Index Scan using gradebook_main_pk on public.gradebook_main item (cost=85.00..95.00 rows=1 width=24) (actual time=0.005..0.005 rows=1 loops=4)

  • Output: item.pk1, item."position", item.gradebook_translator_pk1, item.secondary_translator_pk1, item.grading_term_pk1, item.qti_asi_data_pk1, item.crsmain_pk1, item.batch_uid, item.course_contents_pk1, item.linkrefid, item.title, item.display_title, item.gradebook_type_pk1, item.description, item.description_type, item.due_date, item.possible, item.visible_ind, item.visible_in_book_ind, item.visible_in_all_terms_ind, item.stat_visible_to_stu_ind, item.hide_attempt_ind, item.weight, item.date_added, item.date_modified, item.aggregation_model, item.calculated_ind, item.scorable_ind, item.user_created_ind, item.single_attempt_ind, item.ext_asmt_analysis_url, item.ext_atmpt_handler_url, item.score_provider_handle, item.ignore_unscored_ind, item.limited_attendance_ind, item.version, item.deleted_ind, item.multiple_attempts, item.tool_computed_points, item.grading_decimal_places, item.delegated_grading_ind, item.anonymous_grading_ind, item.anon_grading_release_date, item.anon_grading_rel_crit, item.lti_domain_pk1, item.lti_tag, item.lti_res_id, item.peer_grading_ind, item.peer_reviews_per_student, item.peer_allow_late_reviews_ind
  • Index Cond: (item.pk1 = grade.gradebook_main_pk1)
  • Filter: ((item.aggregation_model = 1) AND (item.deleted_ind = 'N'::bpchar))
  • Buffers: shared hit=16
7. 0.008 0.008 ↓ 0.0 0 4

Index Scan using attempt_pk on public.attempt (cost=86.50..95.50 rows=1 width=526) (actual time=0.002..0.002 rows=0 loops=4)

  • Output: attempt.gradebook_grade_pk1, attempt.pk1, attempt.qti_result_data_pk1, attempt.linkrefid, attempt.score, attempt.grade, attempt.student_comments, attempt.instructor_comments, attempt.feedback_format_type, attempt.comment_public_ind, attempt.exempt_ind, attempt.override_ind, attempt.instructor_notes, attempt.notes_format_type, attempt.status, attempt.attempt_date, attempt.first_graded_date, attempt.last_graded_date, attempt.date_added, attempt.date_modified, attempt.latest_ind, attempt.group_attempt_pk1, attempt.student_submission, attempt.text_format_type, attempt.graded_anonymously_ind, attempt.reconciliation_mode, attempt.show_staged_feedback, attempt.expected_end_date, attempt.ready_to_post_ind, attempt.nested_file_ind
  • Index Cond: (attempt.pk1 = grade.last_graded_attempt_pk1)
  • Buffers: shared hit=8
8. 0.000 0.012 ↓ 0.0 0 1

Nested Loop Left Join (cost=258.00..12,825.58 rows=1 width=990) (actual time=0.012..0.012 rows=0 loops=1)

  • Output: grade_1.pk1, item_1.crsmain_pk1, grade_1.gradebook_main_pk1, item_1.grading_term_pk1, grade_1.course_users_pk1, grade_1.comments, grade_1.notes_format_type, grade_1.for_student_comments, grade_1.feedback_format_type, grade_1.status, attempt_1.status, attempt_1.score, attempt_1.grade, CASE WHEN (grade_1.last_attempt_date IS NOT NULL) THEN grade_1.last_attempt_date WHEN (attempt_1.attempt_date IS NOT NULL) THEN attempt_1.attempt_date ELSE NULL::timestamp without time zone END, CASE WHEN (attempt_1.last_graded_date IS NOT NULL) THEN attempt_1.last_graded_date WHEN (attempt_1.first_graded_date IS NOT NULL) THEN attempt_1.first_graded_date WHEN (attempt_1.date_modified IS NOT NULL) THEN attempt_1.date_modified ELSE attempt_1.attempt_date END, attempt_1.comment_public_ind, attempt_1.instructor_comments, attempt_1.feedback_format_type, attempt_1.instructor_notes, attempt_1.notes_format_type, attempt_1.pk1, attempt_1.group_attempt_pk1, attempt_1.override_ind, grade_1.manual_score, grade_1.manual_grade, grade_1.pending_manual_score, grade_1.pending_manual_grade, grade_1.perf_code_pk1, grade_1.last_override_date, grade_1.version, grade_1.exempt_ind, grade_1.excluded_ind, grade_1.exempt_attempt_ind, CASE WHEN (grade_1.first_attempt_pk1 IS NULL) THEN '0'::text WHEN (grade_1.first_attempt_pk1 = grade_1.last_attempt_pk1) THEN '1'::text ELSE 'M'::text END, attempt_1.graded_anonymously_ind, attempt_1.show_staged_feedback, attempt_1.ready_to_post_ind, grade_1.automatic_zero
  • Buffers: shared hit=23
9. 0.001 0.012 ↓ 0.0 0 1

Nested Loop (cost=171.50..12,729.07 rows=1 width=480) (actual time=0.012..0.012 rows=0 loops=1)

  • Output: grade_1.pk1, grade_1.gradebook_main_pk1, grade_1.course_users_pk1, grade_1.comments, grade_1.notes_format_type, grade_1.for_student_comments, grade_1.feedback_format_type, grade_1.status, grade_1.last_attempt_date, grade_1.manual_score, grade_1.manual_grade, grade_1.pending_manual_score, grade_1.pending_manual_grade, grade_1.perf_code_pk1, grade_1.last_override_date, grade_1.version, grade_1.exempt_ind, grade_1.excluded_ind, grade_1.exempt_attempt_ind, grade_1.first_attempt_pk1, grade_1.last_attempt_pk1, grade_1.automatic_zero, grade_1.highest_attempt_pk1, item_1.crsmain_pk1, item_1.grading_term_pk1
  • Buffers: shared hit=23
10. 0.003 0.003 ↑ 32.5 4 1

Index Scan using gradebook_grade_if1 on public.gradebook_grade grade_1 (cost=86.50..313.42 rows=130 width=464) (actual time=0.002..0.003 rows=4 loops=1)

  • Output: grade_1.pk1, grade_1.gradebook_main_pk1, grade_1.course_users_pk1, grade_1.batch_uid, grade_1.comments, grade_1.notes_format_type, grade_1.for_student_comments, grade_1.feedback_format_type, grade_1.date_added, grade_1.date_modified, grade_1.last_override_date, grade_1.last_attempt_date, grade_1.status, grade_1.highest_attempt_pk1, grade_1.up_highest_attempt_pk1, grade_1.lowest_attempt_pk1, grade_1.up_lowest_attempt_pk1, grade_1.last_attempt_pk1, grade_1.first_attempt_pk1, grade_1.last_graded_attempt_pk1, grade_1.up_last_graded_attempt_pk1, grade_1.first_graded_attempt_pk1, grade_1.up_first_graded_attempt_pk1, grade_1.exempt_attempt_ind, grade_1.average_score, grade_1.up_average_score, grade_1.manual_grade, grade_1.manual_score, grade_1.version, grade_1.exempt_ind, grade_1.excluded_ind, grade_1.pending_manual_grade, grade_1.pending_manual_score, grade_1.perf_code_pk1, grade_1.automatic_zero
  • Index Cond: (grade_1.course_users_pk1 = '1727337'::bigint)
  • Buffers: shared hit=7
11. 0.008 0.008 ↓ 0.0 0 4

Index Scan using gradebook_main_pk on public.gradebook_main item_1 (cost=85.00..95.00 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=4)

  • Output: item_1.pk1, item_1."position", item_1.gradebook_translator_pk1, item_1.secondary_translator_pk1, item_1.grading_term_pk1, item_1.qti_asi_data_pk1, item_1.crsmain_pk1, item_1.batch_uid, item_1.course_contents_pk1, item_1.linkrefid, item_1.title, item_1.display_title, item_1.gradebook_type_pk1, item_1.description, item_1.description_type, item_1.due_date, item_1.possible, item_1.visible_ind, item_1.visible_in_book_ind, item_1.visible_in_all_terms_ind, item_1.stat_visible_to_stu_ind, item_1.hide_attempt_ind, item_1.weight, item_1.date_added, item_1.date_modified, item_1.aggregation_model, item_1.calculated_ind, item_1.scorable_ind, item_1.user_created_ind, item_1.single_attempt_ind, item_1.ext_asmt_analysis_url, item_1.ext_atmpt_handler_url, item_1.score_provider_handle, item_1.ignore_unscored_ind, item_1.limited_attendance_ind, item_1.version, item_1.deleted_ind, item_1.multiple_attempts, item_1.tool_computed_points, item_1.grading_decimal_places, item_1.delegated_grading_ind, item_1.anonymous_grading_ind, item_1.anon_grading_release_date, item_1.anon_grading_rel_crit, item_1.lti_domain_pk1, item_1.lti_tag, item_1.lti_res_id, item_1.peer_grading_ind, item_1.peer_reviews_per_student, item_1.peer_allow_late_reviews_ind
  • Index Cond: (item_1.pk1 = grade_1.gradebook_main_pk1)
  • Filter: ((item_1.aggregation_model = 2) AND (item_1.deleted_ind = 'N'::bpchar))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=16
12. 0.000 0.000 ↓ 0.0 0

Index Scan using attempt_pk on public.attempt attempt_1 (cost=86.50..95.50 rows=1 width=526) (never executed)

  • Output: attempt_1.gradebook_grade_pk1, attempt_1.pk1, attempt_1.qti_result_data_pk1, attempt_1.linkrefid, attempt_1.score, attempt_1.grade, attempt_1.student_comments, attempt_1.instructor_comments, attempt_1.feedback_format_type, attempt_1.comment_public_ind, attempt_1.exempt_ind, attempt_1.override_ind, attempt_1.instructor_notes, attempt_1.notes_format_type, attempt_1.status, attempt_1.attempt_date, attempt_1.first_graded_date, attempt_1.last_graded_date, attempt_1.date_added, attempt_1.date_modified, attempt_1.latest_ind, attempt_1.group_attempt_pk1, attempt_1.student_submission, attempt_1.text_format_type, attempt_1.graded_anonymously_ind, attempt_1.reconciliation_mode, attempt_1.show_staged_feedback, attempt_1.expected_end_date, attempt_1.ready_to_post_ind, attempt_1.nested_file_ind
  • Index Cond: (attempt_1.pk1 = grade_1.highest_attempt_pk1)
13. 0.000 0.010 ↓ 0.0 0 1

Nested Loop Left Join (cost=258.00..12,825.58 rows=1 width=990) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: grade_2.pk1, item_2.crsmain_pk1, grade_2.gradebook_main_pk1, item_2.grading_term_pk1, grade_2.course_users_pk1, grade_2.comments, grade_2.notes_format_type, grade_2.for_student_comments, grade_2.feedback_format_type, grade_2.status, attempt_2.status, attempt_2.score, attempt_2.grade, CASE WHEN (grade_2.last_attempt_date IS NOT NULL) THEN grade_2.last_attempt_date WHEN (attempt_2.attempt_date IS NOT NULL) THEN attempt_2.attempt_date ELSE NULL::timestamp without time zone END, CASE WHEN (attempt_2.last_graded_date IS NOT NULL) THEN attempt_2.last_graded_date WHEN (attempt_2.first_graded_date IS NOT NULL) THEN attempt_2.first_graded_date WHEN (attempt_2.date_modified IS NOT NULL) THEN attempt_2.date_modified ELSE attempt_2.attempt_date END, attempt_2.comment_public_ind, attempt_2.instructor_comments, attempt_2.feedback_format_type, attempt_2.instructor_notes, attempt_2.notes_format_type, attempt_2.pk1, attempt_2.group_attempt_pk1, attempt_2.override_ind, grade_2.manual_score, grade_2.manual_grade, grade_2.pending_manual_score, grade_2.pending_manual_grade, grade_2.perf_code_pk1, grade_2.last_override_date, grade_2.version, grade_2.exempt_ind, grade_2.excluded_ind, grade_2.exempt_attempt_ind, CASE WHEN (grade_2.first_attempt_pk1 IS NULL) THEN '0'::text WHEN (grade_2.first_attempt_pk1 = grade_2.last_attempt_pk1) THEN '1'::text ELSE 'M'::text END, attempt_2.graded_anonymously_ind, attempt_2.show_staged_feedback, attempt_2.ready_to_post_ind, grade_2.automatic_zero
  • Buffers: shared hit=23
14. 0.000 0.010 ↓ 0.0 0 1

Nested Loop (cost=171.50..12,729.07 rows=1 width=480) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: grade_2.pk1, grade_2.gradebook_main_pk1, grade_2.course_users_pk1, grade_2.comments, grade_2.notes_format_type, grade_2.for_student_comments, grade_2.feedback_format_type, grade_2.status, grade_2.last_attempt_date, grade_2.manual_score, grade_2.manual_grade, grade_2.pending_manual_score, grade_2.pending_manual_grade, grade_2.perf_code_pk1, grade_2.last_override_date, grade_2.version, grade_2.exempt_ind, grade_2.excluded_ind, grade_2.exempt_attempt_ind, grade_2.first_attempt_pk1, grade_2.last_attempt_pk1, grade_2.automatic_zero, grade_2.lowest_attempt_pk1, item_2.crsmain_pk1, item_2.grading_term_pk1
  • Buffers: shared hit=23
15. 0.002 0.002 ↑ 32.5 4 1

Index Scan using gradebook_grade_if1 on public.gradebook_grade grade_2 (cost=86.50..313.42 rows=130 width=464) (actual time=0.001..0.002 rows=4 loops=1)

  • Output: grade_2.pk1, grade_2.gradebook_main_pk1, grade_2.course_users_pk1, grade_2.batch_uid, grade_2.comments, grade_2.notes_format_type, grade_2.for_student_comments, grade_2.feedback_format_type, grade_2.date_added, grade_2.date_modified, grade_2.last_override_date, grade_2.last_attempt_date, grade_2.status, grade_2.highest_attempt_pk1, grade_2.up_highest_attempt_pk1, grade_2.lowest_attempt_pk1, grade_2.up_lowest_attempt_pk1, grade_2.last_attempt_pk1, grade_2.first_attempt_pk1, grade_2.last_graded_attempt_pk1, grade_2.up_last_graded_attempt_pk1, grade_2.first_graded_attempt_pk1, grade_2.up_first_graded_attempt_pk1, grade_2.exempt_attempt_ind, grade_2.average_score, grade_2.up_average_score, grade_2.manual_grade, grade_2.manual_score, grade_2.version, grade_2.exempt_ind, grade_2.excluded_ind, grade_2.pending_manual_grade, grade_2.pending_manual_score, grade_2.perf_code_pk1, grade_2.automatic_zero
  • Index Cond: (grade_2.course_users_pk1 = '1727337'::bigint)
  • Buffers: shared hit=7
16. 0.008 0.008 ↓ 0.0 0 4

Index Scan using gradebook_main_pk on public.gradebook_main item_2 (cost=85.00..95.00 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=4)

  • Output: item_2.pk1, item_2."position", item_2.gradebook_translator_pk1, item_2.secondary_translator_pk1, item_2.grading_term_pk1, item_2.qti_asi_data_pk1, item_2.crsmain_pk1, item_2.batch_uid, item_2.course_contents_pk1, item_2.linkrefid, item_2.title, item_2.display_title, item_2.gradebook_type_pk1, item_2.description, item_2.description_type, item_2.due_date, item_2.possible, item_2.visible_ind, item_2.visible_in_book_ind, item_2.visible_in_all_terms_ind, item_2.stat_visible_to_stu_ind, item_2.hide_attempt_ind, item_2.weight, item_2.date_added, item_2.date_modified, item_2.aggregation_model, item_2.calculated_ind, item_2.scorable_ind, item_2.user_created_ind, item_2.single_attempt_ind, item_2.ext_asmt_analysis_url, item_2.ext_atmpt_handler_url, item_2.score_provider_handle, item_2.ignore_unscored_ind, item_2.limited_attendance_ind, item_2.version, item_2.deleted_ind, item_2.multiple_attempts, item_2.tool_computed_points, item_2.grading_decimal_places, item_2.delegated_grading_ind, item_2.anonymous_grading_ind, item_2.anon_grading_release_date, item_2.anon_grading_rel_crit, item_2.lti_domain_pk1, item_2.lti_tag, item_2.lti_res_id, item_2.peer_grading_ind, item_2.peer_reviews_per_student, item_2.peer_allow_late_reviews_ind
  • Index Cond: (item_2.pk1 = grade_2.gradebook_main_pk1)
  • Filter: ((item_2.aggregation_model = 3) AND (item_2.deleted_ind = 'N'::bpchar))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=16
17. 0.000 0.000 ↓ 0.0 0

Index Scan using attempt_pk on public.attempt attempt_2 (cost=86.50..95.50 rows=1 width=526) (never executed)

  • Output: attempt_2.gradebook_grade_pk1, attempt_2.pk1, attempt_2.qti_result_data_pk1, attempt_2.linkrefid, attempt_2.score, attempt_2.grade, attempt_2.student_comments, attempt_2.instructor_comments, attempt_2.feedback_format_type, attempt_2.comment_public_ind, attempt_2.exempt_ind, attempt_2.override_ind, attempt_2.instructor_notes, attempt_2.notes_format_type, attempt_2.status, attempt_2.attempt_date, attempt_2.first_graded_date, attempt_2.last_graded_date, attempt_2.date_added, attempt_2.date_modified, attempt_2.latest_ind, attempt_2.group_attempt_pk1, attempt_2.student_submission, attempt_2.text_format_type, attempt_2.graded_anonymously_ind, attempt_2.reconciliation_mode, attempt_2.show_staged_feedback, attempt_2.expected_end_date, attempt_2.ready_to_post_ind, attempt_2.nested_file_ind
  • Index Cond: (attempt_2.pk1 = grade_2.lowest_attempt_pk1)
18. 0.000 0.010 ↓ 0.0 0 1

Nested Loop Left Join (cost=258.00..12,825.58 rows=1 width=990) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: grade_3.pk1, item_3.crsmain_pk1, grade_3.gradebook_main_pk1, item_3.grading_term_pk1, grade_3.course_users_pk1, grade_3.comments, grade_3.notes_format_type, grade_3.for_student_comments, grade_3.feedback_format_type, grade_3.status, attempt_3.status, attempt_3.score, attempt_3.grade, CASE WHEN (grade_3.last_attempt_date IS NOT NULL) THEN grade_3.last_attempt_date WHEN (attempt_3.attempt_date IS NOT NULL) THEN attempt_3.attempt_date ELSE NULL::timestamp without time zone END, CASE WHEN (attempt_3.last_graded_date IS NOT NULL) THEN attempt_3.last_graded_date WHEN (attempt_3.first_graded_date IS NOT NULL) THEN attempt_3.first_graded_date WHEN (attempt_3.date_modified IS NOT NULL) THEN attempt_3.date_modified ELSE attempt_3.attempt_date END, attempt_3.comment_public_ind, attempt_3.instructor_comments, attempt_3.feedback_format_type, attempt_3.instructor_notes, attempt_3.notes_format_type, attempt_3.pk1, attempt_3.group_attempt_pk1, attempt_3.override_ind, grade_3.manual_score, grade_3.manual_grade, grade_3.pending_manual_score, grade_3.pending_manual_grade, grade_3.perf_code_pk1, grade_3.last_override_date, grade_3.version, grade_3.exempt_ind, grade_3.excluded_ind, grade_3.exempt_attempt_ind, CASE WHEN (grade_3.first_attempt_pk1 IS NULL) THEN '0'::text WHEN (grade_3.first_attempt_pk1 = grade_3.last_attempt_pk1) THEN '1'::text ELSE 'M'::text END, attempt_3.graded_anonymously_ind, attempt_3.show_staged_feedback, attempt_3.ready_to_post_ind, grade_3.automatic_zero
  • Buffers: shared hit=23
19. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=171.50..12,729.07 rows=1 width=480) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: grade_3.pk1, grade_3.gradebook_main_pk1, grade_3.course_users_pk1, grade_3.comments, grade_3.notes_format_type, grade_3.for_student_comments, grade_3.feedback_format_type, grade_3.status, grade_3.last_attempt_date, grade_3.manual_score, grade_3.manual_grade, grade_3.pending_manual_score, grade_3.pending_manual_grade, grade_3.perf_code_pk1, grade_3.last_override_date, grade_3.version, grade_3.exempt_ind, grade_3.excluded_ind, grade_3.exempt_attempt_ind, grade_3.first_attempt_pk1, grade_3.last_attempt_pk1, grade_3.automatic_zero, grade_3.first_graded_attempt_pk1, item_3.crsmain_pk1, item_3.grading_term_pk1
  • Buffers: shared hit=23
20. 0.001 0.001 ↑ 32.5 4 1

Index Scan using gradebook_grade_if1 on public.gradebook_grade grade_3 (cost=86.50..313.42 rows=130 width=464) (actual time=0.001..0.001 rows=4 loops=1)

  • Output: grade_3.pk1, grade_3.gradebook_main_pk1, grade_3.course_users_pk1, grade_3.batch_uid, grade_3.comments, grade_3.notes_format_type, grade_3.for_student_comments, grade_3.feedback_format_type, grade_3.date_added, grade_3.date_modified, grade_3.last_override_date, grade_3.last_attempt_date, grade_3.status, grade_3.highest_attempt_pk1, grade_3.up_highest_attempt_pk1, grade_3.lowest_attempt_pk1, grade_3.up_lowest_attempt_pk1, grade_3.last_attempt_pk1, grade_3.first_attempt_pk1, grade_3.last_graded_attempt_pk1, grade_3.up_last_graded_attempt_pk1, grade_3.first_graded_attempt_pk1, grade_3.up_first_graded_attempt_pk1, grade_3.exempt_attempt_ind, grade_3.average_score, grade_3.up_average_score, grade_3.manual_grade, grade_3.manual_score, grade_3.version, grade_3.exempt_ind, grade_3.excluded_ind, grade_3.pending_manual_grade, grade_3.pending_manual_score, grade_3.perf_code_pk1, grade_3.automatic_zero
  • Index Cond: (grade_3.course_users_pk1 = '1727337'::bigint)
  • Buffers: shared hit=7
21. 0.008 0.008 ↓ 0.0 0 4

Index Scan using gradebook_main_pk on public.gradebook_main item_3 (cost=85.00..95.00 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=4)

  • Output: item_3.pk1, item_3."position", item_3.gradebook_translator_pk1, item_3.secondary_translator_pk1, item_3.grading_term_pk1, item_3.qti_asi_data_pk1, item_3.crsmain_pk1, item_3.batch_uid, item_3.course_contents_pk1, item_3.linkrefid, item_3.title, item_3.display_title, item_3.gradebook_type_pk1, item_3.description, item_3.description_type, item_3.due_date, item_3.possible, item_3.visible_ind, item_3.visible_in_book_ind, item_3.visible_in_all_terms_ind, item_3.stat_visible_to_stu_ind, item_3.hide_attempt_ind, item_3.weight, item_3.date_added, item_3.date_modified, item_3.aggregation_model, item_3.calculated_ind, item_3.scorable_ind, item_3.user_created_ind, item_3.single_attempt_ind, item_3.ext_asmt_analysis_url, item_3.ext_atmpt_handler_url, item_3.score_provider_handle, item_3.ignore_unscored_ind, item_3.limited_attendance_ind, item_3.version, item_3.deleted_ind, item_3.multiple_attempts, item_3.tool_computed_points, item_3.grading_decimal_places, item_3.delegated_grading_ind, item_3.anonymous_grading_ind, item_3.anon_grading_release_date, item_3.anon_grading_rel_crit, item_3.lti_domain_pk1, item_3.lti_tag, item_3.lti_res_id, item_3.peer_grading_ind, item_3.peer_reviews_per_student, item_3.peer_allow_late_reviews_ind
  • Index Cond: (item_3.pk1 = grade_3.gradebook_main_pk1)
  • Filter: ((item_3.aggregation_model = 4) AND (item_3.deleted_ind = 'N'::bpchar))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=16
22. 0.000 0.000 ↓ 0.0 0

Index Scan using attempt_pk on public.attempt attempt_3 (cost=86.50..95.50 rows=1 width=526) (never executed)

  • Output: attempt_3.gradebook_grade_pk1, attempt_3.pk1, attempt_3.qti_result_data_pk1, attempt_3.linkrefid, attempt_3.score, attempt_3.grade, attempt_3.student_comments, attempt_3.instructor_comments, attempt_3.feedback_format_type, attempt_3.comment_public_ind, attempt_3.exempt_ind, attempt_3.override_ind, attempt_3.instructor_notes, attempt_3.notes_format_type, attempt_3.status, attempt_3.attempt_date, attempt_3.first_graded_date, attempt_3.last_graded_date, attempt_3.date_added, attempt_3.date_modified, attempt_3.latest_ind, attempt_3.group_attempt_pk1, attempt_3.student_submission, attempt_3.text_format_type, attempt_3.graded_anonymously_ind, attempt_3.reconciliation_mode, attempt_3.show_staged_feedback, attempt_3.expected_end_date, attempt_3.ready_to_post_ind, attempt_3.nested_file_ind
  • Index Cond: (attempt_3.pk1 = grade_3.first_graded_attempt_pk1)
23. 0.001 0.011 ↓ 0.0 0 1

Subquery Scan on *SELECT* 5 (cost=171.50..13,341.10 rows=1 width=841) (actual time=0.011..0.011 rows=0 loops=1)

  • Output: "*SELECT* 5".pk1, "*SELECT* 5".book_pk1, "*SELECT* 5".gradebook_main_pk1, "*SELECT* 5".grading_term_pk1, "*SELECT* 5".course_users_pk1, "*SELECT* 5".comments, "*SELECT* 5".g_notes_format_type, "*SELECT* 5".for_student_comments, "*SELECT* 5".g_feedback_format_type, "*SELECT* 5".status, 7, "*SELECT* 5".attempt_score, "*SELECT* 5".attempt_grade, "*SELECT* 5".last_attempt_date, "*SELECT* 5".last_graded_date, NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, "*SELECT* 5".attempt_pk1, NULL::integer, NULL::text, "*SELECT* 5".manual_score, "*SELECT* 5".manual_grade, "*SELECT* 5".pending_manual_score, "*SELECT* 5".pending_manual_grade, "*SELECT* 5".perf_code_pk1, "*SELECT* 5".last_override_date, "*SELECT* 5".version, "*SELECT* 5".exempt_ind, "*SELECT* 5".excluded_ind, "*SELECT* 5".exempt_attempt_ind, "*SELECT* 5".num_attempts, "*SELECT* 5".graded_anonymously_ind, "*SELECT* 5".show_staged_feedback, "*SELECT* 5".ready_to_post_ind, "*SELECT* 5".automatic_zero
  • Buffers: shared hit=23
24. 0.000 0.010 ↓ 0.0 0 1

Nested Loop (cost=171.50..13,340.10 rows=1 width=837) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: grade_4.pk1, item_4.crsmain_pk1, grade_4.gradebook_main_pk1, item_4.grading_term_pk1, grade_4.course_users_pk1, grade_4.comments, grade_4.notes_format_type, grade_4.for_student_comments, grade_4.feedback_format_type, grade_4.status, 7, grade_4.average_score, (grade_4.average_score)::text, CASE WHEN (grade_4.last_attempt_date IS NOT NULL) THEN grade_4.last_attempt_date ELSE (SubPlan 2) END, (SubPlan 3), NULL::text, NULL::text, NULL::text, NULL::text, NULL::text, grade_4.last_graded_attempt_pk1, NULL::integer, NULL::text, grade_4.manual_score, grade_4.manual_grade, grade_4.pending_manual_score, grade_4.pending_manual_grade, grade_4.perf_code_pk1, grade_4.last_override_date, grade_4.version, grade_4.exempt_ind, grade_4.excluded_ind, grade_4.exempt_attempt_ind, CASE WHEN (grade_4.first_attempt_pk1 IS NULL) THEN '0'::text WHEN (grade_4.first_attempt_pk1 = grade_4.last_attempt_pk1) THEN '1'::text ELSE 'M'::text END, (SubPlan 4), (SubPlan 5), (SubPlan 6), grade_4.automatic_zero
  • Buffers: shared hit=23
25. 0.003 0.003 ↑ 32.5 4 1

Index Scan using gradebook_grade_if1 on public.gradebook_grade grade_4 (cost=86.50..313.42 rows=130 width=469) (actual time=0.002..0.003 rows=4 loops=1)

  • Output: grade_4.pk1, grade_4.gradebook_main_pk1, grade_4.course_users_pk1, grade_4.batch_uid, grade_4.comments, grade_4.notes_format_type, grade_4.for_student_comments, grade_4.feedback_format_type, grade_4.date_added, grade_4.date_modified, grade_4.last_override_date, grade_4.last_attempt_date, grade_4.status, grade_4.highest_attempt_pk1, grade_4.up_highest_attempt_pk1, grade_4.lowest_attempt_pk1, grade_4.up_lowest_attempt_pk1, grade_4.last_attempt_pk1, grade_4.first_attempt_pk1, grade_4.last_graded_attempt_pk1, grade_4.up_last_graded_attempt_pk1, grade_4.first_graded_attempt_pk1, grade_4.up_first_graded_attempt_pk1, grade_4.exempt_attempt_ind, grade_4.average_score, grade_4.up_average_score, grade_4.manual_grade, grade_4.manual_score, grade_4.version, grade_4.exempt_ind, grade_4.excluded_ind, grade_4.pending_manual_grade, grade_4.pending_manual_score, grade_4.perf_code_pk1, grade_4.automatic_zero
  • Index Cond: (grade_4.course_users_pk1 = '1727337'::bigint)
  • Buffers: shared hit=7
26. 0.008 0.008 ↓ 0.0 0 4

Index Scan using gradebook_main_pk on public.gradebook_main item_4 (cost=85.00..95.00 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=4)

  • Output: item_4.pk1, item_4."position", item_4.gradebook_translator_pk1, item_4.secondary_translator_pk1, item_4.grading_term_pk1, item_4.qti_asi_data_pk1, item_4.crsmain_pk1, item_4.batch_uid, item_4.course_contents_pk1, item_4.linkrefid, item_4.title, item_4.display_title, item_4.gradebook_type_pk1, item_4.description, item_4.description_type, item_4.due_date, item_4.possible, item_4.visible_ind, item_4.visible_in_book_ind, item_4.visible_in_all_terms_ind, item_4.stat_visible_to_stu_ind, item_4.hide_attempt_ind, item_4.weight, item_4.date_added, item_4.date_modified, item_4.aggregation_model, item_4.calculated_ind, item_4.scorable_ind, item_4.user_created_ind, item_4.single_attempt_ind, item_4.ext_asmt_analysis_url, item_4.ext_atmpt_handler_url, item_4.score_provider_handle, item_4.ignore_unscored_ind, item_4.limited_attendance_ind, item_4.version, item_4.deleted_ind, item_4.multiple_attempts, item_4.tool_computed_points, item_4.grading_decimal_places, item_4.delegated_grading_ind, item_4.anonymous_grading_ind, item_4.anon_grading_release_date, item_4.anon_grading_rel_crit, item_4.lti_domain_pk1, item_4.lti_tag, item_4.lti_res_id, item_4.peer_grading_ind, item_4.peer_reviews_per_student, item_4.peer_allow_late_reviews_ind
  • Index Cond: (item_4.pk1 = grade_4.gradebook_main_pk1)
  • Filter: ((item_4.aggregation_model = 5) AND (item_4.deleted_ind = 'N'::bpchar))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=16
27.          

SubPlan (for Nested Loop)

28. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=121.50..122.00 rows=1 width=8) (never executed)

  • Output: max(attempt_4.attempt_date)
29. 0.000 0.000 ↓ 0.0 0

Index Scan using attempt_ie2 on public.attempt attempt_4 (cost=111.50..121.00 rows=1 width=8) (never executed)

  • Output: attempt_4.gradebook_grade_pk1, attempt_4.pk1, attempt_4.qti_result_data_pk1, attempt_4.linkrefid, attempt_4.score, attempt_4.grade, attempt_4.student_comments, attempt_4.instructor_comments, attempt_4.feedback_format_type, attempt_4.comment_public_ind, attempt_4.exempt_ind, attempt_4.override_ind, attempt_4.instructor_notes, attempt_4.notes_format_type, attempt_4.status, attempt_4.attempt_date, attempt_4.first_graded_date, attempt_4.last_graded_date, attempt_4.date_added, attempt_4.date_modified, attempt_4.latest_ind, attempt_4.group_attempt_pk1, attempt_4.student_submission, attempt_4.text_format_type, attempt_4.graded_anonymously_ind, attempt_4.reconciliation_mode, attempt_4.show_staged_feedback, attempt_4.expected_end_date, attempt_4.ready_to_post_ind, attempt_4.nested_file_ind
  • Index Cond: (attempt_4.gradebook_grade_pk1 = grade_4.pk1)
  • Filter: (attempt_4.exempt_ind = 'N'::bpchar)
30. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=122.50..123.00 rows=1 width=8) (never executed)

  • Output: COALESCE(COALESCE(max(attempt_5.last_graded_date), max(attempt_5.first_graded_date)), max(attempt_5.date_modified))
31. 0.000 0.000 ↓ 0.0 0

Index Scan using attempt_ie2 on public.attempt attempt_5 (cost=111.50..121.00 rows=1 width=24) (never executed)

  • Output: attempt_5.gradebook_grade_pk1, attempt_5.pk1, attempt_5.qti_result_data_pk1, attempt_5.linkrefid, attempt_5.score, attempt_5.grade, attempt_5.student_comments, attempt_5.instructor_comments, attempt_5.feedback_format_type, attempt_5.comment_public_ind, attempt_5.exempt_ind, attempt_5.override_ind, attempt_5.instructor_notes, attempt_5.notes_format_type, attempt_5.status, attempt_5.attempt_date, attempt_5.first_graded_date, attempt_5.last_graded_date, attempt_5.date_added, attempt_5.date_modified, attempt_5.latest_ind, attempt_5.group_attempt_pk1, attempt_5.student_submission, attempt_5.text_format_type, attempt_5.graded_anonymously_ind, attempt_5.reconciliation_mode, attempt_5.show_staged_feedback, attempt_5.expected_end_date, attempt_5.ready_to_post_ind, attempt_5.nested_file_ind
  • Index Cond: (attempt_5.gradebook_grade_pk1 = grade_4.pk1)
  • Filter: (attempt_5.exempt_ind = 'N'::bpchar)
32. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=121.00..121.50 rows=1 width=32) (never executed)

  • Output: min(COALESCE(attempt_6.graded_anonymously_ind, 'N'::bpchar))
33. 0.000 0.000 ↓ 0.0 0

Index Scan using attempt_ie2 on public.attempt attempt_6 (cost=111.50..120.50 rows=1 width=2) (never executed)

  • Output: attempt_6.gradebook_grade_pk1, attempt_6.pk1, attempt_6.qti_result_data_pk1, attempt_6.linkrefid, attempt_6.score, attempt_6.grade, attempt_6.student_comments, attempt_6.instructor_comments, attempt_6.feedback_format_type, attempt_6.comment_public_ind, attempt_6.exempt_ind, attempt_6.override_ind, attempt_6.instructor_notes, attempt_6.notes_format_type, attempt_6.status, attempt_6.attempt_date, attempt_6.first_graded_date, attempt_6.last_graded_date, attempt_6.date_added, attempt_6.date_modified, attempt_6.latest_ind, attempt_6.group_attempt_pk1, attempt_6.student_submission, attempt_6.text_format_type, attempt_6.graded_anonymously_ind, attempt_6.reconciliation_mode, attempt_6.show_staged_feedback, attempt_6.expected_end_date, attempt_6.ready_to_post_ind, attempt_6.nested_file_ind
  • Index Cond: (attempt_6.gradebook_grade_pk1 = grade_4.pk1)
34. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=121.00..121.50 rows=1 width=32) (never executed)

  • Output: min(COALESCE(attempt_7.show_staged_feedback, 'N'::bpchar))
35. 0.000 0.000 ↓ 0.0 0

Index Scan using attempt_ie2 on public.attempt attempt_7 (cost=111.50..120.50 rows=1 width=2) (never executed)

  • Output: attempt_7.gradebook_grade_pk1, attempt_7.pk1, attempt_7.qti_result_data_pk1, attempt_7.linkrefid, attempt_7.score, attempt_7.grade, attempt_7.student_comments, attempt_7.instructor_comments, attempt_7.feedback_format_type, attempt_7.comment_public_ind, attempt_7.exempt_ind, attempt_7.override_ind, attempt_7.instructor_notes, attempt_7.notes_format_type, attempt_7.status, attempt_7.attempt_date, attempt_7.first_graded_date, attempt_7.last_graded_date, attempt_7.date_added, attempt_7.date_modified, attempt_7.latest_ind, attempt_7.group_attempt_pk1, attempt_7.student_submission, attempt_7.text_format_type, attempt_7.graded_anonymously_ind, attempt_7.reconciliation_mode, attempt_7.show_staged_feedback, attempt_7.expected_end_date, attempt_7.ready_to_post_ind, attempt_7.nested_file_ind
  • Index Cond: (attempt_7.gradebook_grade_pk1 = grade_4.pk1)
36. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=121.00..121.50 rows=1 width=32) (never executed)

  • Output: min(COALESCE(attempt_8.ready_to_post_ind, 'N'::bpchar))
37. 0.000 0.000 ↓ 0.0 0

Index Scan using attempt_ie2 on public.attempt attempt_8 (cost=111.50..120.50 rows=1 width=2) (never executed)

  • Output: attempt_8.gradebook_grade_pk1, attempt_8.pk1, attempt_8.qti_result_data_pk1, attempt_8.linkrefid, attempt_8.score, attempt_8.grade, attempt_8.student_comments, attempt_8.instructor_comments, attempt_8.feedback_format_type, attempt_8.comment_public_ind, attempt_8.exempt_ind, attempt_8.override_ind, attempt_8.instructor_notes, attempt_8.notes_format_type, attempt_8.status, attempt_8.attempt_date, attempt_8.first_graded_date, attempt_8.last_graded_date, attempt_8.date_added, attempt_8.date_modified, attempt_8.latest_ind, attempt_8.group_attempt_pk1, attempt_8.student_submission, attempt_8.text_format_type, attempt_8.graded_anonymously_ind, attempt_8.reconciliation_mode, attempt_8.show_staged_feedback, attempt_8.expected_end_date, attempt_8.ready_to_post_ind, attempt_8.nested_file_ind
  • Index Cond: (attempt_8.gradebook_grade_pk1 = grade_4.pk1)
38. 0.004 0.004 ↑ 1.0 1 4

Index Scan using gradebook_main_pk on public.gradebook_main gm (cost=85.00..94.00 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=4)

  • Output: gm.pk1, gm."position", gm.gradebook_translator_pk1, gm.secondary_translator_pk1, gm.grading_term_pk1, gm.qti_asi_data_pk1, gm.crsmain_pk1, gm.batch_uid, gm.course_contents_pk1, gm.linkrefid, gm.title, gm.display_title, gm.gradebook_type_pk1, gm.description, gm.description_type, gm.due_date, gm.possible, gm.visible_ind, gm.visible_in_book_ind, gm.visible_in_all_terms_ind, gm.stat_visible_to_stu_ind, gm.hide_attempt_ind, gm.weight, gm.date_added, gm.date_modified, gm.aggregation_model, gm.calculated_ind, gm.scorable_ind, gm.user_created_ind, gm.single_attempt_ind, gm.ext_asmt_analysis_url, gm.ext_atmpt_handler_url, gm.score_provider_handle, gm.ignore_unscored_ind, gm.limited_attendance_ind, gm.version, gm.deleted_ind, gm.multiple_attempts, gm.tool_computed_points, gm.grading_decimal_places, gm.delegated_grading_ind, gm.anonymous_grading_ind, gm.anon_grading_release_date, gm.anon_grading_rel_crit, gm.lti_domain_pk1, gm.lti_tag, gm.lti_res_id, gm.peer_grading_ind, gm.peer_reviews_per_student, gm.peer_allow_late_reviews_ind
  • Index Cond: (gm.pk1 = grade.gradebook_main_pk1)
  • Buffers: shared hit=16
39.          

SubPlan (for Nested Loop)

40. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=242.51..244.01 rows=3 width=8) (never executed)

  • Output: dg.users_pk1
  • Group Key: dg.users_pk1
41. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..241.01 rows=3 width=8) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.delegated_grader dg (cost=0.00..31.00 rows=1 width=8) (never executed)

  • Output: dg.users_pk1
  • Filter: ((dg.gradebook_main_pk1 = gm.pk1) AND (dg.type = 'A'::bpchar) AND (dg.users_pk1 = '71451'::bigint))
43. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=30.50..71.50 rows=1 width=8) (never executed)

  • Output: dg_1.users_pk1
44. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.delegated_grader dg_1 (cost=0.00..31.00 rows=1 width=16) (never executed)

  • Output: dg_1.pk1, dg_1.gradebook_main_pk1, dg_1.users_pk1, dg_1.type, dg_1.random_count, dg_1.can_view_others_ind, dg_1.can_reconcile_ind
  • Filter: ((dg_1.gradebook_main_pk1 = gm.pk1) AND (dg_1.type = 'R'::bpchar) AND (dg_1.users_pk1 = '71451'::bigint))
45. 0.000 0.000 ↓ 0.0 0

Index Only Scan using delegated_grader_user_ak1 on public.delegated_grader_user dgu (cost=30.50..40.00 rows=1 width=8) (never executed)

  • Output: dgu.delegated_grader_pk1, dgu.course_users_pk1
  • Index Cond: ((dgu.delegated_grader_pk1 = dg_1.pk1) AND (dgu.course_users_pk1 = grade.course_users_pk1))
  • Heap Fetches: 0
46. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=86.50..137.01 rows=1 width=8) (never executed)

  • Output: dg_2.users_pk1
47. 0.000 0.000 ↓ 0.0 0

Index Scan using group_users_if2 on public.group_users gu (cost=56.00..65.00 rows=1 width=8) (never executed)

  • Output: gu.course_users_pk1, gu.groups_pk1, gu.pk1, gu.group_role
  • Index Cond: (gu.course_users_pk1 = grade.course_users_pk1)
48. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=30.50..71.50 rows=1 width=16) (never executed)

  • Output: dg_2.users_pk1, dgg.groups_pk1
49. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.delegated_grader dg_2 (cost=0.00..31.00 rows=1 width=16) (never executed)

  • Output: dg_2.pk1, dg_2.gradebook_main_pk1, dg_2.users_pk1, dg_2.type, dg_2.random_count, dg_2.can_view_others_ind, dg_2.can_reconcile_ind
  • Filter: ((dg_2.gradebook_main_pk1 = gm.pk1) AND (dg_2.type = 'G'::bpchar) AND (dg_2.users_pk1 = '71451'::bigint))
50. 0.000 0.000 ↓ 0.0 0

Index Only Scan using delegated_grader_group_ak1 on public.delegated_grader_group dgg (cost=30.50..40.00 rows=1 width=16) (never executed)

  • Output: dgg.delegated_grader_pk1, dgg.groups_pk1
  • Index Cond: ((dgg.delegated_grader_pk1 = dg_2.pk1) AND (dgg.groups_pk1 = gu.groups_pk1))
  • Heap Fetches: 0
Planning time : 332,372.085 ms
Execution time : 0.893 ms