[ { "Plan": { "Node Type": "Hash Join", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 2320728.18, "Total Cost": 27491903.74, "Plan Rows": 5624407, "Plan Width": 194, "Actual Startup Time": 8559.960, "Actual Total Time": 54835.974, "Actual Rows": 740868, "Actual Loops": 1, "Output": ["s.last_login", "(max(c.spi))", "(max(c.dce))", "(max(c.patient_interaction_time))", "(avg(s_1.score_value) FILTER (WHERE (s_1.score_name = 'student_performance_index'::text)))", "(avg(s_1.score_value) FILTER (WHERE (s_1.score_name = 'digital_clinical_experience'::text)))", "(avg(s_1.score_value) FILTER (WHERE (s_1.score_name = 'patient_interaction_time'::text)))", "(count(DISTINCT m.assignment_id) FILTER (WHERE (s_1.score_name = 'student_performance_index'::text)))", "(count(DISTINCT m.assignment_id) FILTER (WHERE (s_1.score_name = 'digital_clinical_experience'::text)))", "(count(DISTINCT m.assignment_id) FILTER (WHERE (s_1.score_name = 'patient_interaction_time'::text)))", "(count(*) FILTER (WHERE ((s_1.score_name = 'student_performance_index'::text) AND (s_1.score_value < c.spi))))", "(count(*) FILTER (WHERE ((s_1.score_name = 'digital_clinical_experience'::text) AND (s_1.score_value < c.dce))))", "(count(*) FILTER (WHERE ((s_1.score_name = 'patient_interaction_time'::text) AND (s_1.score_value < c.patient_interaction_time))))", "(count(*) FILTER (WHERE ((s_1.score_name = 'student_performance_index'::text) AND (round(s_1.score_value) <= '50'::double precision))))", "(count(*) FILTER (WHERE ((s_1.score_name = 'student_performance_index'::text) AND (round(s_1.score_value) >= '51'::double precision) AND (round(s_1.score_value) <= '69'::double precision))))", "(count(*) FILTER (WHERE ((s_1.score_name = 'student_performance_index'::text) AND (round(s_1.score_value) >= '70'::double precision) AND (round(s_1.score_value) <= '89'::double precision))))", "(count(*) FILTER (WHERE ((s_1.score_name = 'student_performance_index'::text) AND (round(s_1.score_value) >= '90'::double precision))))", "(count(*) FILTER (WHERE ((s_1.score_name = 'digital_clinical_experience'::text) AND (round(s_1.score_value) <= '50'::double precision))))", "(count(*) FILTER (WHERE ((s_1.score_name = 'digital_clinical_experience'::text) AND (round(s_1.score_value) >= '51'::double precision) AND (round(s_1.score_value) <= '69'::double precision))))", "(count(*) FILTER (WHERE ((s_1.score_name = 'digital_clinical_experience'::text) AND (round(s_1.score_value) >= '70'::double precision) AND (round(s_1.score_value) <= '89'::double precision))))", "(count(*) FILTER (WHERE ((s_1.score_name = 'digital_clinical_experience'::text) AND (round(s_1.score_value) >= '90'::double precision))))", "s.days_last_login", "s_1.course_id", "s.student_id", "s.first_name", "s.last_name"], "Inner Unique": false, "Hash Cond": "(s_1.student_id = s.student_id)", "Shared Hit Blocks": 1013550, "Shared Read Blocks": 22148, "Shared Dirtied Blocks": 2, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 3099, "Local Dirtied Blocks": 0, "Local Written Blocks": 1024, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 76.101, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Aggregate", "Strategy": "Sorted", "Partial Mode": "Simple", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 2308471.75, "Total Cost": 27346067.65, "Plan Rows": 5624407, "Plan Width": 168, "Actual Startup Time": 8441.331, "Actual Total Time": 54213.301, "Actual Rows": 740868, "Actual Loops": 1, "Output": ["max(c.spi)", "max(c.dce)", "max(c.patient_interaction_time)", "avg(s_1.score_value) FILTER (WHERE (s_1.score_name = 'student_performance_index'::text))", "avg(s_1.score_value) FILTER (WHERE (s_1.score_name = 'digital_clinical_experience'::text))", "avg(s_1.score_value) FILTER (WHERE (s_1.score_name = 'patient_interaction_time'::text))", "count(DISTINCT m.assignment_id) FILTER (WHERE (s_1.score_name = 'student_performance_index'::text))", "count(DISTINCT m.assignment_id) FILTER (WHERE (s_1.score_name = 'digital_clinical_experience'::text))", "count(DISTINCT m.assignment_id) FILTER (WHERE (s_1.score_name = 'patient_interaction_time'::text))", "count(*) FILTER (WHERE ((s_1.score_name = 'student_performance_index'::text) AND (round(s_1.score_value) <= '50'::double precision)))", "count(*) FILTER (WHERE ((s_1.score_name = 'student_performance_index'::text) AND (round(s_1.score_value) >= '51'::double precision) AND (round(s_1.score_value) <= '69'::double precision)))", "count(*) FILTER (WHERE ((s_1.score_name = 'student_performance_index'::text) AND (round(s_1.score_value) >= '70'::double precision) AND (round(s_1.score_value) <= '89'::double precision)))", "count(*) FILTER (WHERE ((s_1.score_name = 'student_performance_index'::text) AND (round(s_1.score_value) >= '90'::double precision)))", "count(*) FILTER (WHERE ((s_1.score_name = 'digital_clinical_experience'::text) AND (round(s_1.score_value) <= '50'::double precision)))", "count(*) FILTER (WHERE ((s_1.score_name = 'digital_clinical_experience'::text) AND (round(s_1.score_value) >= '51'::double precision) AND (round(s_1.score_value) <= '69'::double precision)))", "count(*) FILTER (WHERE ((s_1.score_name = 'digital_clinical_experience'::text) AND (round(s_1.score_value) >= '70'::double precision) AND (round(s_1.score_value) <= '89'::double precision)))", "count(*) FILTER (WHERE ((s_1.score_name = 'digital_clinical_experience'::text) AND (round(s_1.score_value) >= '90'::double precision)))", "count(*) FILTER (WHERE ((s_1.score_name = 'student_performance_index'::text) AND (s_1.score_value < c.spi)))", "count(*) FILTER (WHERE ((s_1.score_name = 'digital_clinical_experience'::text) AND (s_1.score_value < c.dce)))", "count(*) FILTER (WHERE ((s_1.score_name = 'patient_interaction_time'::text) AND (s_1.score_value < c.patient_interaction_time)))", "s_1.student_id", "s_1.course_id"], "Group Key": ["s_1.course_id", "s_1.student_id"], "Shared Hit Blocks": 1013550, "Shared Read Blocks": 22148, "Shared Dirtied Blocks": 2, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 66.637, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Merge Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 2308471.75, "Total Cost": 10802470.68, "Plan Rows": 99667696, "Plan Width": 65, "Actual Startup Time": 8441.294, "Actual Total Time": 30454.363, "Actual Rows": 42995413, "Actual Loops": 1, "Output": ["s_1.student_id", "s_1.course_id", "c.spi", "c.dce", "c.patient_interaction_time", "s_1.score_value", "s_1.score_name", "m.assignment_id"], "Inner Unique": false, "Merge Cond": "(s_1.course_id = c.course_id)", "Shared Hit Blocks": 1013550, "Shared Read Blocks": 22148, "Shared Dirtied Blocks": 2, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 66.637, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Gather Merge", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 2303718.31, "Total Cost": 9162876.44, "Plan Rows": 56244072, "Plan Width": 41, "Actual Startup Time": 8425.231, "Actual Total Time": 17415.844, "Actual Rows": 42995413, "Actual Loops": 1, "Output": ["s_1.score_value", "s_1.score_name", "s_1.student_id", "s_1.course_id", "m.assignment_id"], "Workers Planned": 6, "Workers Launched": 6, "Shared Hit Blocks": 1011786, "Shared Read Blocks": 22148, "Shared Dirtied Blocks": 2, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 66.637, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 2302718.21, "Total Cost": 2326153.24, "Plan Rows": 9374012, "Plan Width": 41, "Actual Startup Time": 8393.223, "Actual Total Time": 9209.477, "Actual Rows": 6142202, "Actual Loops": 7, "Output": ["s_1.score_value", "s_1.score_name", "s_1.student_id", "s_1.course_id", "m.assignment_id"], "Sort Key": ["s_1.course_id", "s_1.student_id"], "Sort Method": "quicksort", "Sort Space Used": 748965, "Sort Space Type": "Memory", "Shared Hit Blocks": 1011786, "Shared Read Blocks": 22148, "Shared Dirtied Blocks": 2, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 66.637, "I/O Write Time": 0.000, "Workers": [ { "Worker Number": 0, "Actual Startup Time": 8406.864, "Actual Total Time": 9216.728, "Actual Rows": 6181678, "Actual Loops": 1, "Sort Method": "quicksort", "Sort Space Used": 757578, "Sort Space Type": "Memory", "Shared Hit Blocks": 145350, "Shared Read Blocks": 3152, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.409, "I/O Write Time": 0.000 }, { "Worker Number": 1, "Actual Startup Time": 8416.557, "Actual Total Time": 9223.967, "Actual Rows": 6166262, "Actual Loops": 1, "Sort Method": "quicksort", "Sort Space Used": 756685, "Sort Space Type": "Memory", "Shared Hit Blocks": 145041, "Shared Read Blocks": 3021, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.096, "I/O Write Time": 0.000 }, { "Worker Number": 2, "Actual Startup Time": 8374.467, "Actual Total Time": 9175.166, "Actual Rows": 6118685, "Actual Loops": 1, "Sort Method": "quicksort", "Sort Space Used": 752558, "Sort Space Type": "Memory", "Shared Hit Blocks": 143525, "Shared Read Blocks": 3266, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.655, "I/O Write Time": 0.000 }, { "Worker Number": 3, "Actual Startup Time": 8384.788, "Actual Total Time": 9188.439, "Actual Rows": 6116868, "Actual Loops": 1, "Sort Method": "quicksort", "Sort Space Used": 751093, "Sort Space Type": "Memory", "Shared Hit Blocks": 144511, "Shared Read Blocks": 3226, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.878, "I/O Write Time": 0.000 }, { "Worker Number": 4, "Actual Startup Time": 8406.308, "Actual Total Time": 9213.096, "Actual Rows": 6167433, "Actual Loops": 1, "Sort Method": "quicksort", "Sort Space Used": 756736, "Sort Space Type": "Memory", "Shared Hit Blocks": 145097, "Shared Read Blocks": 3259, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.733, "I/O Write Time": 0.000 }, { "Worker Number": 5, "Actual Startup Time": 8399.815, "Actual Total Time": 9209.768, "Actual Rows": 6156647, "Actual Loops": 1, "Sort Method": "quicksort", "Sort Space Used": 754331, "Sort Space Type": "Memory", "Shared Hit Blocks": 144916, "Shared Read Blocks": 3174, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.533, "I/O Write Time": 0.000 } ], "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Parallel Aware": true, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 72480.91, "Total Cost": 1217196.59, "Plan Rows": 9374012, "Plan Width": 41, "Actual Startup Time": 399.335, "Actual Total Time": 3998.979, "Actual Rows": 6142202, "Actual Loops": 7, "Output": ["s_1.score_value", "s_1.score_name", "s_1.student_id", "s_1.course_id", "m.assignment_id"], "Inner Unique": false, "Hash Cond": "(s_1.attempt_report_id = m.attempt_report_id)", "Shared Hit Blocks": 1011516, "Shared Read Blocks": 22148, "Shared Dirtied Blocks": 2, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 66.637, "I/O Write Time": 0.000, "Workers": [ { "Worker Number": 0, "Actual Startup Time": 398.078, "Actual Total Time": 4001.801, "Actual Rows": 6181678, "Actual Loops": 1, "Shared Hit Blocks": 145305, "Shared Read Blocks": 3152, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.409, "I/O Write Time": 0.000 }, { "Worker Number": 1, "Actual Startup Time": 398.064, "Actual Total Time": 3998.936, "Actual Rows": 6166262, "Actual Loops": 1, "Shared Hit Blocks": 144996, "Shared Read Blocks": 3021, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.096, "I/O Write Time": 0.000 }, { "Worker Number": 2, "Actual Startup Time": 398.344, "Actual Total Time": 4016.470, "Actual Rows": 6118685, "Actual Loops": 1, "Shared Hit Blocks": 143480, "Shared Read Blocks": 3266, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.655, "I/O Write Time": 0.000 }, { "Worker Number": 3, "Actual Startup Time": 398.329, "Actual Total Time": 4008.284, "Actual Rows": 6116868, "Actual Loops": 1, "Shared Hit Blocks": 144466, "Shared Read Blocks": 3226, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.878, "I/O Write Time": 0.000 }, { "Worker Number": 4, "Actual Startup Time": 398.112, "Actual Total Time": 4003.020, "Actual Rows": 6167433, "Actual Loops": 1, "Shared Hit Blocks": 145052, "Shared Read Blocks": 3259, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.733, "I/O Write Time": 0.000 }, { "Worker Number": 5, "Actual Startup Time": 398.090, "Actual Total Time": 4009.578, "Actual Rows": 6156647, "Actual Loops": 1, "Shared Hit Blocks": 144871, "Shared Read Blocks": 3174, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.533, "I/O Write Time": 0.000 } ], "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Parallel Aware": true, "Async Capable": false, "Relation Name": "attempt_scores", "Schema": "public", "Alias": "s_1", "Startup Cost": 0.00, "Total Cost": 1086128.12, "Plan Rows": 9374012, "Plan Width": 45, "Actual Startup Time": 0.010, "Actual Total Time": 684.219, "Actual Rows": 8036227, "Actual Loops": 7, "Output": ["s_1.id", "s_1.attempt_report_id", "s_1.score_value", "s_1.created_at", "s_1.attempt_report_updated_at", "s_1.student_id", "s_1.course_id", "s_1.assignment_id", "s_1.score_name", "s_1.attempted_by", "s_1.assignment_name"], "Shared Hit Blocks": 970240, "Shared Read Blocks": 22148, "Shared Dirtied Blocks": 2, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 66.637, "I/O Write Time": 0.000, "Workers": [ { "Worker Number": 0, "Actual Startup Time": 0.016, "Actual Total Time": 682.335, "Actual Rows": 8084400, "Actual Loops": 1, "Shared Hit Blocks": 139432, "Shared Read Blocks": 3152, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.409, "I/O Write Time": 0.000 }, { "Worker Number": 1, "Actual Startup Time": 0.011, "Actual Total Time": 675.123, "Actual Rows": 8065241, "Actual Loops": 1, "Shared Hit Blocks": 139194, "Shared Read Blocks": 3021, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.096, "I/O Write Time": 0.000 }, { "Worker Number": 2, "Actual Startup Time": 0.010, "Actual Total Time": 730.212, "Actual Rows": 7969802, "Actual Loops": 1, "Shared Hit Blocks": 137525, "Shared Read Blocks": 3266, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.655, "I/O Write Time": 0.000 }, { "Worker Number": 3, "Actual Startup Time": 0.009, "Actual Total Time": 681.301, "Actual Rows": 8037935, "Actual Loops": 1, "Shared Hit Blocks": 138537, "Shared Read Blocks": 3226, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.878, "I/O Write Time": 0.000 }, { "Worker Number": 4, "Actual Startup Time": 0.009, "Actual Total Time": 679.221, "Actual Rows": 8078050, "Actual Loops": 1, "Shared Hit Blocks": 139264, "Shared Read Blocks": 3259, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.733, "I/O Write Time": 0.000 }, { "Worker Number": 5, "Actual Startup Time": 0.009, "Actual Total Time": 678.256, "Actual Rows": 8061640, "Actual Loops": 1, "Shared Hit Blocks": 138993, "Shared Read Blocks": 3174, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.533, "I/O Write Time": 0.000 } ] }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Parallel Aware": true, "Async Capable": false, "Startup Cost": 55028.18, "Total Cost": 55028.18, "Plan Rows": 1396218, "Plan Width": 12, "Actual Startup Time": 392.566, "Actual Total Time": 392.567, "Actual Rows": 797839, "Actual Loops": 7, "Output": ["m.assignment_id", "m.attempt_report_id"], "Hash Buckets": 8388608, "Original Hash Buckets": 8388608, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 327744, "Shared Hit Blocks": 41066, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Workers": [ { "Worker Number": 0, "Actual Startup Time": 397.945, "Actual Total Time": 397.946, "Actual Rows": 793968, "Actual Loops": 1, "Shared Hit Blocks": 5838, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Worker Number": 1, "Actual Startup Time": 397.931, "Actual Total Time": 397.932, "Actual Rows": 784312, "Actual Loops": 1, "Shared Hit Blocks": 5767, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Worker Number": 2, "Actual Startup Time": 398.215, "Actual Total Time": 398.216, "Actual Rows": 805120, "Actual Loops": 1, "Shared Hit Blocks": 5920, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Worker Number": 3, "Actual Startup Time": 398.225, "Actual Total Time": 398.226, "Actual Rows": 801584, "Actual Loops": 1, "Shared Hit Blocks": 5894, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Worker Number": 4, "Actual Startup Time": 397.944, "Actual Total Time": 397.946, "Actual Rows": 782408, "Actual Loops": 1, "Shared Hit Blocks": 5753, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Worker Number": 5, "Actual Startup Time": 397.950, "Actual Total Time": 397.951, "Actual Rows": 794648, "Actual Loops": 1, "Shared Hit Blocks": 5843, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ], "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Parallel Aware": true, "Async Capable": false, "Relation Name": "max_spi_attempts", "Schema": "public", "Alias": "m", "Startup Cost": 0.00, "Total Cost": 55028.18, "Plan Rows": 1396218, "Plan Width": 12, "Actual Startup Time": 0.012, "Actual Total Time": 102.983, "Actual Rows": 797839, "Actual Loops": 7, "Output": ["m.assignment_id", "m.attempt_report_id"], "Shared Hit Blocks": 41066, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Workers": [ { "Worker Number": 0, "Actual Startup Time": 0.011, "Actual Total Time": 102.092, "Actual Rows": 793968, "Actual Loops": 1, "Shared Hit Blocks": 5838, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Worker Number": 1, "Actual Startup Time": 0.011, "Actual Total Time": 103.586, "Actual Rows": 784312, "Actual Loops": 1, "Shared Hit Blocks": 5767, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Worker Number": 2, "Actual Startup Time": 0.013, "Actual Total Time": 102.332, "Actual Rows": 805120, "Actual Loops": 1, "Shared Hit Blocks": 5920, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Worker Number": 3, "Actual Startup Time": 0.015, "Actual Total Time": 102.420, "Actual Rows": 801584, "Actual Loops": 1, "Shared Hit Blocks": 5894, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Worker Number": 4, "Actual Startup Time": 0.012, "Actual Total Time": 103.337, "Actual Rows": 782408, "Actual Loops": 1, "Shared Hit Blocks": 5753, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, { "Worker Number": 5, "Actual Startup Time": 0.012, "Actual Total Time": 102.423, "Actual Rows": 794648, "Actual Loops": 1, "Shared Hit Blocks": 5843, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] } ] } ] } ] } ] }, { "Node Type": "Sort", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 4360.99, "Total Cost": 4426.15, "Plan Rows": 26063, "Plan Width": 28, "Actual Startup Time": 16.055, "Actual Total Time": 2330.646, "Actual Rows": 42995408, "Actual Loops": 1, "Output": ["c.spi", "c.dce", "c.patient_interaction_time", "c.course_id"], "Sort Key": ["c.course_id"], "Sort Method": "quicksort", "Sort Space Used": 2800, "Sort Space Type": "Memory", "Shared Hit Blocks": 1764, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Relation Name": "prd_courses_data", "Schema": "public", "Alias": "c", "Startup Cost": 0.00, "Total Cost": 2449.31, "Plan Rows": 26063, "Plan Width": 28, "Actual Startup Time": 0.012, "Actual Total Time": 12.866, "Actual Rows": 26026, "Actual Loops": 1, "Output": ["c.spi", "c.dce", "c.patient_interaction_time", "c.course_id"], "Filter": "(c.section_id IS NULL)", "Rows Removed by Filter": 42505, "Shared Hit Blocks": 1764, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 } ] } ] } ] }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 7168.97, "Total Cost": 7168.97, "Plan Rows": 406997, "Plan Width": 30, "Actual Startup Time": 118.021, "Actual Total Time": 118.022, "Actual Rows": 406997, "Actual Loops": 1, "Output": ["s.last_login", "s.days_last_login", "s.student_id", "s.first_name", "s.last_name"], "Hash Buckets": 524288, "Original Hash Buckets": 524288, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 29131, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 3099, "Local Dirtied Blocks": 0, "Local Written Blocks": 1024, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.464, "I/O Write Time": 0.000, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Relation Name": "_students", "Schema": "pg_temp_7", "Alias": "s", "Startup Cost": 0.00, "Total Cost": 7168.97, "Plan Rows": 406997, "Plan Width": 30, "Actual Startup Time": 0.026, "Actual Total Time": 49.180, "Actual Rows": 406997, "Actual Loops": 1, "Output": ["s.last_login", "s.days_last_login", "s.student_id", "s.first_name", "s.last_name"], "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 3099, "Local Dirtied Blocks": 0, "Local Written Blocks": 1024, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 9.464, "I/O Write Time": 0.000 } ] } ] }, "Planning": { "Shared Hit Blocks": 345, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "I/O Read Time": 0.000, "I/O Write Time": 0.000 }, "Planning Time": 1.278, "Triggers": [ ], "Execution Time": 55833.076 } ]