explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c9r0 : evals

Settings
# exclusive inclusive rows x rows loops node
1. 15.869 36,995.374 ↓ 3,636.0 3,636 1

Unique (cost=462,740.66..462,740.75 rows=1 width=4,265) (actual time=36,977.136..36,995.374 rows=3,636 loops=1)

  • Output: applicants.id, applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.last_name, applicants.middle_name, applicants.first_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.association_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted
2. 128.033 36,979.505 ↓ 21,817.0 21,817 1

Sort (cost=462,740.66..462,740.67 rows=1 width=4,265) (actual time=36,977.133..36,979.505 rows=21,817 loops=1)

  • Output: applicants.id, applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.last_name, applicants.middle_name, applicants.first_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.association_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted
  • Sort Key: applicants.last_name, applicants.first_name, applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.middle_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted
  • Sort Method: quicksort Memory: 6,170kB
3. 29.763 36,851.472 ↓ 21,817.0 21,817 1

Nested Loop Semi Join (cost=438,063.39..462,740.65 rows=1 width=4,265) (actual time=2,567.317..36,851.472 rows=21,817 loops=1)

  • Output: applicants.id, applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.last_name, applicants.middle_name, applicants.first_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.association_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted
4. 15.789 36,559.905 ↓ 21,817.0 21,817 1

Nested Loop Left Join (cost=438,045.03..462,692.87 rows=1 width=4,285) (actual time=2,567.246..36,559.905 rows=21,817 loops=1)

  • Output: addmv_ag_activity_types_mv_2.applicant_id, addmv_ag_activity_types_mv.applicant_id, applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.last_name, applicants.middle_name, applicants.first_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.association_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted, applicant_gateway_activities.applicant_id, test_scores_mcat_official_after_jan_31_2015.applicant_id, evaluations.applicant_id
5. 14.695 36,522.299 ↓ 21,817.0 21,817 1

Nested Loop Left Join (cost=438,044.75..462,688.50 rows=1 width=4,289) (actual time=2,567.233..36,522.299 rows=21,817 loops=1)

  • Output: addmv_ag_activity_types_mv_2.applicant_id, addmv_ag_activity_types_mv.applicant_id, applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.last_name, applicants.middle_name, applicants.first_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.association_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted, applicant_gateway_activities.applicant_id, test_scores_mcat_official_after_jan_31_2015.applicant_id, evaluations.applicant_id, applicant_gateway_activities_2.id
6. 0.000 36,442.153 ↓ 21,817.0 21,817 1

Nested Loop Semi Join (cost=438,044.33..462,683.84 rows=1 width=4,330) (actual time=2,567.224..36,442.153 rows=21,817 loops=1)

  • Output: addmv_ag_activity_types_mv_2.applicant_id, addmv_ag_activity_types_mv_2.program_id, addmv_ag_activity_types_mv_2.type_of_activity, addmv_ag_activity_types_mv.applicant_id, applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.last_name, applicants.middle_name, applicants.first_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.association_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted, applicant_gateway_activities.applicant_id, test_scores_mcat_official_after_jan_31_2015.applicant_id, evaluations.applicant_id
7. 329.458 33,471.777 ↓ 14,183.9 1,092,161 1

Nested Loop (cost=438,043.20..461,566.05 rows=77 width=4,338) (actual time=2,566.972..33,471.777 rows=1,092,161 loops=1)

  • Output: addmv_ag_activity_types_mv.applicant_id, applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.last_name, applicants.middle_name, applicants.first_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.association_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted, applicant_gateway_activities.applicant_id, test_scores_mcat_official_after_jan_31_2015.applicant_id, evaluations.applicant_id, addmv_ag_activity_types_mv_2.applicant_id, addmv_ag_activity_types_mv_2.program_id, addmv_ag_activity_types_mv_2.type_of_activity, addmv_ag_activity_types_mv_2.id
  • Join Filter: (applicant_gateway_activities.applicant_id = addmv_ag_activity_types_mv_2.applicant_id)
8. 24,203.306 32,491.859 ↓ 21,682.0 21,682 1

Nested Loop (cost=438,042.64..461,432.09 rows=1 width=4,281) (actual time=2,566.936..32,491.859 rows=21,682 loops=1)

  • Output: addmv_ag_activity_types_mv.applicant_id, applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.last_name, applicants.middle_name, applicants.first_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.association_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted, applicant_gateway_activities.applicant_id, test_scores_mcat_official_after_jan_31_2015.applicant_id, evaluations.applicant_id
  • Join Filter: (applicant_gateway_activities.applicant_id = evaluations.applicant_id)
  • Rows Removed by Join Filter: 110,993,456
9. 6.377 1,721.127 ↓ 48.1 19,722 1

Nested Loop (cost=106,358.52..115,459.48 rows=410 width=4) (actual time=1,116.671..1,721.127 rows=19,722 loops=1)

  • Output: evaluations.applicant_id
10. 5.251 1,537.252 ↓ 48.1 19,722 1

Nested Loop (cost=106,357.95..113,091.13 rows=410 width=8) (actual time=1,116.652..1,537.252 rows=19,722 loops=1)

  • Output: evaluations.cas_evaluator_id, evaluations.applicant_id
11. 20.195 1,355.898 ↓ 40.3 19,567 1

Nested Loop (cost=106,357.52..108,634.62 rows=486 width=16) (actual time=1,116.605..1,355.898 rows=19,567 loops=1)

  • Output: evaluations.cas_evaluator_id, evaluations.id, evaluations.applicant_id, evaluations_1.id
12. 33.424 1,140.033 ↓ 40.3 19,567 1

HashAggregate (cost=106,357.09..106,361.95 rows=486 width=4) (actual time=1,116.559..1,140.033 rows=19,567 loops=1)

  • Output: evaluations_1.id
  • Group Key: evaluations_1.id
13. 561.379 1,106.609 ↓ 40.3 19,567 1

