explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uhf1 : ag index

Settings
# exclusive inclusive rows x rows loops node
1. 16.381 35,642.198 ↓ 3,636.0 3,636 1

Unique (cost=238,529.05..238,529.14 rows=1 width=4,265) (actual time=35,623.144..35,642.198 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. 121.458 35,625.817 ↓ 21,817.0 21,817 1

Sort (cost=238,529.05..238,529.06 rows=1 width=4,265) (actual time=35,623.140..35,625.817 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. 23.590 35,504.359 ↓ 21,817.0 21,817 1

Nested Loop Semi Join (cost=213,851.35..238,529.04 rows=1 width=4,265) (actual time=1,449.674..35,504.359 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. 13.065 35,218.965 ↓ 21,817.0 21,817 1

Nested Loop Left Join (cost=213,832.99..238,481.26 rows=1 width=4,285) (actual time=1,449.601..35,218.965 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. 15.922 35,184.083 ↓ 21,817.0 21,817 1

Nested Loop Left Join (cost=213,832.71..238,476.89 rows=1 width=4,289) (actual time=1,449.590..35,184.083 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 35,102.710 ↓ 21,817.0 21,817 1

Nested Loop Semi Join (cost=213,832.29..238,472.23 rows=1 width=4,330) (actual time=1,449.582..35,102.710 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. 322.555 32,114.976 ↓ 14,183.9 1,092,161 1

Nested Loop (cost=213,831.16..237,354.01 rows=77 width=4,338) (actual time=1,449.335..32,114.976 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,358.675 31,141.961 ↓ 21,682.0 21,682 1

Nested Loop (cost=213,830.60..237,220.04 rows=1 width=4,281) (actual time=1,449.300..31,141.961 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. 15.824 1,675.288 ↓ 48.1 19,722 1

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

  • Output: evaluations.applicant_id
10. 14.796 1,501.688 ↓ 48.1 19,722 1

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

  • Output: evaluations.cas_evaluator_id, evaluations.applicant_id
11. 22.186 1,330.356 ↓ 40.3 19,567 1

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

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

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

  • Output: evaluations_1.id
  • Group Key: evaluations_1.id
13. 564.062 1,099.029 ↓ 40.3 19,567 1

Hash Right Join (cost=39,689.65..106,355.87 rows=486 width=4) (actual time=359.516..1,099.029 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. 276.560 276.560 ↑ 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..276.560 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. 37.782 258.407 ↓ 2.6 136,050 1

Hash (cost=39,042.35..39,042.35 rows=51,784 width=12) (actual time=258.407..258.407 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. 57.799 220.625 ↓ 2.6 136,050 1

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

  • Output: evaluations_1.id, evaluations_1.scope_type
17. 3.181 25.501 ↓ 4.1 5,493 1

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

  • Output: applicants_1.id
  • Group Key: applicants_1.id
18. 1.642 22.320 ↓ 4.1 5,493 1

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

  • Output: applicants_1.id
19. 2.374 4.193 ↑ 1.1 5,495 1

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

  • Output: applicant_designation_details_mv_1.applicant_id
  • Group Key: applicant_designation_details_mv_1.applicant_id
20. 0.612 1.819 ↑ 1.1 5,495 1

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

  • Output: applicant_designation_details_mv_1.applicant_id
21. 0.017 0.017 ↓ 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.016..0.017 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.190 1.190 ↑ 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.007..0.238 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. 137.325 137.325 ↑ 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.025 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. 176.103 176.103 ↑ 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.009 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. 156.536 156.536 ↑ 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.008 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. 157.776 157.776 ↑ 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.008 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. 4,775.781 5,107.998 ↓ 562.9 5,629 19,722

Materialize (cost=107,472.08..121,699.09 rows=10 width=4,277) (actual time=0.010..0.259 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.865 332.217 ↓ 562.9 5,629 1

Nested Loop (cost=107,472.08..121,699.04 rows=10 width=4,277) (actual time=184.939..332.217 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.355 313.736 ↓ 609.0 3,654 1

Nested Loop Left Join (cost=107,471.66..121,668.87 rows=6 width=4,273) (actual time=184.916..313.736 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. 3.551 308.727 ↓ 609.0 3,654 1

Nested Loop (cost=107,471.38..121,642.62 rows=6 width=4,277) (actual time=184.895..308.727 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. 47.897 294.208 ↓ 146.2 3,656 1

Hash Join (cost=107,470.96..121,526.38 rows=25 width=12) (actual time=184.869..294.208 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. 63.006 63.006 ↓ 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..63.006 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. 1.890 183.305 ↑ 1.7 5,512 1

Hash (cost=107,303.56..107,303.56 rows=9,566 width=49) (actual time=183.305..183.305 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. 2.862 181.415 ↑ 1.7 5,512 1

Nested Loop (cost=34,047.97..107,303.56 rows=9,566 width=49) (actual time=166.493..181.415 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.529 167.529 ↑ 1.7 5,512 1

HashAggregate (cost=34,047.54..34,143.20 rows=9,566 width=8) (actual time=166.465..167.529 rows=5,512 loops=1)

  • Output: addmv_ag_activity_types_mv_1.id
  • Group Key: addmv_ag_activity_types_mv_1.id
37. 0.865 165.000 ↑ 1.7 5,512 1

Hash Left Join (cost=15,728.04..34,023.62 rows=9,566 width=8) (actual time=142.849..165.000 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. 19.880 163.744 ↑ 1.7 5,512 1

Hash Left Join (cost=15,671.52..33,930.92 rows=9,566 width=12) (actual time=142.434..163.744 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. 2.597 2.597 ↑ 1.7 5,512 1

Index Scan using addmv_activity_type_program_id_supp_app on public.addmv_ag_activity_types_mv addmv_ag_activity_types_mv_1 (cost=0.42..13,204.06 rows=9,566 width=57) (actual time=0.094..2.597 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
  • Index Cond: (addmv_ag_activity_types_mv_1.program_id = ANY ('{2564,2565,2566,2567,2568}'::integer[]))
40. 61.960 141.267 ↓ 1.0 170,371 1

Hash (cost=11,048.90..11,048.90 rows=169,497 width=56) (actual time=141.267..141.267 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.307 79.307 ↓ 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.009..79.307 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.174 0.391 ↑ 1.0 1,223 1

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

  • Output: applicant_gateway_offers_1.applicant_gateway_activity_id
  • Buckets: 2,048 Batches: 1 Memory Usage: 59kB
43. 0.217 0.217 ↑ 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.006..0.217 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.64 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.009..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.97 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.799 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.004 0.018 ↓ 1.2 5 1

Hash (cost=17.88..17.88 rows=4 width=4) (actual time=0.018..0.018 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.012..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 : 21.613 ms
Execution time : 35,643.963 ms