explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bl3N

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,820,373.72..58,070,265,060.80 rows=72,440,891,424 width=10,844) (actual rows= loops=)

  • Hash Cond: (this_.appln_id = chngreport6_.appln_id)
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,820,032.71..3,421,872,943.79 rows=635,446,416 width=10,764) (actual rows= loops=)

  • Hash Cond: (applnattrs27_.prsn_name_id = applnattrs32_.prsn_name_id)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=415,034.21..482,676,424.29 rows=635,446,416 width=10,683) (actual rows= loops=)

  • Hash Cond: (this_.appln_id = applngatin1_.appln_id)
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=409,867.14..5,884,331.22 rows=404,228 width=10,586) (actual rows= loops=)

  • Hash Cond: (this_.appln_id = spclplanen4_.appln_id)
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=409,825.64..5,379,004.71 rows=404,228 width=10,310) (actual rows= loops=)

  • Hash Cond: (this_.appln_id = applcaseco5_.appln_id)
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=409,608.20..5,071,022.78 rows=9,187 width=10,163) (actual rows= loops=)

  • Hash Cond: (this_.appln_id = applnattrs3_.appln_id)
7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=409,040.21..5,058,971.03 rows=9,187 width=9,224) (actual rows= loops=)

  • Join Filter: (this_.appln_id = personmbrs2_.appln_id)
8. 0.000 0.000 ↓ 0.0

Index Scan using ix_t_appln on t_appln this_ (cost=87.00..98.00 rows=1 width=183) (actual rows= loops=)

  • Index Cond: (appln_id = '2647950'::numeric)
9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=408,953.21..5,049,686.03 rows=9,187 width=9,041) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=408,867.21..4,153,907.59 rows=9,187 width=8,905) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=408,753.21..2,377,986.32 rows=892 width=8,816) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=408,640.21..1,671,156.93 rows=892 width=8,465) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=408,553.21..1,579,005.75 rows=892 width=8,397) (actual rows= loops=)

  • Merge Cond: (personmbrs2_.prsn_mbrsh_id = personmbrs14_.prsn_mbrsh_id)
14. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=408,523.71..1,577,097.40 rows=892 width=8,253) (actual rows= loops=)

  • Merge Cond: (personmbrs2_.prsn_mbrsh_id = personelgt10_.prsn_mbrsh_id)
15. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=408,494.21..1,575,189.05 rows=892 width=8,125) (actual rows= loops=)

  • Merge Cond: (personmbrs2_.prsn_mbrsh_id = personmiss17_.prsn_mbrsh_id)
16. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=408,437.71..1,572,762.63 rows=892 width=8,039) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=408,351.21..1,489,893.38 rows=892 width=7,958) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=408,263.71..1,401,580.92 rows=892 width=7,821) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=408,176.21..1,300,224.80 rows=780 width=7,740) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=408,088.71..1,223,000.90 rows=780 width=7,672) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=408,030.21..1,172,375.00 rows=780 width=7,594) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=407,971.71..1,121,746.08 rows=780 width=7,486) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=407,913.21..1,071,128.05 rows=780 width=7,428) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=407,828.21..994,594.89 rows=780 width=7,302) (actual rows= loops=)

  • Merge Cond: (personmbrs2_.prsn_mbrsh_id = verchklist22_.prsn_memship_id)
  • -> Index Scan using ix_t_ver_chk_list_prsn_memship_id on t_ver_chk_list verchklist22_ (cost=29.50..876.15 rows=330 width (...)
25. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=407,798.71..993,163.24 rows=780 width=7,134) (actual rows= loops=)

  • -> Index Scan using ix_t_prsn_acmdn_prsn_addl_attr_id on t_prsn_acmdn personacmd33_ (cost=57.50..63.29 rows=1 widt (...)
26. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=407,741.21..943,403.87 rows=780 width=7,048) (actual rows= loops=)

  • -> Index Scan using ix_t_prsn_race_prsn_addl_attr_id on t_prsn_race personrace36_ (cost=87.00..92.92 rows=1 (...)
  • Index Cond: (personaddl12_.prsn_addl_attr_id = prsn_addl_attr_id)
27. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=407,654.21..870,539.10 rows=780 width=6,979) (actual rows= loops=)

  • -> Index Scan using ix_t_prsn_impmt_prsn_addl_attr_id on t_prsn_impmt personimpm35_ (cost=85.50..91.40 (...)
  • Index Cond: (personaddl12_.prsn_addl_attr_id = prsn_addl_attr_id)
28. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=407,568.71..798,858.61 rows=780 width=6,892) (actual rows= loops=)

  • -> Index Scan using ix_t_prsn_etncty_prsn_addl_attr_id on t_prsn_etncty personetnc34_ (cost=86.0 (...)
  • Index Cond: (personaddl12_.prsn_addl_attr_id = prsn_addl_attr_id)
29. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=407,482.71..726,787.73 rows=780 width=6,811) (actual rows= loops=)

  • -> Index Scan using ix_t_prsn_addl_attr_prsn_mbrsh_id on t_prsn_addl_attr personaddl12_ (c (...)
  • Index Cond: (personaddl12_.prsn_addl_attr_id = prsn_addl_attr_id)
30. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=407,395.21..649,563.83 rows=780 width=6,352) (actual rows= loops=)

  • -> Index Scan using pk_t_prsn_hlth_ins on t_prsn_hlth_ins personheal40_ (cost=84.50. (...)
  • Index Cond: (personmbrs2_.prsn_mbrsh_id = prsn_mbrsh_id)
31. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=407,310.71..578,665.77 rows=780 width=5,992) (actual rows= loops=)

  • -> Index Scan using ix_t_prsn_hlth_ins_assn_prsn_mbrshp_id on t_prsn_hlth_ins_a (...)
  • Index Cond: (personheal20_.prsn_hlth_ins_id = prsn_hlth_ins_id)
32. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=407,224.71..502,611.87 rows=780 width=5,968) (actual rows= loops=)

  • -> Index Scan using ix_t_prsn_incm_prsn_mbrshp_id on t_prsn_incm_fti pers (...)
  • Index Cond: (personmbrs2_.prsn_mbrsh_id = prsn_mbrshp_id)
33. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=407,111.71..407,640.21 rows=518 width=5,617) (actual rows= loops=)

  • Merge Cond: (personmbrs2_.prsn_mbrsh_id = verifservr23_.prsn_mbrsh_i (...)
  • Index Cond: (personmbrs2_.prsn_mbrsh_id = prsn_mbrshp_id)
34. 0.000 0.000 ↓ 0.0

Sort (cost=407,063.49..407,322.49 rows=518 width=951) (actual rows= loops=)

  • Sort Key: personmbrs2_.prsn_mbrsh_id
  • -> Nested Loop Left Join (cost=715.00..402392.78 rows=518 wi (...)
  • -> Nested Loop Left Join (cost=602.00..366173.01 rows= (...)
  • -> Nested Loop Left Join (cost=515.00..343848.73 (...)
  • -> Nested Loop Left Join (cost=401.50..121 (...)
  • -> Nested Loop Left Join (cost=314.0 (...)
  • -> Index Scan using ix_t_prsn_m (...)
  • Index Cond: (appln_id = '2 (...)
  • -> Nested Loop Left Join (cost (...)
  • -> Index Scan using xif2p (...)
  • Index Cond: (personm (...)
  • -> Index Scan using xif1p (...)
  • Index Cond: (persone (...)
  • -> Index Scan using xif1person_member (...)
  • Index Cond: (personmbrs2_.prsn_m (...)
  • -> Index Scan using xif1person_relationship (...)
  • Index Cond: (personmbrs2_.prsn_mbrsh_i (...)
  • -> Index Scan using xif1person_plan_enrollment_pe (...)
  • Index Cond: (personmbrs2_.prsn_mbrsh_id = pr (...)
  • -> Index Scan using ix_t_prsn_mbrsh_tax_prsn_mbrshp_id (...)
  • Index Cond: (personmbrs2_.prsn_mbrsh_id = prsn_mbr (...)
35. 0.000 0.000 ↓ 0.0

Sort (cost=48.22..53.22 rows=10 width=4,666) (actual rows= loops=)

  • Sort Key: verifservr23_.prsn_mbrsh_id
  • -> Seq Scan on t_verif_serv_resp verifservr23_ (cost=0.00..1 (...)
36. 0.000 0.000 ↓ 0.0

Index Scan using ix_t_prsn_ddtn_prsn_memshp_id on t_prsn_ddtn persondedu21_ (cost=85.00..97.12 rows=2 width=126) (actual rows= loops=)

  • Index Cond: (personmbrs2_.prsn_mbrsh_id = prsn_memshp_id)
37. 0.000 0.000 ↓ 0.0

Index Scan using pk_t_emplr on t_emplr personheal41_ (cost=58.50..64.39 rows=1 width=58) (actual rows= loops=)

  • Index Cond: (personheal40_.emplr_id = emplr_id)
38. 0.000 0.000 ↓ 0.0

Index Scan using xif1employer_attribute on t_emplr_attr personheal43_ (cost=58.50..64.41 rows=1 width=108) (actual rows= loops=)

  • Index Cond: (personheal41_.emplr_id = emplr_id)
39. 0.000 0.000 ↓ 0.0

Index Scan using ix_t_emplr_ph_emplr_id on t_emplr_ph personheal42_ (cost=58.50..64.40 rows=1 width=78) (actual rows= loops=)

  • Index Cond: (personheal41_.emplr_id = emplr_id)
40. 0.000 0.000 ↓ 0.0

Index Scan using xif2prsn_membership_prsn_name_assoc on t_prsn_mbrsh_prsn_name_ac personmbrs9_ (cost=87.50..98.50 rows=1 width=68) (actual rows= loops=)

  • Index Cond: (personmbrs2_.prsn_mbrsh_id = prsn_mbrsh_id)
41. 0.000 0.000 ↓ 0.0

Index Scan using ix_t_appln_change_reporting_log_prsn_mbrsh_id on t_appln_change_reporting_log changerepo26_ (cost=87.50..119.94 rows=20 width=81) (actual rows= loops=)

  • Index Cond: (personmbrs2_.prsn_mbrsh_id = prsn_mbrsh_id)
42. 0.000 0.000 ↓ 0.0

Index Scan using ix_t_prsn_lawful_prsc_prsn_mbrsh_id on t_prsn_lawful_prsc personlawf19_ (cost=87.50..98.50 rows=1 width=137) (actual rows= loops=)

  • Index Cond: (personmbrs2_.prsn_mbrsh_id = prsn_mbrsh_id)
43. 0.000 0.000 ↓ 0.0

Index Scan using pk_t_prsn_name on t_prsn_name personlawf37_ (cost=86.50..92.40 rows=1 width=81) (actual rows= loops=)

  • Index Cond: (personlawf19_.prsn_name_id = prsn_name_id)
44. 0.000 0.000 ↓ 0.0

Index Scan using ix_t_prsn_missg_info_prsn_mbrsh_id on t_prsn_missg_info personmiss17_ (cost=56.50..3,701.46 rows=5,797 width=86) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Index Scan using xif2person_eligibility_other on t_prsn_elgt_other personelgt10_ (cost=29.50..1,226.85 rows=470 width=128) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Index Scan using xif2prsn_membership_prsn_eligibility_assoc on t_prsn_mbrsh_prsn_elgt_ac personmbrs14_ (cost=29.50..1,226.85 rows=470 width=144) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Index Scan using xif1person_membership_person_phone_assoc on t_prsn_mbrsh_prsn_phone_ac personmbrs8_ (cost=87.00..101.31 rows=4 width=68) (actual rows= loops=)

  • Index Cond: (personmbrs2_.prsn_mbrsh_id = prsn_mbrsh_id)
48. 0.000 0.000 ↓ 0.0

Index Scan using ix_t_prsn_incm_prsn_mbrsh_tax_id on t_prsn_incm_fti innerperso39_ (cost=113.00..586.91 rows=411 width=351) (actual rows= loops=)

  • Index Cond: (personmbrs18_.prsn_mbrsh_tax_id = prsn_mbrsh_tax_id)
49. 0.000 0.000 ↓ 0.0

Index Scan using ix_t_prsn_gating_questns_prsn_mbrsh_id on t_prsn_gating_questns persongati25_ (cost=114.00..1,547.44 rows=887 width=89) (actual rows= loops=)

  • Index Cond: (personmbrs2_.prsn_mbrsh_id = prsn_mbrsh_id)
50. 0.000 0.000 ↓ 0.0

Index Scan using pk_t_prsn on t_prsn person7_ (cost=86.00..97.00 rows=1 width=136) (actual rows= loops=)

  • Index Cond: (personmbrs2_.prsn_id = prsn_id)
51. 0.000 0.000 ↓ 0.0

Hash (cost=566.99..566.99 rows=1 width=939) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=518.00..566.99 rows=1 width=939) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Index Scan using ix_t_appln_attr_appln_id on t_appln_attr applnattrs3_ (cost=87.00..98.00 rows=1 width=494) (actual rows= loops=)

  • Index Cond: (appln_id = '2647950'::numeric)
54. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=431.00..468.49 rows=1 width=445) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=344.00..375.07 rows=1 width=343) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=257.00..281.15 rows=1 width=276) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Index Scan using pk_t_auzd_repr on t_auzd_repr applnattrs27_ (cost=84.00..95.00 rows=1 width=145) (actual rows= loops=)

  • Index Cond: (applnattrs3_.auzd_rep_id = auzd_repr_id)
58. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=173.00..185.65 rows=1 width=131) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Index Scan using pk_t_prsn_phone on t_prsn_phone applnattrs30_ (cost=86.50..92.73 rows=1 width=66) (actual rows= loops=)

  • Index Cond: (applnattrs27_.prsn_phone_id = prsn_phone_id)
60. 0.000 0.000 ↓ 0.0

Index Scan using pk_t_phone on t_phone applnattrs31_ (cost=86.50..92.41 rows=1 width=65) (actual rows= loops=)

  • Index Cond: (applnattrs30_.ph_id = phone_id)
61. 0.000 0.000 ↓ 0.0

Index Scan using pk_t_prsn_adr on t_prsn_adr applnattrs28_ (cost=87.00..93.41 rows=1 width=67) (actual rows= loops=)

  • Index Cond: (applnattrs27_.prsn_adr_id = prsn_adr_id)
62. 0.000 0.000 ↓ 0.0

Index Scan using pk_t_adr on t_adr applnattrs29_ (cost=87.00..92.92 rows=1 width=102) (actual rows= loops=)

  • Index Cond: (applnattrs28_.adr_id = adr_id)
63. 0.000 0.000 ↓ 0.0

Hash (cost=173.44..173.44 rows=44 width=147) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Index Scan using ix_t_appl_case_comm_appln_id on t_appl_case_comm applcaseco5_ (cost=113.00..173.44 rows=44 width=147) (actual rows= loops=)

  • Index Cond: (appln_id = '2647950'::numeric)
65. 0.000 0.000 ↓ 0.0

Hash (cost=40.50..40.50 rows=1 width=276) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Index Scan using xif1special_plan_enrollment_period on t_spcl_plan_enrt_pd spclplanen4_ (cost=29.50..40.50 rows=1 width=276) (actual rows= loops=)

  • Index Cond: (appln_id = '2647950'::numeric)
67. 0.000 0.000 ↓ 0.0

Hash (cost=3,595.07..3,595.07 rows=1,572 width=97) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Index Scan using ix_t_appln_gating_questns_appln_id on t_appln_gating_questns applngatin1_ (cost=114.00..3,595.07 rows=1,572 width=97) (actual rows= loops=)

  • Index Cond: (appln_id = '2647950'::numeric)
69. 0.000 0.000 ↓ 0.0

Hash (cost=2,150,950.50..2,150,950.50 rows=4,196,671 width=81) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Seq Scan on t_prsn_name applnattrs32_ (cost=0.00..2,150,950.50 rows=4,196,671 width=81) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Hash (cost=227.01..227.01 rows=114 width=80) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Index Scan using ix_t_chng_report_rsn_appln_id on t_chng_report_rsn chngreport6_ (cost=87.50..227.01 rows=114 width=80) (actual rows= loops=)

  • Index Cond: (appln_id = '2647950'::numeric)