Hash Right Join (cost=39,689.65..106,355.87 rows=486 width=4) (actual time=376.315..1,106.609 rows=19,567 loops=1)

  • Output: evaluations_1.id
  • Hash Cond: (designation_evaluations.evaluation_id = evaluations_1.id)
  • Filter: (((evaluations_1.scope_type)::text = 'cas'::text) OR (((evaluations_1.scope_type)::text = 'program'::text) AND (designation_evaluations.program_id = ANY ('{2564,2565,2566,2567,2568}'::integer[]))))
  • Rows Removed by Filter: 116,483
14. 279.818 279.818 ↑ 1.0 2,821,277 1

Seq Scan on public.designation_evaluations (cost=0.00..54,921.09 rows=2,838,909 width=8) (actual time=0.012..279.818 rows=2,821,277 loops=1)

  • Output: designation_evaluations.id, designation_evaluations.program_id, designation_evaluations.evaluation_id, designation_evaluations.designation_id, designation_evaluations.created_at, designation_evaluations.updated_at, designation_evaluations.association_id, designation_evaluations.identifier, designation_evaluations.applicant_id
15. 39.194 265.412 ↓ 2.6 136,050 1

Hash (cost=39,042.35..39,042.35 rows=51,784 width=12) (actual time=265.412..265.412 rows=136,050 loops=1)

  • Output: evaluations_1.id, evaluations_1.scope_type
  • Buckets: 262,144 (originally 65536) Batches: 1 (originally 1) Memory Usage: 7,894kB
16. 50.002 226.218 ↓ 2.6 136,050 1

Nested Loop (cost=3,991.44..39,042.35 rows=51,784 width=12) (actual time=26.463..226.218 rows=136,050 loops=1)

  • Output: evaluations_1.id, evaluations_1.scope_type
17. 3.589 27.905 ↓ 4.1 5,493 1

HashAggregate (cost=3,991.01..4,004.53 rows=1,352 width=4) (actual time=26.435..27.905 rows=5,493 loops=1)

  • Output: applicants_1.id
  • Group Key: applicants_1.id
18. 3.162 24.316 ↓ 4.1 5,493 1

Nested Loop (cost=368.76..3,987.63 rows=1,352 width=4) (actual time=3.414..24.316 rows=5,493 loops=1)

  • Output: applicants_1.id
19. 2.663 4.669 ↑ 1.1 5,495 1

HashAggregate (cost=368.34..426.43 rows=5,809 width=4) (actual time=3.396..4.669 rows=5,495 loops=1)

  • Output: applicant_designation_details_mv_1.applicant_id
  • Group Key: applicant_designation_details_mv_1.applicant_id
20. 0.660 2.006 ↑ 1.1 5,495 1

Nested Loop (cost=0.71..353.82 rows=5,809 width=4) (actual time=0.055..2.006 rows=5,495 loops=1)

  • Output: applicant_designation_details_mv_1.applicant_id
21. 0.026 0.026 ↓ 1.2 5 1

Index Only Scan using index_user_identity_programs_on_user_identity_id_and_program_id on public.user_identity_programs user_identity_programs_1 (cost=0.29..17.88 rows=4 width=4) (actual time=0.021..0.026 rows=5 loops=1)

  • Output: user_identity_programs_1.user_identity_id, user_identity_programs_1.program_id
  • Index Cond: (user_identity_programs_1.user_identity_id = 2,855)
  • Heap Fetches: 5
22. 1.320 1.320 ↑ 1.3 1,099 5

Index Only Scan using idx_designation_details_on_status_show_program_id_applicant_id on public.applicant_designation_details_mv applicant_designation_details_mv_1 (cost=0.42..69.46 rows=1,452 width=8) (actual time=0.008..0.264 rows=1,099 loops=5)

  • Output: applicant_designation_details_mv_1.status_show, applicant_designation_details_mv_1.program_id, applicant_designation_details_mv_1.applicant_id
  • Index Cond: ((applicant_designation_details_mv_1.status_show = true) AND (applicant_designation_details_mv_1.program_id = user_identity_programs_1.program_id))
  • Filter: applicant_designation_details_mv_1.status_show
  • Heap Fetches: 28
23. 16.485 16.485 ↑ 1.0 1 5,495

Index Scan using applicants_pkey on public.applicants applicants_1 (cost=0.42..0.60 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=5,495)

  • Output: applicants_1.id, applicants_1.ssn, applicants_1.created_at, applicants_1.updated_at, applicants_1.score, applicants_1.identifier, applicants_1.email, applicants_1.last_name, applicants_1.middle_name, applicants_1.first_name, applicants_1.suffix, applicants_1.title, applicants_1.last_refresh, applicants_1.date_added, applicants_1.cas_id, applicants_1.association_id, applicants_1.application_complete, applicants_1.verified, applicants_1.verified_date, applicants_1.professional_pin, applicants_1.match_id, applicants_1.pre_submission_release_authorized, applicants_1.photo_file_name, applicants_1.photo_content_type, applicants_1.photo_file_size, applicants_1.photo_updated_at, applicants_1.id_number, applicants_1.id_number_type, applicants_1.visible_for_advisor, applicants_1.direct_applicant_complete, applicants_1.email_type_id, applicants_1.dentpin, applicants_1.date_submitted
  • Index Cond: (applicants_1.id = applicant_designation_details_mv_1.applicant_id)
  • Filter: (applicants_1.association_id = 6)
  • Rows Removed by Filter: 0
24. 148.311 148.311 ↑ 1.5 25 5,493

