explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sQY8

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 17.895 ↓ 5.9 65 1

Unique (cost=804.11..804.82 rows=11 width=488) (actual time=17.856..17.895 rows=65 loops=1)

2. 0.122 17.859 ↓ 5.9 65 1

Sort (cost=804.11..804.13 rows=11 width=488) (actual time=17.855..17.859 rows=65 loops=1)

  • Sort Key: scoring_item_submission.sis_id, scoring_item_submission.enrollment_id, (COALESCE(u.artifact_path, 'No artifact identifier specified'::character varying)), u.s3_version, u.file_name, scoring_item_submission.submission_status_id, (CASE WHEN scoring_item_submission.artifact_plagiarized_ind THEN 'Y'::text ELSE 'U'::text END), (CASE WHEN (NOT scoring_item_submission.sent_plagiarism_checker_ind) THEN 'N'::text WHEN scoring_item_submission.sent_plagiarism_checker_ind THEN 'Y'::text ELSE 'U'::text END), (CASE WHEN (scoring_item_submission.plagiarism_found_by_checker_ind AND scoring_item_submission.sent_plagiarism_checker_ind) THEN 'Y'::text WHEN (((NOT scoring_item_submission.plagiarism_found_by_checker_ind) OR (scoring_item_submission.plagiarism_found_by_checker_ind IS NULL)) AND scoring_item_submission.sent_plagiarism_checker_ind) THEN 'N'::text WHEN ((scoring_item_submission.sent_plagiarism_checker_ind IS NULL) OR (NOT scoring_item_submission.sent_plagiarism_checker_ind)) THEN 'N'::text ELSE 'U'::text END), (CASE WHEN scoring_item_submission.override_plagiarism_flags_ind THEN 'Y'::text ELSE 'U'::text END), (CASE WHEN scoring_item_submission.override_plagiarism_flags_ind THEN 'Y'::text WHEN (((NOT scoring_item_submission.override_plagiarism_flags_ind) OR (scoring_item_submission.override_plagiarism_flags_ind IS NULL)) AND (scoring_item_submission.plagiarism_found_by_checker_ind OR scoring_item_submission.artifact_plagiarized_ind)) THEN 'N'::text ELSE 'Y'::text END), scoring_item_submission.comments, m_1.metadata_name, (CASE WHEN ((mvr.value_name)::text = 'Other'::text) THEN ((((mvr.value_name)::text || '|'::text) || (mv.metadata_value)::text))::character varying ELSE mvr.value_name END), (CASE WHEN l_1.permission_to_reuse THEN 'N'::text ELSE 'Y'::text END), ep.ap_admin_yr, c.course_cd, (CASE WHEN ((u.create_dt IS NOT NULL) AND (u.create_dt > scoring_item_submission.create_dt)) THEN u.create_dt ELSE scoring_item_submission.create_dt END), (CASE WHEN ((u.update_dt IS NOT NULL) AND (u.update_dt > scoring_item_submission.update_dt)) THEN u.update_dt ELSE scoring_item_submission.update_dt END), (CASE WHEN l_1.exam_intent_ind THEN 'Y'::text ELSE CASE WHEN (NOT l_1.exam_intent_ind) THEN 'N'::text ELSE 'U'::text END END), scoring_item_submission.assignment_id, y.lesson_id, z.dp_module_id, p.dp_person_id, s.enterprise_org_id
  • Sort Method: quicksort Memory: 45kB
3. 0.100 17.737 ↓ 5.9 65 1

Nested Loop Left Join (cost=755.21..803.92 rows=11 width=488) (actual time=16.903..17.737 rows=65 loops=1)

4. 0.020 17.572 ↓ 5.9 65 1

Nested Loop Left Join (cost=755.07..800.94 rows=11 width=342) (actual time=16.857..17.572 rows=65 loops=1)

5. 0.022 17.487 ↓ 5.9 65 1

Nested Loop Left Join (cost=754.92..795.10 rows=11 width=334) (actual time=16.846..17.487 rows=65 loops=1)

6. 0.050 17.400 ↓ 5.9 65 1