Index Scan using index_evaluations_on_applicant_id on public.evaluations evaluations_1 (cost=0.43..25.53 rows=38 width=16) (actual time=0.006..0.027 rows=25 loops=5,493)

  • Output: evaluations_1.id, evaluations_1.barcode, evaluations_1.identifier, evaluations_1.applicant_id, evaluations_1.evaluation_type_id, evaluations_1.association_id, evaluations_1.created_at, evaluations_1.updated_at, evaluations_1.cas_evaluator_id, evaluations_1.organization_id, evaluations_1.received_date, evaluations_1.evaluator_type, evaluations_1.graduation_year, evaluations_1.waiver, evaluations_1.exception_reason, evaluations_1.exception_description, evaluations_1.college_code, evaluations_1.upload_identifier, evaluations_1.authorize, evaluations_1.contact_allowed, evaluations_1.contact_understand, evaluations_1.communication, evaluations_1.critical_thinking, evaluations_1.ethical_behavior, evaluations_1.feedback_reaction, evaluations_1.interpersonal, evaluations_1.leadership, evaluations_1.learning_commitment, evaluations_1.overall, evaluations_1.problem_solving, evaluations_1.psychomotor, evaluations_1.reliability, evaluations_1.stress_management, evaluations_1.time_management, evaluations_1.initiative, evaluations_1.oral_communication, evaluations_1.teamwork, evaluations_1.written_communication, evaluations_1.recommendation, evaluations_1.comment, evaluations_1.adaptivity, evaluations_1.conflict_resolution, evaluations_1.emotional_maturity, evaluations_1.criticism_reaction, evaluations_1.intellectual_ability, evaluations_1.limitations, evaluations_1.patient_interaction, evaluations_1.committee_letter, evaluations_1.time_observed, evaluations_1.capacity_known_other, evaluations_1.social_maturity_rating_id, evaluations_1.motivation_rating_id, evaluations_1.animal_handling_rating_id, evaluations_1.integrity_rating_id, evaluations_1.additional_comments, evaluations_1.communication_rating_id, evaluations_1.emotional_maturity_rating_id, evaluations_1.feedback_reaction_rating_id, evaluations_1.initiative_rating_id, evaluations_1.intellectual_rating_id, evaluations_1.leadership_rating_id, evaluations_1.overall_rating_id, evaluations_1.reliability_rating_id, evaluations_1.teamwork_rating_id, evaluations_1.applicant_interaction_id, evaluations_1.licensed_therapist, evaluations_1.therapist_license_number, evaluations_1.specified_courses, evaluations_1.evaluator_names, evaluations_1.affiliated_organization_names, evaluations_1.graduate_institution, evaluations_1.license_state, evaluations_1.candidates_evaluated_count, evaluations_1.years_known, evaluations_1.months_known, evaluations_1.evaluator_interaction_id, evaluations_1.capacity_known_id, evaluations_1.school_contact_allowed, evaluations_1.judgement, evaluations_1.empathy, evaluations_1.appearance, evaluations_1.status, evaluations_1.scope_type, evaluations_1.written_communication_rating_id, evaluations_1.assertiveness_rating_id, evaluations_1.time_management_rating_id, evaluations_1.peer_communication_rating_id, evaluations_1.problem_solving_rating_id, evaluations_1.patient_interactions_rating_id, evaluations_1.independence_rating_id, evaluations_1.constructive_criticism_rating_id, evaluations_1.professionalism_rating_id, evaluations_1.hours_interaction, evaluations_1.relationship_faculty, evaluations_1.relationship_preceptor, evaluations_1.relationship_employer, evaluations_1.relationship_professional_org, evaluations_1.relationship_other, evaluations_1.written_communication_rating_comments, evaluations_1.oral_communication_rating_comments, evaluations_1.leadership_rating_comments, evaluations_1.assertiveness_rating_comments, evaluations_1.time_management_rating_comments, evaluations_1.peer_communication_rating_comments, evaluations_1.problem_solving_rating_comments, evaluations_1.patient_interactions_rating_comments, evaluations_1.independence_rating_comments, evaluations_1.constructive_criticism_rating_comments, evaluations_1.emotional_maturity_rating_comments, evaluations_1.professionalism_rating_comments, evaluations_1.strengths_description, evaluations_1.improvement_areas_description, evaluations_1.other_observances, evaluations_1.not_sent, evaluations_1.evaluation_status_id, evaluations_1.how_well_known_id, evaluations_1.length_known_id, evaluations_1.dependability_rating_id, evaluations_1.dependability_comments, evaluations_1.clinical_problem_solving_skills_rating_id, evaluations_1.clinical_problem_solving_skills_comments
  • Index Cond: (evaluations_1.applicant_id = applicants_1.id)
25. 195.670 195.670 ↑ 1.0 1 19,567

Index Scan using evaluations_pkey on public.evaluations (cost=0.43..4.67 rows=1 width=12) (actual time=0.009..0.010 rows=1 loops=19,567)

  • Output: evaluations.id, evaluations.barcode, evaluations.identifier, evaluations.applicant_id, evaluations.evaluation_type_id, evaluations.association_id, evaluations.created_at, evaluations.updated_at, evaluations.cas_evaluator_id, evaluations.organization_id, evaluations.received_date, evaluations.evaluator_type, evaluations.graduation_year, evaluations.waiver, evaluations.exception_reason, evaluations.exception_description, evaluations.college_code, evaluations.upload_identifier, evaluations.authorize, evaluations.contact_allowed, evaluations.contact_understand, evaluations.communication, evaluations.critical_thinking, evaluations.ethical_behavior, evaluations.feedback_reaction, evaluations.interpersonal, evaluations.leadership, evaluations.learning_commitment, evaluations.overall, evaluations.problem_solving, evaluations.psychomotor, evaluations.reliability, evaluations.stress_management, evaluations.time_management, evaluations.initiative, evaluations.oral_communication, evaluations.teamwork, evaluations.written_communication, evaluations.recommendation, evaluations.comment, evaluations.adaptivity, evaluations.conflict_resolution, evaluations.emotional_maturity, evaluations.criticism_reaction, evaluations.intellectual_ability, evaluations.limitations, evaluations.patient_interaction, evaluations.committee_letter, evaluations.time_observed, evaluations.capacity_known_other, evaluations.social_maturity_rating_id, evaluations.motivation_rating_id, evaluations.animal_handling_rating_id, evaluations.integrity_rating_id, evaluations.additional_comments, evaluations.communication_rating_id, evaluations.emotional_maturity_rating_id, evaluations.feedback_reaction_rating_id, evaluations.initiative_rating_id, evaluations.intellectual_rating_id, evaluations.leadership_rating_id, evaluations.overall_rating_id, evaluations.reliability_rating_id, evaluations.teamwork_rating_id, evaluations.applicant_interaction_id, evaluations.licensed_therapist, evaluations.therapist_license_number, evaluations.specified_courses, evaluations.evaluator_names, evaluations.affiliated_organization_names, evaluations.graduate_institution, evaluations.license_state, evaluations.candidates_evaluated_count, evaluations.years_known, evaluations.months_known, evaluations.evaluator_interaction_id, evaluations.capacity_known_id, evaluations.school_contact_allowed, evaluations.judgement, evaluations.empathy, evaluations.appearance, evaluations.status, evaluations.scope_type, evaluations.written_communication_rating_id, evaluations.assertiveness_rating_id, evaluations.time_management_rating_id, evaluations.peer_communication_rating_id, evaluations.problem_solving_rating_id, evaluations.patient_interactions_rating_id, evaluations.independence_rating_id, evaluations.constructive_criticism_rating_id, evaluations.professionalism_rating_id, evaluations.hours_interaction, evaluations.relationship_faculty, evaluations.relationship_preceptor, evaluations.relationship_employer, evaluations.relationship_professional_org, evaluations.relationship_other, evaluations.written_communication_rating_comments, evaluations.oral_communication_rating_comments, evaluations.leadership_rating_comments, evaluations.assertiveness_rating_comments, evaluations.time_management_rating_comments, evaluations.peer_communication_rating_comments, evaluations.problem_solving_rating_comments, evaluations.patient_interactions_rating_comments, evaluations.independence_rating_comments, evaluations.constructive_criticism_rating_comments, evaluations.emotional_maturity_rating_comments, evaluations.professionalism_rating_comments, evaluations.strengths_description, evaluations.improvement_areas_description, evaluations.other_observances, evaluations.not_sent, evaluations.evaluation_status_id, evaluations.how_well_known_id, evaluations.length_known_id, evaluations.dependability_rating_id, evaluations.dependability_comments, evaluations.clinical_problem_solving_skills_rating_id, evaluations.clinical_problem_solving_skills_comments
  • Index Cond: (evaluations.id = evaluations_1.id)
26. 176.103 176.103 ↑ 12.0 1 19,567

Index Scan using index_cas_attachments_on_owner_id on public.cas_attachments (cost=0.43..9.05 rows=12 width=4) (actual time=0.008..0.009 rows=1 loops=19,567)

  • Output: cas_attachments.id, cas_attachments.applicant_id, cas_attachments.cas_attachment_type_id, cas_attachments.filename, cas_attachments.url, cas_attachments.uploaded_at, cas_attachments.description, cas_attachments.created_at, cas_attachments.updated_at, cas_attachments.identifier, cas_attachments.scope_type, cas_attachments.owner_id, cas_attachments.owner_type
  • Index Cond: (cas_attachments.owner_id = evaluations.id)
  • Filter: ((cas_attachments.uploaded_at IS NOT NULL) AND ((cas_attachments.owner_type)::text = 'evaluation'::text))
27. 177.498 177.498 ↑ 1.0 1 19,722

Index Scan using evaluators_pkey on public.evaluators (cost=0.57..5.77 rows=1 width=4) (actual time=0.008..0.009 rows=1 loops=19,722)

  • Output: evaluators.id, evaluators.phone, evaluators.title, evaluators.address, evaluators.city, evaluators.state, evaluators.zip, evaluators.country, evaluators.email, evaluators.association_id, evaluators.identifier, evaluators.created_at, evaluators.updated_at, evaluators.occupation_name, evaluators.institution_name, evaluators.first_name, evaluators.middle_initial, evaluators.last_name, evaluators.address_2, evaluators.type, evaluators.occupation_id, evaluators.evaluator_type, evaluators.address_3, evaluators.suffix, evaluators.department, evaluators.college_base_id, evaluators.number_of_candidates, evaluators.middle_name, evaluators.salutation, evaluators.veterinarian, evaluators.phone_type_id, evaluators.organization_name
  • Index Cond: (evaluators.id = evaluations.cas_evaluator_id)
  • Filter: ((evaluators.type)::text = 'CasEvaluator'::text)
28. 5,125.070 6,567.426 ↓ 562.9 5,629 19,722

Materialize (cost=331,684.13..345,911.13 rows=10 width=4,277) (actual time=0.066..0.333 rows=5,629 loops=19,722)

  • Output: addmv_ag_activity_types_mv.applicant_id, applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.last_name, applicants.middle_name, applicants.first_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.association_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted, applicant_gateway_activities.applicant_id, test_scores_mcat_official_after_jan_31_2015.applicant_id
29. 3.209 1,442.356 ↓ 562.9 5,629 1

Nested Loop (cost=331,684.13..345,911.08 rows=10 width=4,277) (actual time=1,301.422..1,442.356 rows=5,629 loops=1)

  • Output: addmv_ag_activity_types_mv.applicant_id, applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.last_name, applicants.middle_name, applicants.first_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.association_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted, applicant_gateway_activities.applicant_id, test_scores_mcat_official_after_jan_31_2015.applicant_id
  • Join Filter: (applicant_gateway_activities.applicant_id = test_scores_mcat_official_after_jan_31_2015.applicant_id)
30. 1.081 1,424.531 ↓ 609.0 3,654 1

Nested Loop Left Join (cost=331,683.70..345,880.91 rows=6 width=4,273) (actual time=1,301.398..1,424.531 rows=3,654 loops=1)

  • Output: addmv_ag_activity_types_mv.applicant_id, applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.last_name, applicants.middle_name, applicants.first_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.association_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted, applicant_gateway_activities.applicant_id
31. 2.855 1,419.796 ↓ 609.0 3,654 1

Nested Loop (cost=331,683.43..345,854.66 rows=6 width=4,277) (actual time=1,301.373..1,419.796 rows=3,654 loops=1)

  • Output: addmv_ag_activity_types_mv.applicant_id, applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.last_name, applicants.middle_name, applicants.first_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.association_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted, applicant_gateway_activities.applicant_id, applicant_gateway_activities.id
  • Join Filter: (applicant_gateway_activities.applicant_id = applicants.id)
32. 44.943 1,405.973 ↓ 146.2 3,656 1

Hash Join (cost=331,683.01..345,738.43 rows=25 width=12) (actual time=1,301.348..1,405.973 rows=3,656 loops=1)

  • Output: addmv_ag_activity_types_mv.applicant_id, applicant_gateway_activities.applicant_id, applicant_gateway_activities.id
  • Hash Cond: ((applicant_gateway_activities.program_id = addmv_ag_activity_types_mv.program_id) AND ((applicant_gateway_activities.type)::text = (addmv_ag_activity_types_mv.type_of_activity)::text) AND (applicant_gateway_activities.applicant_id = addmv_ag_activity_types_mv.applicant_id))