Hash Left Join (cost=754.78..793.31 rows=11 width=326) (actual time=16.835..17.400 rows=65 loops=1)

  • Hash Cond: (scoring_item_submission.sis_id = mv.sis_id)
  • Filter: (m_1.ap31_ind OR (m_1.ap31_ind IS NULL))
7. 0.009 17.046 ↓ 3.0 65 1

Nested Loop Left Join (cost=738.35..776.73 rows=22 width=272) (actual time=16.506..17.046 rows=65 loops=1)

8. 0.058 16.972 ↓ 3.0 65 1

Hash Join (cost=738.07..768.77 rows=22 width=118) (actual time=16.496..16.972 rows=65 loops=1)

  • Hash Cond: (scoring_item_submission.assignment_id = a.assignment_id)
9. 0.030 16.240 ↓ 2.1 65 1

Nested Loop (cost=700.79..731.15 rows=31 width=111) (actual time=15.791..16.240 rows=65 loops=1)

10. 0.009 16.156 ↓ 2.2 18 1

Nested Loop (cost=700.51..724.87 rows=8 width=26) (actual time=15.779..16.156 rows=18 loops=1)

11. 0.106 16.101 ↓ 2.6 23 1

Hash Join (cost=700.23..721.20 rows=9 width=26) (actual time=15.766..16.101 rows=23 loops=1)

  • Hash Cond: (l_1.section_id = s.section_id)
12. 0.688 15.849 ↑ 1.0 874 1

HashAggregate (cost=674.74..683.53 rows=879 width=312) (actual time=15.594..15.849 rows=874 loops=1)

  • Group Key: l_1.enterprise_enrollment_id, l_1.apro_enrollment_id, l_1.dp_person_id, l_1.enrollment_id, l_1.exam_intent_ind, l_1.permission_to_reuse, l_1.enrollment_role_id, l_1.status_id, l_1.section_id
13. 0.091 15.161 ↓ 1.0 891 1

Append (cost=227.40..654.96 rows=879 width=312) (actual time=0.824..15.161 rows=891 loops=1)

14. 0.063 1.335 ↓ 76.0 76 1

Nested Loop (cost=227.40..245.70 rows=1 width=61) (actual time=0.823..1.335 rows=76 loops=1)

  • Join Filter: (b.course_instance_id = m_2.course_instance_id)
  • Rows Removed by Join Filter: 82
15. 0.064 1.114 ↓ 158.0 158 1

Nested Loop (cost=227.12..241.68 rows=1 width=69) (actual time=0.814..1.114 rows=158 loops=1)

16. 0.055 0.822 ↓ 76.0 76 1

HashAggregate (cost=226.84..227.91 rows=1 width=24) (actual time=0.798..0.822 rows=76 loops=1)

  • Group Key: a_1.dp_person_id, b.course_instance_id
  • Filter: (count(*) = 1)
  • Rows Removed by Filter: 17
17. 0.048 0.767 ↓ 1.3 112 1

Hash Join (cost=131.38..226.21 rows=85 width=16) (actual time=0.674..0.767 rows=112 loops=1)

  • Hash Cond: (a_1.section_id = b.section_id)
18. 0.072 0.088 ↓ 1.3 112 1

Bitmap Heap Scan on enrollment a_1 (cost=6.10..100.70 rows=85 width=16) (actual time=0.022..0.088 rows=112 loops=1)

  • Recheck Cond: (apro_enrollment_id IS NOT NULL)
  • Filter: ((status_id = ANY ('{4,5}'::integer[])) AND (enrollment_role_id = 2))
  • Rows Removed by Filter: 130
  • Heap Blocks: exact=17
19. 0.016 0.016 ↓ 1.0 248 1

Bitmap Index Scan on uk_apro_enrollment_id (cost=0.00..6.08 rows=240 width=0) (actual time=0.016..0.016 rows=248 loops=1)

  • Index Cond: (apro_enrollment_id IS NOT NULL)
20. 0.304 0.631 ↓ 1.0 2,059 1