33. 61.258 61.258 ↓ 1.0 263,175 1

Seq Scan on public.applicant_gateway_activities (cost=0.00..10,114.52 rows=262,710 width=56) (actual time=0.008..61.258 rows=263,175 loops=1)

  • Output: applicant_gateway_activities.id, applicant_gateway_activities.applicant_id, applicant_gateway_activities.program_id, applicant_gateway_activities.type, applicant_gateway_activities.enabled_date, applicant_gateway_activities.completed_date, applicant_gateway_activities.created_at, applicant_gateway_activities.updated_at, applicant_gateway_activities.expiration_date, applicant_gateway_activities.disabled_date, applicant_gateway_activities.rolling_date, applicant_gateway_activities.ignore_deadline_date
  • Filter: (applicant_gateway_activities.completed_date IS NOT NULL)
  • Rows Removed by Filter: 110,577
34. 2.104 1,299.772 ↑ 1.7 5,512 1

Hash (cost=331,514.25..331,514.25 rows=9,643 width=49) (actual time=1,299.772..1,299.772 rows=5,512 loops=1)

  • Output: addmv_ag_activity_types_mv.applicant_id, addmv_ag_activity_types_mv.program_id, addmv_ag_activity_types_mv.type_of_activity
  • Buckets: 16,384 Batches: 1 Memory Usage: 613kB
35. 3.327 1,297.668 ↑ 1.7 5,512 1

Nested Loop (cost=257,722.48..331,514.25 rows=9,643 width=49) (actual time=1,282.248..1,297.668 rows=5,512 loops=1)

  • Output: addmv_ag_activity_types_mv.applicant_id, addmv_ag_activity_types_mv.program_id, addmv_ag_activity_types_mv.type_of_activity
36. 2.693 1,283.317 ↑ 1.7 5,512 1

HashAggregate (cost=257,722.04..257,818.47 rows=9,643 width=8) (actual time=1,282.205..1,283.317 rows=5,512 loops=1)

  • Output: addmv_ag_activity_types_mv_1.id
  • Group Key: addmv_ag_activity_types_mv_1.id
37. 1.108 1,280.624 ↑ 1.7 5,512 1

Hash Left Join (cost=15,727.62..257,697.94 rows=9,643 width=8) (actual time=145.714..1,280.624 rows=5,512 loops=1)

  • Output: addmv_ag_activity_types_mv_1.id
  • Hash Cond: (applicant_gateway_activities_1.id = applicant_gateway_offers_1.applicant_gateway_activity_id)
38. 21.354 1,279.091 ↑ 1.7 5,512 1

Hash Left Join (cost=15,671.10..257,604.94 rows=9,643 width=12) (actual time=145.260..1,279.091 rows=5,512 loops=1)

  • Output: addmv_ag_activity_types_mv_1.id, applicant_gateway_activities_1.id
  • Hash Cond: (((addmv_ag_activity_types_mv_1.type_of_activity)::text = (applicant_gateway_activities_1.type)::text) AND (addmv_ag_activity_types_mv_1.applicant_id = applicant_gateway_activities_1.applicant_id) AND (addmv_ag_activity_types_mv_1.program_id = applicant_gateway_activities_1.program_id))
39. 1,113.998 1,113.998 ↑ 1.7 5,512 1

Seq Scan on public.addmv_ag_activity_types_mv addmv_ag_activity_types_mv_1 (cost=0.00..236,850.37 rows=9,643 width=57) (actual time=0.213..1,113.998 rows=5,512 loops=1)

  • Output: addmv_ag_activity_types_mv_1.applicant_id, addmv_ag_activity_types_mv_1.program_id, addmv_ag_activity_types_mv_1.type_of_activity, addmv_ag_activity_types_mv_1.id
  • Filter: (((addmv_ag_activity_types_mv_1.type_of_activity)::text = 'ApplicantGateway::SupplementalApplicationActivity'::text) AND (addmv_ag_activity_types_mv_1.program_id = ANY ('{2564,2565,2566,2567,2568}'::integer[])))
  • Rows Removed by Filter: 6,571,177
40. 63.892 143.739 ↓ 1.0 170,371 1

Hash (cost=11,048.90..11,048.90 rows=169,497 width=56) (actual time=143.739..143.739 rows=170,371 loops=1)

  • Output: applicant_gateway_activities_1.applicant_id, applicant_gateway_activities_1.program_id, applicant_gateway_activities_1.type, applicant_gateway_activities_1.id
  • Buckets: 262,144 Batches: 2 Memory Usage: 10,081kB
41. 79.847 79.847 ↓ 1.0 170,371 1

Seq Scan on public.applicant_gateway_activities applicant_gateway_activities_1 (cost=0.00..11,048.90 rows=169,497 width=56) (actual time=0.010..79.847 rows=170,371 loops=1)

  • Output: applicant_gateway_activities_1.applicant_id, applicant_gateway_activities_1.program_id, applicant_gateway_activities_1.type, applicant_gateway_activities_1.id
  • Filter: ((applicant_gateway_activities_1.type)::text = 'ApplicantGateway::SupplementalApplicationActivity'::text)
  • Rows Removed by Filter: 203,381
42. 0.180 0.425 ↑ 1.0 1,223 1

Hash (cost=41.23..41.23 rows=1,223 width=4) (actual time=0.425..0.425 rows=1,223 loops=1)

  • Output: applicant_gateway_offers_1.applicant_gateway_activity_id
  • Buckets: 2,048 Batches: 1 Memory Usage: 59kB
43. 0.245 0.245 ↑ 1.0 1,223 1

Seq Scan on public.applicant_gateway_offers applicant_gateway_offers_1 (cost=0.00..41.23 rows=1,223 width=4) (actual time=0.007..0.245 rows=1,223 loops=1)

  • Output: applicant_gateway_offers_1.applicant_gateway_activity_id
44. 11.024 11.024 ↑ 1.0 1 5,512

Index Scan using addmv_ag_activity_types_mv_pkey on public.addmv_ag_activity_types_mv (cost=0.43..7.63 rows=1 width=57) (actual time=0.002..0.002 rows=1 loops=5,512)

  • Output: addmv_ag_activity_types_mv.id, addmv_ag_activity_types_mv.designation_id, addmv_ag_activity_types_mv.program_id, addmv_ag_activity_types_mv.applicant_id, addmv_ag_activity_types_mv.organization_id, addmv_ag_activity_types_mv.activity_type_id, addmv_ag_activity_types_mv.type_of_activity
  • Index Cond: (addmv_ag_activity_types_mv.id = addmv_ag_activity_types_mv_1.id)
45. 10.968 10.968 ↑ 1.0 1 3,656

Index Scan using applicants_pkey on public.applicants (cost=0.42..4.64 rows=1 width=4,265) (actual time=0.003..0.003 rows=1 loops=3,656)

  • Output: applicants.id, applicants.ssn, applicants.created_at, applicants.updated_at, applicants.score, applicants.identifier, applicants.email, applicants.last_name, applicants.middle_name, applicants.first_name, applicants.suffix, applicants.title, applicants.last_refresh, applicants.date_added, applicants.cas_id, applicants.association_id, applicants.application_complete, applicants.verified, applicants.verified_date, applicants.professional_pin, applicants.match_id, applicants.pre_submission_release_authorized, applicants.photo_file_name, applicants.photo_content_type, applicants.photo_file_size, applicants.photo_updated_at, applicants.id_number, applicants.id_number_type, applicants.visible_for_advisor, applicants.direct_applicant_complete, applicants.email_type_id, applicants.dentpin, applicants.date_submitted
  • Index Cond: (applicants.id = addmv_ag_activity_types_mv.applicant_id)
  • Filter: (applicants.association_id = 6)
  • Rows Removed by Filter: 0
46. 3.654 3.654 ↓ 0.0 0 3,654

Index Only Scan using index_applicant_gateway_offers_on_applicant_gateway_activity_id on public.applicant_gateway_offers (cost=0.28..4.36 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=3,654)

  • Output: applicant_gateway_offers.applicant_gateway_activity_id
  • Index Cond: (applicant_gateway_offers.applicant_gateway_activity_id = applicant_gateway_activities.id)
  • Heap Fetches: 0
47. 14.616 14.616 ↑ 1.0 2 3,654

Index Scan using idx_test_scores_mcat_official_after_jan_31_2015_on_applicant_id on public.test_scores_mcat_official_after_jan_31_2015 (cost=0.42..5.00 rows=2 width=4) (actual time=0.003..0.004 rows=2 loops=3,654)

  • Output: test_scores_mcat_official_after_jan_31_2015.id, test_scores_mcat_official_after_jan_31_2015.aamc_id_number, test_scores_mcat_official_after_jan_31_2015.test_id, test_scores_mcat_official_after_jan_31_2015.chemical_and_physical, test_scores_mcat_official_after_jan_31_2015.analysis_and_reasoning, test_scores_mcat_official_after_jan_31_2015.biological_and_biochemical, test_scores_mcat_official_after_jan_31_2015.behavior, test_scores_mcat_official_after_jan_31_2015.total, test_scores_mcat_official_after_jan_31_2015.overall_result, test_scores_mcat_official_after_jan_31_2015.chemical_and_physical_percentile, test_scores_mcat_official_after_jan_31_2015.analysis_and_reasoning_percentile, test_scores_mcat_official_after_jan_31_2015.biological_and_biochemical_percentile, test_scores_mcat_official_after_jan_31_2015.behavior_percentile, test_scores_mcat_official_after_jan_31_2015.total_percentile, test_scores_mcat_official_after_jan_31_2015.chemical_and_physical_low_band, test_scores_mcat_official_after_jan_31_2015.chemical_and_physical_high_band, test_scores_mcat_official_after_jan_31_2015.analysis_and_reasoning_low_band, test_scores_mcat_official_after_jan_31_2015.analysis_and_reasoning_high_band, test_scores_mcat_official_after_jan_31_2015.biological_and_biochemical_low_band, test_scores_mcat_official_after_jan_31_2015.biological_and_biochemical_high_band, test_scores_mcat_official_after_jan_31_2015.behavior_low_band, test_scores_mcat_official_after_jan_31_2015.behavior_high_band, test_scores_mcat_official_after_jan_31_2015.total_low_band, test_scores_mcat_official_after_jan_31_2015.total_high_band, test_scores_mcat_official_after_jan_31_2015.created_at, test_scores_mcat_official_after_jan_31_2015.updated_at, test_scores_mcat_official_after_jan_31_2015.mcat_graph_document_id, test_scores_mcat_official_after_jan_31_2015.taken_on, test_scores_mcat_official_after_jan_31_2015.received_on, test_scores_mcat_official_after_jan_31_2015.applicant_id, test_scores_mcat_official_after_jan_31_2015.percentile_rank_effective_date, test_scores_mcat_official_after_jan_31_2015.score_status_id
  • Index Cond: (test_scores_mcat_official_after_jan_31_2015.applicant_id = addmv_ag_activity_types_mv.applicant_id)
  • Filter: (test_scores_mcat_official_after_jan_31_2015.total IS NOT NULL)
48. 650.460 650.460 ↑ 1.5 50 21,682

Index Scan using idx_ag_actvt_typs_mv_on_app_id_prog_id_typ_actvt_actvt_typ_id on public.addmv_ag_activity_types_mv addmv_ag_activity_types_mv_2 (cost=0.56..133.00 rows=77 width=57) (actual time=0.010..0.030 rows=50 loops=21,682)

  • Output: addmv_ag_activity_types_mv_2.id, addmv_ag_activity_types_mv_2.designation_id, addmv_ag_activity_types_mv_2.program_id, addmv_ag_activity_types_mv_2.applicant_id, addmv_ag_activity_types_mv_2.organization_id, addmv_ag_activity_types_mv_2.activity_type_id, addmv_ag_activity_types_mv_2.type_of_activity
  • Index Cond: ((addmv_ag_activity_types_mv_2.applicant_id = addmv_ag_activity_types_mv.applicant_id) AND (addmv_ag_activity_types_mv_2.activity_type_id IS NOT NULL))
49. 1,048.527 3,276.483 ↓ 0.0 0 1,092,161