Hash (cost=99.57..99.57 rows=2,057 width=16) (actual time=0.631..0.631 rows=2,059 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 129kB
21. 0.327 0.327 ↓ 1.0 2,059 1

Seq Scan on section b (cost=0.00..99.57 rows=2,057 width=16) (actual time=0.004..0.327 rows=2,059 loops=1)

22. 0.228 0.228 ↓ 2.0 2 76

Index Scan using ix_enrollment_person_id on enrollment l_1 (cost=0.28..13.75 rows=1 width=61) (actual time=0.002..0.003 rows=2 loops=76)

  • Index Cond: (dp_person_id = a_1.dp_person_id)
  • Filter: ((apro_enrollment_id IS NOT NULL) AND (status_id = ANY ('{4,5}'::integer[])) AND (status_id = ANY ('{4,5}'::integer[])) AND (enrollment_role_id = 2))
  • Rows Removed by Filter: 3
23. 0.158 0.158 ↑ 1.0 1 158

Index Scan using pk_section on section m_2 (cost=0.28..4.01 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=158)

  • Index Cond: (section_id = l_1.section_id)
24. 0.863 0.863 ↑ 1.1 779 1

Seq Scan on enrollment (cost=0.00..148.96 rows=877 width=61) (actual time=0.006..0.863 rows=779 loops=1)

  • Filter: ((apro_enrollment_id IS NULL) AND (status_id = ANY ('{4,5}'::integer[])) AND (status_id = ANY ('{4,5}'::integer[])) AND (enrollment_role_id = 2))
  • Rows Removed by Filter: 2539
25. 3.578 12.872 ↓ 36.0 36 1

Nested Loop (cost=227.96..247.12 rows=1 width=61) (actual time=0.995..12.872 rows=36 loops=1)

  • Join Filter: (a_2.dp_person_id = l_2.dp_person_id)
  • Rows Removed by Join Filter: 1163
26. 1.333 3.429 ↓ 5,865.0 5,865 1

Nested Loop (cost=227.68..246.55 rows=1 width=25) (actual time=0.795..3.429 rows=5,865 loops=1)

  • Join Filter: (b_1.course_instance_id = m_3.course_instance_id)
27. 0.042 1.023 ↓ 37.0 37 1

Nested Loop (cost=227.40..244.01 rows=1 width=33) (actual time=0.785..1.023 rows=37 loops=1)

  • Join Filter: (b_1.course_instance_id = s_1.course_instance_id)
  • Rows Removed by Join Filter: 56
28. 0.029 0.888 ↓ 93.0 93 1

Nested Loop (cost=227.12..241.65 rows=1 width=33) (actual time=0.777..0.888 rows=93 loops=1)

29. 0.046 0.779 ↓ 16.0 16 1

HashAggregate (cost=226.84..227.91 rows=1 width=24) (actual time=0.765..0.779 rows=16 loops=1)

  • Group Key: a_2.dp_person_id, b_1.course_instance_id
  • Filter: (count(*) = 2)
  • Rows Removed by Filter: 77
30. 0.053 0.733 ↓ 1.3 112 1

Hash Join (cost=131.38..226.21 rows=85 width=16) (actual time=0.654..0.733 rows=112 loops=1)

  • Hash Cond: (a_2.section_id = b_1.section_id)
31. 0.058 0.073 ↓ 1.3 112 1

Bitmap Heap Scan on enrollment a_2 (cost=6.10..100.70 rows=85 width=16) (actual time=0.021..0.073 rows=112 loops=1)

  • Recheck Cond: (apro_enrollment_id IS NOT NULL)
  • Filter: ((status_id = ANY ('{4,5}'::integer[])) AND (enrollment_role_id = 2))
  • Rows Removed by Filter: 130
  • Heap Blocks: exact=17
32. 0.015 0.015 ↓ 1.0 248 1

Bitmap Index Scan on uk_apro_enrollment_id (cost=0.00..6.08 rows=240 width=0) (actual time=0.015..0.015 rows=248 loops=1)

  • Index Cond: (apro_enrollment_id IS NOT NULL)
33. 0.303 0.607 ↓ 1.0 2,059 1

Hash (cost=99.57..99.57 rows=2,057 width=16) (actual time=0.607..0.607 rows=2,059 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 129kB
34. 0.304 0.304 ↓ 1.0 2,059 1

Seq Scan on section b_1 (cost=0.00..99.57 rows=2,057 width=16) (actual time=0.004..0.304 rows=2,059 loops=1)

35. 0.080 0.080 ↓ 6.0 6 16

Index Scan using ix_enrollment_person_id on enrollment r (cost=0.28..13.72 rows=1 width=17) (actual time=0.002..0.005 rows=6 loops=16)

  • Index Cond: (dp_person_id = a_2.dp_person_id)
  • Filter: (is_primary_ind IS FALSE)
  • Rows Removed by Filter: 5
36. 0.093 0.093 ↑ 1.0 1 93

Index Scan using pk_section on section s_1 (cost=0.28..2.35 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=93)

  • Index Cond: (section_id = r.section_id)
37. 1.073 1.073 ↓ 2.3 159 37

Index Scan using ix_section_course_instance_id on section m_3 (cost=0.28..1.68 rows=69 width=16) (actual time=0.003..0.029 rows=159 loops=37)

  • Index Cond: (course_instance_id = s_1.course_instance_id)
38. 5.865 5.865 ↓ 0.0 0 5,865

Index Scan using ix_enrollment_section_id on enrollment l_2 (cost=0.28..0.56 rows=1 width=61) (actual time=0.001..0.001 rows=0 loops=5,865)

  • Index Cond: (section_id = m_3.section_id)
  • Filter: ((apro_enrollment_id IS NOT NULL) AND (is_primary_ind IS TRUE) AND (status_id = ANY ('{4,5}'::integer[])) AND (status_id = ANY ('{4,5}'::integer[])) AND (enrollment_role_id = 2))
  • Rows Removed by Filter: 2
39. 0.021 0.146 ↓ 6.0 126 1

Hash (cost=25.23..25.23 rows=21 width=16) (actual time=0.146..0.146 rows=126 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
40. 0.028 0.125 ↓ 6.0 126 1

Nested Loop (cost=14.05..25.23 rows=21 width=16) (actual time=0.038..0.125 rows=126 loops=1)

41. 0.022 0.034 ↓ 9.0 9 1

Hash Join (cost=13.78..16.79 rows=1 width=8) (actual time=0.024..0.034 rows=9 loops=1)

  • Hash Cond: (ci.education_period_cd = (ap_feed_views_config.config_value)::integer)
42. 0.004 0.004 ↑ 1.6 39 1

Seq Scan on course_instance ci (cost=0.00..2.62 rows=62 width=12) (actual time=0.001..0.004 rows=39 loops=1)

43. 0.004 0.008 ↑ 2.0 1 1

Hash (cost=13.75..13.75 rows=2 width=118) (actual time=0.008..0.008 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
44. 0.004 0.004 ↑ 2.0 1 1

Seq Scan on ap_feed_views_config (cost=0.00..13.75 rows=2 width=118) (actual time=0.003..0.004 rows=1 loops=1)

  • Filter: ((config_name)::text = 'feeds_education_period_cd'::text)
45. 0.063 0.063 ↑ 4.9 14 9

Index Scan using ix_section_course_instance_id on section s (cost=0.28..7.75 rows=69 width=24) (actual time=0.003..0.007 rows=14 loops=9)

  • Index Cond: (course_instance_id = ci.course_instance_id)
46. 0.046 0.046 ↑ 1.0 1 23

Index Scan using pk_dp_person on dp_person p (cost=0.28..0.41 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=23)

  • Index Cond: (dp_person_id = l_1.dp_person_id)
  • Filter: (NOT test_ind)
  • Rows Removed by Filter: 0
47. 0.054 0.054 ↑ 1.0 4 18

Index Scan using ix_sis_enrollment on scoring_item_submission (cost=0.28..0.74 rows=4 width=93) (actual time=0.002..0.003 rows=4 loops=18)

  • Index Cond: (enrollment_id = l_1.enrollment_id)
  • Filter: (submission_status_id <> 6)
  • Rows Removed by Filter: 0
48. 0.031 0.674 ↓ 1.5 115 1

Hash (cost=36.34..36.34 rows=75 width=23) (actual time=0.674..0.674 rows=115 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
49. 0.047 0.643 ↓ 1.5 115 1

Hash Join (cost=30.29..36.34 rows=75 width=23) (actual time=0.320..0.643 rows=115 loops=1)

  • Hash Cond: (aa.assignment_id = a.assignment_id)
50. 0.041 0.551 ↓ 1.5 115 1

Hash Join (cost=25.86..31.70 rows=75 width=15) (actual time=0.263..0.551 rows=115 loops=1)

  • Hash Cond: (ci_1.education_period_cd = ep.education_period_cd)
51. 0.045 0.492 ↓ 1.5 115 1

Hash Join (cost=24.39..29.99 rows=75 width=14) (actual time=0.232..0.492 rows=115 loops=1)

  • Hash Cond: (aa.assignment_type_id = at.assignment_type_id)
52. 0.139 0.440 ↓ 1.5 115 1

Hash Join (cost=23.18..28.50 rows=75 width=18) (actual time=0.213..0.440 rows=115 loops=1)

  • Hash Cond: (lower((ci_1.course_cd)::text) = lower((c.course_cd)::text))
53. 0.045 0.263 ↓ 1.1 115 1

Hash Join (cost=21.15..25.09 rows=101 width=18) (actual time=0.159..0.263 rows=115 loops=1)

  • Hash Cond: (m.course_instance_id = ci_1.course_instance_id)
54. 0.047 0.197 ↓ 1.1 115 1

Hash Join (cost=17.75..21.40 rows=101 width=20) (actual time=0.123..0.197 rows=115 loops=1)

  • Hash Cond: (l.dp_module_id = m.dp_module_id)
55. 0.051 0.120 ↓ 1.1 115 1

Hash Join (cost=10.97..14.35 rows=101 width=20) (actual time=0.075..0.120 rows=115 loops=1)

  • Hash Cond: (aa.lesson_id = l.lesson_id)
56. 0.012 0.012 ↓ 1.1 123 1

Seq Scan on assignment aa (cost=0.00..3.08 rows=108 width=20) (actual time=0.001..0.012 rows=123 loops=1)

57. 0.019 0.057 ↑ 1.0 115 1

Hash (cost=9.54..9.54 rows=115 width=16) (actual time=0.057..0.057 rows=115 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
58. 0.038 0.038 ↑ 1.0 115 1

Seq Scan on lesson l (cost=0.00..9.54 rows=115 width=16) (actual time=0.004..0.038 rows=115 loops=1)

  • Filter: ((submission_type)::text = 'Individual'::text)
  • Rows Removed by Filter: 8
59. 0.013 0.030 ↑ 1.1 73 1

Hash (cost=5.79..5.79 rows=79 width=16) (actual time=0.030..0.030 rows=73 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
60. 0.017 0.017 ↑ 1.1 73 1

Seq Scan on dp_module m (cost=0.00..5.79 rows=79 width=16) (actual time=0.002..0.017 rows=73 loops=1)

61. 0.011 0.021 ↑ 1.6 39 1

Hash (cost=2.62..2.62 rows=62 width=14) (actual time=0.021..0.021 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
62. 0.010 0.010 ↑ 1.6 39 1

Seq Scan on course_instance ci_1 (cost=0.00..2.62 rows=62 width=14) (actual time=0.003..0.010 rows=39 loops=1)

63. 0.029 0.038 ↑ 1.0 46 1

Hash (cost=1.46..1.46 rows=46 width=2) (actual time=0.037..0.038 rows=46 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
64. 0.009 0.009 ↑ 1.0 46 1

Seq Scan on course c (cost=0.00..1.46 rows=46 width=2) (actual time=0.004..0.009 rows=46 loops=1)

65. 0.003 0.007 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=4) (actual time=0.007..0.007 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
66. 0.004 0.004 ↑ 1.0 9 1

Seq Scan on assignment_type at (cost=0.00..1.09 rows=9 width=4) (actual time=0.002..0.004 rows=9 loops=1)

67. 0.010 0.018 ↑ 1.0 21 1

Hash (cost=1.21..1.21 rows=21 width=9) (actual time=0.018..0.018 rows=21 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
68. 0.008 0.008 ↑ 1.0 21 1

Seq Scan on education_period ep (cost=0.00..1.21 rows=21 width=9) (actual time=0.003..0.008 rows=21 loops=1)

69. 0.022 0.045 ↓ 1.1 123 1

Hash (cost=3.08..3.08 rows=108 width=8) (actual time=0.045..0.045 rows=123 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
70. 0.023 0.023 ↓ 1.1 123 1

Seq Scan on assignment a (cost=0.00..3.08 rows=108 width=8) (actual time=0.007..0.023 rows=123 loops=1)

71. 0.065 0.065 ↓ 0.0 0 65

Index Scan using pk_upload on upload u (cost=0.28..0.36 rows=1 width=170) (actual time=0.001..0.001 rows=0 loops=65)

  • Index Cond: (upload_id = scoring_item_submission.upload_id)
72. 0.044 0.304 ↑ 1.3 153 1

Hash (cost=13.93..13.93 rows=200 width=63) (actual time=0.304..0.304 rows=153 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
73. 0.069 0.260 ↑ 1.3 153 1

Hash Join (cost=4.97..13.93 rows=200 width=63) (actual time=0.117..0.260 rows=153 loops=1)

  • Hash Cond: ((atm.metadata_id = mvr.metadata_id) AND (mv.value_range_id = mvr.value_range_id))
74. 0.095 0.168 ↑ 1.0 200 1

Hash Join (cost=3.32..11.18 rows=200 width=68) (actual time=0.071..0.168 rows=200 loops=1)

  • Hash Cond: ((mv.metadata_id = atm.metadata_id) AND (mv.assignment_type_id = atm.assignment_type_id))
75. 0.020 0.020 ↑ 1.0 200 1

Seq Scan on metadata_value mv (cost=0.00..5.00 rows=200 width=47) (actual time=0.003..0.020 rows=200 loops=1)

76. 0.003 0.053 ↑ 1.0 4 1

Hash (cost=3.26..3.26 rows=4 width=29) (actual time=0.053..0.053 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
77. 0.015 0.050 ↑ 1.0 4 1

Hash Join (cost=2.18..3.26 rows=4 width=29) (actual time=0.047..0.050 rows=4 loops=1)

  • Hash Cond: (m_1.metadata_type_id = mt.metadata_type_id)
78. 0.017 0.026 ↑ 1.0 4 1

Hash Join (cost=1.09..2.15 rows=4 width=33) (actual time=0.025..0.026 rows=4 loops=1)

  • Hash Cond: (atm.metadata_id = m_1.metadata_id)
79. 0.002 0.002 ↑ 1.0 4 1

Seq Scan on assignment_type_metadata atm (cost=0.00..1.04 rows=4 width=8) (actual time=0.002..0.002 rows=4 loops=1)

80. 0.003 0.007 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=25) (actual time=0.007..0.007 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
81. 0.004 0.004 ↑ 1.0 4 1

Seq Scan on metadata m_1 (cost=0.00..1.04 rows=4 width=25) (actual time=0.003..0.004 rows=4 loops=1)

82. 0.004 0.009 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=4) (actual time=0.009..0.009 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
83. 0.005 0.005 ↑ 1.0 4 1

Seq Scan on metadata_type mt (cost=0.00..1.04 rows=4 width=4) (actual time=0.004..0.005 rows=4 loops=1)

84. 0.012 0.023 ↑ 1.0 26 1

Hash (cost=1.26..1.26 rows=26 width=19) (actual time=0.022..0.023 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
85. 0.011 0.011 ↑ 1.0 26 1

Seq Scan on metadata_value_range mvr (cost=0.00..1.26 rows=26 width=19) (actual time=0.007..0.011 rows=26 loops=1)

86. 0.065 0.065 ↑ 1.0 1 65

Index Scan using pk_assignment on assignment x (cost=0.14..0.16 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=65)

  • Index Cond: (scoring_item_submission.assignment_id = assignment_id)
87. 0.065 0.065 ↑ 1.0 1 65

Index Scan using pk_lesson on lesson y (cost=0.14..0.53 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=65)

  • Index Cond: (lesson_id = x.lesson_id)
88. 0.065 0.065 ↑ 1.0 1 65

Index Only Scan using pk_dp_module on dp_module z (cost=0.14..0.26 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=65)

  • Index Cond: (dp_module_id = y.dp_module_id)