Nested Loop Left Join (cost=1.13..14.34 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1,092,161)

  • Output: addmv_ag_activity_types_mv_3.id
50. 0.000 2,184.322 ↓ 0.0 0 1,092,161

Nested Loop Left Join (cost=0.85..9.96 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=1,092,161)

  • Output: addmv_ag_activity_types_mv_3.id, applicant_gateway_activities_3.id
51. 2,184.322 2,184.322 ↓ 0.0 0 1,092,161

Index Scan using addmv_ag_activity_types_mv_pkey on public.addmv_ag_activity_types_mv addmv_ag_activity_types_mv_3 (cost=0.43..4.69 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=1,092,161)

  • Output: addmv_ag_activity_types_mv_3.id, addmv_ag_activity_types_mv_3.designation_id, addmv_ag_activity_types_mv_3.program_id, addmv_ag_activity_types_mv_3.applicant_id, addmv_ag_activity_types_mv_3.organization_id, addmv_ag_activity_types_mv_3.activity_type_id, addmv_ag_activity_types_mv_3.type_of_activity
  • Index Cond: (addmv_ag_activity_types_mv_3.id = addmv_ag_activity_types_mv_2.id)
  • Filter: (((addmv_ag_activity_types_mv_3.type_of_activity)::text = 'ApplicantGateway::DocumentUploadActivity'::text) AND (addmv_ag_activity_types_mv_3.program_id = ANY ('{2564,2565,2566,2567,2568}'::integer[])))
  • Rows Removed by Filter: 1
52. 152.719 152.719 ↑ 1.0 1 21,817

Index Scan using applicant_gateway_activities_unique on public.applicant_gateway_activities applicant_gateway_activities_3 (cost=0.42..5.26 rows=1 width=56) (actual time=0.007..0.007 rows=1 loops=21,817)

  • Output: applicant_gateway_activities_3.id, applicant_gateway_activities_3.applicant_id, applicant_gateway_activities_3.program_id, applicant_gateway_activities_3.type, applicant_gateway_activities_3.enabled_date, applicant_gateway_activities_3.completed_date, applicant_gateway_activities_3.created_at, applicant_gateway_activities_3.updated_at, applicant_gateway_activities_3.expiration_date, applicant_gateway_activities_3.disabled_date, applicant_gateway_activities_3.rolling_date, applicant_gateway_activities_3.ignore_deadline_date
  • Index Cond: ((applicant_gateway_activities_3.applicant_id = addmv_ag_activity_types_mv_3.applicant_id) AND (applicant_gateway_activities_3.program_id = addmv_ag_activity_types_mv_3.program_id) AND ((applicant_gateway_activities_3.type)::text = (addmv_ag_activity_types_mv_3.type_of_activity)::text) AND ((applicant_gateway_activities_3.type)::text = 'ApplicantGateway::DocumentUploadActivity'::text))
53. 43.634 43.634 ↓ 0.0 0 21,817

Index Only Scan using index_applicant_gateway_offers_on_applicant_gateway_activity_id on public.applicant_gateway_offers applicant_gateway_offers_3 (cost=0.28..4.36 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=21,817)

  • Output: applicant_gateway_offers_3.applicant_gateway_activity_id
  • Index Cond: (applicant_gateway_offers_3.applicant_gateway_activity_id = applicant_gateway_activities_3.id)
  • Heap Fetches: 0
54. 65.451 65.451 ↑ 1.0 1 21,817

Index Scan using applicant_gateway_activities_unique on public.applicant_gateway_activities applicant_gateway_activities_2 (cost=0.42..4.65 rows=1 width=56) (actual time=0.002..0.003 rows=1 loops=21,817)

  • Output: applicant_gateway_activities_2.id, applicant_gateway_activities_2.applicant_id, applicant_gateway_activities_2.program_id, applicant_gateway_activities_2.type, applicant_gateway_activities_2.enabled_date, applicant_gateway_activities_2.completed_date, applicant_gateway_activities_2.created_at, applicant_gateway_activities_2.updated_at, applicant_gateway_activities_2.expiration_date, applicant_gateway_activities_2.disabled_date, applicant_gateway_activities_2.rolling_date, applicant_gateway_activities_2.ignore_deadline_date
  • Index Cond: ((applicant_gateway_activities_2.applicant_id = addmv_ag_activity_types_mv_2.applicant_id) AND (applicant_gateway_activities_2.program_id = addmv_ag_activity_types_mv_2.program_id) AND ((applicant_gateway_activities_2.type)::text = (addmv_ag_activity_types_mv_2.type_of_activity)::text))
55. 21.817 21.817 ↓ 0.0 0 21,817

Index Only Scan using index_applicant_gateway_offers_on_applicant_gateway_activity_id on public.applicant_gateway_offers applicant_gateway_offers_2 (cost=0.28..4.36 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=21,817)

  • Output: applicant_gateway_offers_2.applicant_gateway_activity_id
  • Index Cond: (applicant_gateway_offers_2.applicant_gateway_activity_id = applicant_gateway_activities_2.id)
  • Heap Fetches: 0
56. 21.798 261.804 ↑ 1.0 1 21,817

Hash Semi Join (cost=18.36..33.06 rows=1 width=4) (actual time=0.012..0.012 rows=1 loops=21,817)

  • Output: applicant_designation_details_mv.applicant_id
  • Hash Cond: (applicant_designation_details_mv.program_id = user_identity_programs.program_id)
57. 239.987 239.987 ↑ 3.0 3 21,817

Index Scan using index_addw_on_applicant_id on public.applicant_designation_details_mv (cost=0.42..15.11 rows=9 width=8) (actual time=0.007..0.011 rows=3 loops=21,817)

  • Output: applicant_designation_details_mv.id, applicant_designation_details_mv.identifier, applicant_designation_details_mv.school_code, applicant_designation_details_mv.school_name, applicant_designation_details_mv.school_state, applicant_designation_details_mv.deadline, applicant_designation_details_mv.school_short, applicant_designation_details_mv.school_abbr, applicant_designation_details_mv.format, applicant_designation_details_mv.no_lors, applicant_designation_details_mv.comments, applicant_designation_details_mv.local_status_id, applicant_designation_details_mv.applicant_id, applicant_designation_details_mv.previously_applied, applicant_designation_details_mv.mailed, applicant_designation_details_mv.mailed_date, applicant_designation_details_mv.decision_id, applicant_designation_details_mv.application_status_id, applicant_designation_details_mv.program_id, applicant_designation_details_mv.date_locked, applicant_designation_details_mv.association_id, applicant_designation_details_mv.designation_submitted, applicant_designation_details_mv.application_status_last_updated, applicant_designation_details_mv.decision_last_updated, applicant_designation_details_mv.decision_last_updated_by_id, applicant_designation_details_mv.local_status_last_updated, applicant_designation_details_mv.local_status_last_updated_by_id, applicant_designation_details_mv.verified_date, applicant_designation_details_mv.complete_date, applicant_designation_details_mv.academic_update_status_id, applicant_designation_details_mv.academic_update_started_date, applicant_designation_details_mv.academic_update_submitted_date, applicant_designation_details_mv.academic_update_verified_date, applicant_designation_details_mv.first_complete_date, applicant_designation_details_mv.rank, applicant_designation_details_mv.early_decision_id, applicant_designation_details_mv.verified_datetime, applicant_designation_details_mv.area_of_interest_id, applicant_designation_details_mv.department_id, applicant_designation_details_mv.designation_term_id, applicant_designation_details_mv.application_type_id, applicant_designation_details_mv.created_at, applicant_designation_details_mv.updated_at, applicant_designation_details_mv.enrollment_year, applicant_designation_details_mv.decision_last_updated_by_user_id, applicant_designation_details_mv.local_status_last_updated_by_user_id, applicant_designation_details_mv.designation_degree_id, applicant_designation_details_mv.organization_institution_number, applicant_designation_details_mv.campus_id, applicant_designation_details_mv.postmatch_consideration, applicant_designation_details_mv.program_organization_id, applicant_designation_details_mv.program_name, applicant_designation_details_mv.program_created_at, applicant_designation_details_mv.program_updated_at, applicant_designation_details_mv.program_identifier, applicant_designation_details_mv.program_soft_deadline, applicant_designation_details_mv.program_hard_deadline, applicant_designation_details_mv.program_deadline_display, applicant_designation_details_mv.program_notification, applicant_designation_details_mv.program_active, applicant_designation_details_mv.program_level_id, applicant_designation_details_mv.program_association_id, applicant_designation_details_mv.program_program_level, applicant_designation_details_mv.program_school_abbr, applicant_designation_details_mv.program_graduate, applicant_designation_details_mv.program_state, applicant_designation_details_mv.program_track, applicant_designation_details_mv.program_label, applicant_designation_details_mv.program_degree_id, applicant_designation_details_mv.program_program_type_id, applicant_designation_details_mv.program_type, applicant_designation_details_mv.program_pending_processing_by_liaison, applicant_designation_details_mv.program_open_date, applicant_designation_details_mv.program_city, applicant_designation_details_mv.program_zip_code, applicant_designation_details_mv.program_designatable, applicant_designation_details_mv.program_program_delivery_id, applicant_designation_details_mv.program_program_track_id, applicant_designation_details_mv.program_settings_transfer_code, applicant_designation_details_mv.program_program_term_id, applicant_designation_details_mv.program_start_term_id, applicant_designation_details_mv.program_department, applicant_designation_details_mv.program_concentration, applicant_designation_details_mv.program_start_year, applicant_designation_details_mv.program_campus, applicant_designation_details_mv.program_application_type, applicant_designation_details_mv.program_delivery, applicant_designation_details_mv.status_title, applicant_designation_details_mv.status_show, applicant_designation_details_mv.program_unique_identifier, applicant_designation_details_mv.alternate_program, applicant_designation_details_mv.program_second_bachelor_degree, applicant_designation_details_mv.program_associate_degree_for_transfer, applicant_designation_details_mv.program_alt_program_opt_out, applicant_designation_details_mv.program_post_baccalaureate_certificate, applicant_designation_details_mv.program_teaching_credentials, applicant_designation_details_mv.program_first_time_freshman, applicant_designation_details_mv.program_first_time_freshman_with_coursework, applicant_designation_details_mv.program_impacted, applicant_designation_details_mv.program_international_students, applicant_designation_details_mv.program_international_students_deadline, applicant_designation_details_mv.program_lower_division_transfer, applicant_designation_details_mv.program_masters_graduate_or_higher, applicant_designation_details_mv.program_mokey, applicant_designation_details_mv.program_returning_students, applicant_designation_details_mv.program_returning_students_deadline, applicant_designation_details_mv.program_state_eligibility, applicant_designation_details_mv.program_upper_division_transfer, applicant_designation_details_mv.program_veterans_deadline, applicant_designation_details_mv.program_veterans, applicant_designation_details_mv.program_requires_alternate, applicant_designation_details_mv.program_ca_promise, applicant_designation_details_mv.added_date, applicant_designation_details_mv.program_degree_level, applicant_designation_details_mv.invitation_code, applicant_designation_details_mv.designation_effective_date, applicant_designation_details_mv.designation_projected_graduation_date, applicant_designation_details_mv.accepted_program_type_id, applicant_designation_details_mv.last_exported_at, applicant_designation_details_mv.alternate_program_available_id
  • Index Cond: (applicant_designation_details_mv.applicant_id = addmv_ag_activity_types_mv_2.applicant_id)
  • Filter: applicant_designation_details_mv.status_show
  • Rows Removed by Filter: 0
58. 0.005 0.019 ↓ 1.2 5 1

Hash (cost=17.88..17.88 rows=4 width=4) (actual time=0.019..0.019 rows=5 loops=1)

  • Output: user_identity_programs.program_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
59. 0.014 0.014 ↓ 1.2 5 1

Index Only Scan using index_user_identity_programs_on_user_identity_id_and_program_id on public.user_identity_programs (cost=0.29..17.88 rows=4 width=4) (actual time=0.013..0.014 rows=5 loops=1)

  • Output: user_identity_programs.program_id
  • Index Cond: (user_identity_programs.user_identity_id = 2,855)
  • Heap Fetches: 5
Planning time : 16.563 ms
Execution time : 36,997.210 ms