explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nVpL

Settings
# exclusive inclusive rows x rows loops node
1. 396.124 30,881.542 ↓ 1,427.7 285,545 1

Unique (cost=3,182,424.09..3,229,605.9 rows=200 width=1,721) (actual time=28,451.938..30,881.542 rows=285,545 loops=1)

  • Buffers: shared hit=1529525 read=220896 dirtied=2, temp read=80185 written=80171
2. 984.932 30,485.418 ↓ 1.1 285,777 1

Subquery Scan on lc (cost=3,182,424.09..3,228,941.36 rows=265,813 width=1,721) (actual time=28,451.931..30,485.418 rows=285,777 loops=1)

  • Buffers: shared hit=1529525 read=220896 dirtied=2, temp read=80185 written=80171
3. 4,610.806 29,500.486 ↓ 1.1 285,777 1

Sort (cost=3,182,424.09..3,183,088.62 rows=265,813 width=1,603) (actual time=28,451.874..29,500.486 rows=285,777 loops=1)

  • Sort Key: (COALESCE(c."Id", l."Id"))
  • Sort Method: external merge Disk: 107232kB
  • Buffers: shared hit=1529449 read=220894 dirtied=2, temp read=80185 written=80171
4. 406.846 24,889.680 ↓ 1.1 285,777 1

Unique (cost=2,733,962.14..2,787,789.27 rows=265,813 width=1,603) (actual time=23,407.784..24,889.68 rows=285,777 loops=1)

  • Buffers: shared hit=1529446 read=220894 dirtied=2, temp read=55009 written=54995
5. 5,818.944 24,482.834 ↓ 1.1 304,884 1

Sort (cost=2,733,962.14..2,734,626.67 rows=265,813 width=1,603) (actual time=23,407.782..24,482.834 rows=304,884 loops=1)

  • Sort Key: l."Id", (COALESCE(c."Id", l."Id")), c."Id", (COALESCE(c."Student_ID__c", l."Student_ID__c")), (COALESCE(ac."Reporting_Name__c", al."Reporting_Name__c", ac."Name", al."Name")), (COALESCE(cp."Reporting_Name__c", ac."Reporting_Name__c", ap."Reporting_Name__c", al."Reporting_Name__c", ap."Name", al."Name")), (COALESCE(c."AccountId", l."University__c")), (CASE l."Status" WHEN 'Persisting'::text THEN 'Qualified'::text WHEN 'Start'::text THEN 'Qualified'::text WHEN 'Attempted Contact'::text THEN 'Qualified'::text WHEN 'Admitted'::text THEN 'Qualified'::text WHEN 'Requirements Complete'::text THEN 'Qualified'::text WHEN 'Nurturing'::text THEN 'Qualified'::text WHEN 'Graduated'::text THEN 'Graduated'::text WHEN 'Applied'::text THEN 'Qualified'::text ELSE l."Status" END), l."IsDeleted", l."IsConverted", c."IsDeleted", c."Student_Status__c", c."Actively_Enrolled__c", u."Name", (CASE WHEN (c."Removed_from_Pipeline__c" OR (lower(l."Status") = 'unqualified'::text)) THEN true ELSE false END), (COALESCE(c."Reason_Removed_from_Pipeline__c", l."Reason_Removed_from_Pipeline__c")), (COALESCE(c."Recovery_Student__c", l."Recovery_Student__c")), (COALESCE(c."Do_not_contact_DNC__c", l."Do_not_contact_DNC__c")), (COALESCE(c."Reason_Not_Interested__c", l."Reason_Not_Interested__c")), (COALESCE(c."Student_Motivation__c", l."Student_Motivation__c")), (COALESCE(c."Estimated_Start_Date__c", l."Estimated_Start_Date__c")), (COALESCE(c."Official_Start_Date__c", l."Official_Start_Date__c")), (COALESCE(c."Program_of_Study__c", l."Program_of_Study__c")), (COALESCE(c."Re_enrollment_Plans__c", l."Re_enrollment_Plans__c")), (COALESCE(c."Re_enrollment_Additional_Info__c", l."Re_enrollment_Additional_Info__c")), (COALESCE(c."Re_Enrollment_College__c", l."Re_enrollment_Plans__c")), (COALESCE(c."Last_Attendance__c", l."Last_Attendance__c")), (COALESCE(c."Original_Drop_Date__c", l."Original_Drop_Date__c")), (COALESCE(c."Last_Contact_Date__c", l."Last_Contact_Date__c")), l."Units_Completed__c", (COALESCE(c."Gender__c", l."Gender__c")), (COALESCE(l."Age__c__ti", l."DOB__c", c."DOB__c")), (COALESCE(c."MailingCity", l."City")), (COALESCE(c."MailingState", l."State")), (COALESCE("left"(c."MailingPostalCode", 5), "left"(l."PostalCode", 5))), (COALESCE(l."Outreach_Cohort__c", c."Outreach_Cohort__c")), (COALESCE(l."Original_Institution__c", c."Original_Institution__c")), (COALESCE(CASE WHEN (l."Status" = 'Unqualified'::text) THEN true ELSE NULL::boolean END, CASE WHEN (c."Reached_SMS__c" OR l."Reached_SMS__c") THEN true ELSE NULL::boolean END, CASE WHEN (c."Reached_Email__c" OR l."Reached_Email__c") THEN true ELSE NULL::boolean END, CASE WHEN (COALESCE(l."Last_Contact_Date__c", c."Last_Contact_Date__c") IS NOT NULL) THEN true ELSE NULL::boolean END)), (COALESCE(c."Graduated_Status_Date__c", c."Official_Graduation_Date__c", l."Official_Graduation_Date__c")), c."Coach_Projection__c", (COALESCE(c."Original_Drop_Reason__c", l."Original_Drop_Reason__c")), (COALESCE(c."Original_Drop_Reason_Subcategory__c", l."Original_Drop_Reason_Subcategory__c")), ((l."Reached_Email__c" OR c."Reached_Email__c")), ((l."Reached_SMS__c" OR c."Reached_SMS__c")), (COALESCE(c."University_Specific_Field__c", l."University_Specific_Field__c")), c."Primary_External_Barrier__c", c."Primary_Internal_Perspective__c", c."Primary_Coach_Next_Step__c", c."Secondary_External_Barrier__c", c."Secondary_Internal_Perspective__c", c."Secondary_Coach_Next_Step__c", (CASE WHEN (c."Official_Start_Date__c" IS NOT NULL) THEN true ELSE false END), (COALESCE(c."UG_GPA__c", l."UG_GPA__c")), c."Date_of_Next_Outreach__c", c."Date_of_Next_Meeting__c", (COALESCE(c."Conversion_Channel__c", l."Conversion_Channel__c")), cac.outreachcount, cac.meetingcount, cac.contactcount, (COALESCE(c."Current_Holds__c", l."Current_Holds__c")), (COALESCE(c."Units_Attempted__c", l."Units_Attempted__c")), (COALESCE(c."Append_Date__c", l."Append_Date__c")), uc."Name", l."CreatedDate", c."CreatedDate", (COALESCE(c."System_ID__c", l."System_ID__c")), (COALESCE(c."Inbound_Applicants__c", l."Inbound_Applicants__c")), l."Unqualified_Status_Date__c", (COALESCE(c."Enrollment_Modality__c", l."Enrollment_Modality__c")), c."Data_Discrepancy_Counter__c", c."Data_Discrepancy__c", c."Data_Discrepancy_Notes__c", (COALESCE(c."Contact_Verification__c", l."Contact_Verification__c")), (COALESCE(c."ReUp_ID__c", l."ReUp_ID__c")), (COALESCE(c."Append_Email__c__bo", l."Append_Email__c__bo")), (COALESCE(c."Append_Phone__c", l."Append_Phone__c")), (COALESCE(c."Ethnicity__c", l."Ethnicity__c")), (COALESCE(c."Race__c", l."Race__c")), (COALESCE(c."Marital_Status__c", l."Marital_Status__c")), (COALESCE(c."Military_Status__c", l."Military_Status__c"))
  • Sort Method: external merge Disk: 115656kB
  • Buffers: shared hit=1524480 read=220894 dirtied=2, temp read=55009 written=54995
6. 140.838 18,663.890 ↓ 1.1 304,884 1

Append (cost=2,309,346.2..2,339,327.32 rows=265,813 width=1,603) (actual time=14,801.655..18,663.89 rows=304,884 loops=1)

  • Buffers: shared hit=1519477 read=220893 dirtied=2, temp read=40548 written=40534
7. 167.293 16,453.711 ↓ 1.1 285,704 1

Unique (cost=2,309,346.2..2,310,672.54 rows=265,267 width=1,522) (actual time=14,801.654..16,453.711 rows=285,704 loops=1)

  • Buffers: shared hit=1086361 read=194310 dirtied=1, temp read=39482 written=39468
8. 5,468.312 16,286.418 ↓ 1.1 285,704 1

Sort (cost=2,309,346.2..2,310,009.37 rows=265,267 width=1,522) (actual time=14,801.653..16,286.418 rows=285,704 loops=1)

  • Sort Key: l."Id"
  • Sort Method: external merge Disk: 107192kB
  • Buffers: shared hit=1086361 read=194310 dirtied=1, temp read=39482 written=39468
9. 1,996.758 10,818.106 ↓ 1.1 285,704 1

Hash Join (cost=16,501.7..1,933,657.51 rows=265,267 width=1,522) (actual time=565.99..10,818.106 rows=285,704 loops=1)

  • Buffers: shared hit=1086361 read=194310 dirtied=1, temp read=14355 written=14341
10. 310.763 8,258.247 ↓ 1.1 285,704 1

Hash Join (cost=108.48..1,782,296.7 rows=265,267 width=1,838) (actual time=1.076..8,258.247 rows=285,704 loops=1)

  • Buffers: shared hit=1084753 read=188023 dirtied=1
11. 284.472 7,947.425 ↓ 1.1 295,718 1

Hash Join (cost=106.11..1,778,639.29 rows=267,298 width=1,857) (actual time=0.993..7,947.425 rows=295,718 loops=1)

  • Buffers: shared hit=1084752 read=188023 dirtied=1
12. 273.698 7,662.875 ↓ 1.1 295,718 1

Hash Join (cost=90.6..1,774,948.43 rows=267,298 width=1,862) (actual time=0.892..7,662.875 rows=295,718 loops=1)

  • Buffers: shared hit=1084738 read=188023 dirtied=1
13. 269.901 7,389.073 ↓ 1.1 295,718 1

Hash Join (cost=77.49..1,772,795.51 rows=267,298 width=1,844) (actual time=0.778..7,389.073 rows=295,718 loops=1)

  • Buffers: shared hit=1084727 read=188023 dirtied=1
14. 329.157 7,118.899 ↓ 1.1 295,718 1

Hash Join (cost=50.51..1,769,093.43 rows=267,298 width=1,794) (actual time=0.489..7,118.899 rows=295,718 loops=1)

  • Buffers: shared hit=1084705 read=188023 dirtied=1
15. 582.811 6,789.582 ↓ 1.1 295,718 1

Nested Loop (cost=35..1,767,180.1 rows=267,298 width=1,818) (actual time=0.315..6,789.582 rows=295,718 loops=1)

  • Filter: (((NOT c."IsDeleted") AND l."IsConverted") OR ((NOT l."IsDeleted") AND (NOT l."IsConverted")) OR (hashed SubPlan 2))
  • Buffers: shared hit=1084691 read=188023
16. 385.385 1,726.741 ↓ 1.0 320,001 1

Hash Join (cost=13.12..201,425.76 rows=317,014 width=850) (actual time=0.216..1,726.741 rows=320,001 loops=1)

  • Buffers: shared hit=5015 read=188017
17. 1,341.195 1,341.195 ↓ 1.0 320,001 1

Seq Scan on Lead l (cost=0..197,044.6 rows=319,442 width=775) (actual time=0.037..1,341.195 rows=320,001 loops=1)

  • Filter: ((l."University__c" IS NOT NULL) AND (l."Status" <> 'Test'::text))
  • Buffers: shared hit=5004 read=188017
18. 0.048 0.161 ↑ 1.0 94 1

Hash (cost=11.94..11.94 rows=94 width=75) (actual time=0.161..0.161 rows=94 loops=1)

  • Buffers: shared hit=11
19. 0.113 0.113 ↑ 1.0 94 1

Seq Scan on Account al (cost=0..11.94 rows=94 width=75) (actual time=0.01..0.113 rows=94 loops=1)

  • Buffers: shared hit=11
20. 320.001 4,480.014 ↓ 0.0 0 320,001

Bitmap Heap Scan on Contact c (cost=0.88..4.91 rows=2 width=1,006) (actual time=0.014..0.014 rows=0 loops=320,001)

  • Heap Blocks: exact=40041
  • Buffers: shared hit=1079675 read=6
21. 640.002 4,160.013 ↓ 0.0 0 320,001

BitmapOr (cost=0.88..0.88 rows=2 width=0) (actual time=0.013..0.013 rows=0 loops=320,001)

  • Buffers: shared hit=1039634 read=6
22. 320.001 320.001 ↓ 0.0 0 320,001

Bitmap Index Scan on "Contact_pkey" (cost=0..0.45 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=320,001)

  • Index Cond: (l."ConvertedContactId" = c."Id")
  • Buffers: shared hit=78990 read=6
23. 3,200.010 3,200.010 ↓ 0.0 0 320,001

Bitmap Index Scan on "Contact_Lead_ID" (cost=0..0.44 rows=1 width=0) (actual time=0.01..0.01 rows=0 loops=320,001)

  • Index Cond: (c."Lead_Id__c" = l."Id")
  • Buffers: shared hit=960644
24.          

SubPlan (for Nested Loop)

25. 0.016 0.016 ↑ 46.3 19 1

Seq Scan on accounts_noreport accounts_noreport_1 (cost=0..18.8 rows=880 width=32) (actual time=0.012..0.016 rows=19 loops=1)

  • Buffers: shared hit=1
26. 0.036 0.160 ↑ 1.0 67 1

Hash (cost=14.67..14.67 rows=67 width=33) (actual time=0.159..0.16 rows=67 loops=1)

  • Buffers: shared hit=14 dirtied=1
27. 0.124 0.124 ↑ 1.0 67 1

Seq Scan on User u (cost=0..14.67 rows=67 width=33) (actual time=0.011..0.124 rows=67 loops=1)

  • Buffers: shared hit=14 dirtied=1
28. 0.053 0.273 ↑ 1.0 94 1

Hash (cost=25.81..25.81 rows=94 width=69) (actual time=0.273..0.273 rows=94 loops=1)

  • Buffers: shared hit=22
29. 0.087 0.220 ↑ 1.0 94 1

Hash Join (cost=13.12..25.81 rows=94 width=69) (actual time=0.117..0.22 rows=94 loops=1)

  • Buffers: shared hit=22
30. 0.032 0.032 ↑ 1.0 94 1

Seq Scan on Account ac (cost=0..11.94 rows=94 width=75) (actual time=0.004..0.032 rows=94 loops=1)

  • Buffers: shared hit=11
31. 0.046 0.101 ↑ 1.0 94 1

Hash (cost=11.94..11.94 rows=94 width=32) (actual time=0.1..0.101 rows=94 loops=1)

  • Buffers: shared hit=11
32. 0.055 0.055 ↑ 1.0 94 1

Seq Scan on Account cp (cost=0..11.94 rows=94 width=32) (actual time=0.002..0.055 rows=94 loops=1)

  • Buffers: shared hit=11
33. 0.044 0.104 ↑ 1.0 94 1

Hash (cost=11.94..11.94 rows=94 width=56) (actual time=0.104..0.104 rows=94 loops=1)

  • Buffers: shared hit=11
34. 0.060 0.060 ↑ 1.0 94 1

Seq Scan on Account ap (cost=0..11.94 rows=94 width=56) (actual time=0.002..0.06 rows=94 loops=1)

  • Buffers: shared hit=11
35. 0.032 0.078 ↑ 1.0 67 1

Hash (cost=14.67..14.67 rows=67 width=33) (actual time=0.078..0.078 rows=67 loops=1)

  • Buffers: shared hit=14
36. 0.046 0.046 ↑ 1.0 67 1

Seq Scan on User uc (cost=0..14.67 rows=67 width=33) (actual time=0.005..0.046 rows=67 loops=1)

  • Buffers: shared hit=14
37. 0.028 0.059 ↓ 1.0 64 1

Hash (cost=1.61..1.61 rows=61 width=19) (actual time=0.058..0.059 rows=64 loops=1)

  • Buffers: shared hit=1
38. 0.031 0.031 ↓ 1.0 64 1

Seq Scan on accounts_service aa (cost=0..1.61 rows=61 width=19) (actual time=0.01..0.031 rows=64 loops=1)

  • Filter: (aa.id IS NOT NULL)
  • Buffers: shared hit=1
39. 229.834 563.101 ↑ 1.0 289,654 1

Hash (cost=10,791.54..10,791.54 rows=289,654 width=31) (actual time=563.101..563.101 rows=289,654 loops=1)

  • Buffers: shared hit=1608 read=6287, temp written=1574
40. 333.267 333.267 ↑ 1.0 289,654 1

Seq Scan on contact_activitytype_counts cac (cost=0..10,791.54 rows=289,654 width=31) (actual time=0.022..333.267 rows=289,654 loops=1)

  • Buffers: shared hit=1608 read=6287
41. 10.475 2,069.341 ↓ 35.1 19,180 1

Unique (cost=25,993.92..25,996.65 rows=546 width=1,522) (actual time=2,025.686..2,069.341 rows=19,180 loops=1)

  • Buffers: shared hit=433116 read=26583 dirtied=1, temp read=1066 written=1066
42. 325.222 2,058.866 ↓ 35.4 19,303 1

Sort (cost=25,993.92..25,995.28 rows=546 width=1,522) (actual time=2,025.68..2,058.866 rows=19,303 loops=1)

  • Sort Key: l_1."Id"
  • Sort Method: external merge Disk: 8512kB
  • Buffers: shared hit=433116 read=26583 dirtied=1, temp read=1066 written=1066
43. 102.630 1,733.644 ↓ 35.4 19,303 1

Nested Loop (cost=424.2..25,969.1 rows=546 width=1,522) (actual time=11.044..1,733.644 rows=19,303 loops=1)

  • Buffers: shared hit=433116 read=26583 dirtied=1
44. 21.042 1,341.469 ↓ 35.4 19,303 1

Hash Join (cost=423.78..25,053.89 rows=546 width=1,838) (actual time=10.986..1,341.469 rows=19,303 loops=1)

  • Buffers: shared hit=355970 read=26256 dirtied=1
45. 33.943 1,320.369 ↓ 35.1 19,303 1

Nested Loop (cost=421.4..25,043.99 rows=550 width=1,857) (actual time=10.916..1,320.369 rows=19,303 loops=1)

  • Buffers: shared hit=355969 read=26256 dirtied=1
46. 31.783 1,189.911 ↓ 35.1 19,303 1

Nested Loop (cost=421.14..24,881.62 rows=550 width=1,862) (actual time=10.902..1,189.911 rows=19,303 loops=1)

  • Buffers: shared hit=298060 read=26256 dirtied=1
47. 47.987 1,061.613 ↓ 35.1 19,303 1

Hash Join (cost=420.87..24,718.45 rows=550 width=1,886) (actual time=10.879..1,061.613 rows=19,303 loops=1)

  • Filter: ((l_1."University__c" = c_1."AccountId") OR (l_1."University__c" = ac_1."ParentId") OR (ac_1."ParentId" = al_1."ParentId"))
  • Buffers: shared hit=240147 read=26256
48. 173.295 1,013.348 ↓ 12.1 68,554 1

Nested Loop (cost=393.89..24,571.27 rows=5,657 width=1,855) (actual time=10.586..1,013.348 rows=68,554 loops=1)

  • Filter: (((NOT c_1."IsDeleted") AND l_1."IsConverted") OR ((NOT l_1."IsDeleted") AND (NOT l_1."IsConverted")) OR (hashed SubPlan 1))
  • Buffers: shared hit=240125 read=26256
49. 66.594 429.731 ↓ 10.2 68,385 1

Nested Loop (cost=372.47..16,334.87 rows=6,709 width=868) (actual time=10.525..429.731 rows=68,385 loops=1)

  • Buffers: shared hit=14961 read=26189
50. 0.195 0.593 ↓ 7.0 14 1

Nested Loop (cost=0.54..157 rows=2 width=112) (actual time=0.291..0.593 rows=14 loops=1)

  • Filter: ((ap_1."Name" = 'CUNY'::text) OR (al_1."Name" = 'WGU'::text))
  • Buffers: shared hit=201
51. 0.116 0.116 ↑ 1.0 94 1

Index Scan using "Account_pkey" on Account al_1 (cost=0.27..64.8 rows=94 width=75) (actual time=0.01..0.116 rows=94 loops=1)

  • Buffers: shared hit=81
52. 0.282 0.282 ↓ 0.0 0 94

Index Scan using "Account_pkey" on Account ap_1 (cost=0.27..0.97 rows=1 width=56) (actual time=0.003..0.003 rows=0 loops=94)

  • Index Cond: (al_1."ParentId" = ap_1."Id")
  • Buffers: shared hit=120
53. 348.264 362.544 ↑ 1.1 4,885 14

Bitmap Heap Scan on Lead l_1 (cost=371.94..8,034.27 rows=5,466 width=756) (actual time=1.441..25.896 rows=4,885 loops=14)

  • Filter: (l_1."Status" <> 'Test'::text)
  • Heap Blocks: exact=40208
  • Buffers: shared hit=14760 read=26189
54. 14.280 14.280 ↑ 1.1 4,885 14

Bitmap Index Scan on "Lead_University_id" (cost=0..370.57 rows=5,466 width=0) (actual time=1.02..1.02 rows=4,885 loops=14)

  • Index Cond: ((l_1."University__c" = al_1."Id") AND (l_1."University__c" IS NOT NULL))
  • Buffers: shared hit=50 read=691
55. 410.310 410.310 ↓ 0.0 0 68,385

Index Scan using "Contact_Student_id" on Contact c_1 (cost=0.41..1.21 rows=1 width=987) (actual time=0.006..0.006 rows=0 loops=68,385)

  • Index Cond: (l_1."Student_ID__c" = c_1."Student_ID__c")
  • Buffers: shared hit=225163 read=67
56.          

SubPlan (for Nested Loop)

57. 0.012 0.012 ↑ 46.3 19 1

Seq Scan on accounts_noreport accounts_noreport (cost=0..18.8 rows=880 width=32) (actual time=0.006..0.012 rows=19 loops=1)

  • Buffers: shared hit=1
58. 0.051 0.278 ↑ 1.0 94 1

Hash (cost=25.81..25.81 rows=94 width=88) (actual time=0.278..0.278 rows=94 loops=1)

  • Buffers: shared hit=22
59. 0.087 0.227 ↑ 1.0 94 1

Hash Join (cost=13.12..25.81 rows=94 width=88) (actual time=0.124..0.227 rows=94 loops=1)

  • Buffers: shared hit=22
60. 0.027 0.027 ↑ 1.0 94 1

Seq Scan on Account ac_1 (cost=0..11.94 rows=94 width=75) (actual time=0.004..0.027 rows=94 loops=1)

  • Buffers: shared hit=11
61. 0.039 0.113 ↑ 1.0 94 1

Hash (cost=11.94..11.94 rows=94 width=32) (actual time=0.113..0.113 rows=94 loops=1)

  • Buffers: shared hit=11
62. 0.074 0.074 ↑ 1.0 94 1

Seq Scan on Account cp_1 (cost=0..11.94 rows=94 width=32) (actual time=0.002..0.074 rows=94 loops=1)

  • Buffers: shared hit=11
63. 96.515 96.515 ↑ 1.0 1 19,303

Index Scan using "User_pkey" on User u_1 (cost=0.27..0.29 rows=1 width=33) (actual time=0.004..0.005 rows=1 loops=19,303)

  • Index Cond: (u_1."Id" = COALESCE(c_1."OwnerId", l_1."OwnerId"))
  • Buffers: shared hit=57913 dirtied=1
64. 96.515 96.515 ↑ 1.0 1 19,303

Index Scan using "User_pkey" on User uc_1 (cost=0.27..0.29 rows=1 width=33) (actual time=0.005..0.005 rows=1 loops=19,303)

  • Index Cond: (uc_1."Id" = l_1."CreatedById")
  • Buffers: shared hit=57909
65. 0.028 0.058 ↓ 1.0 64 1

Hash (cost=1.61..1.61 rows=61 width=19) (actual time=0.057..0.058 rows=64 loops=1)

  • Buffers: shared hit=1
66. 0.030 0.030 ↓ 1.0 64 1

Seq Scan on accounts_service aa_1 (cost=0..1.61 rows=61 width=19) (actual time=0.013..0.03 rows=64 loops=1)

  • Filter: (aa_1.id IS NOT NULL)
  • Buffers: shared hit=1
67. 289.545 289.545 ↑ 1.0 1 19,303

Index Scan using contact_activitytype_counts_pkey on contact_activitytype_counts cac_1 (cost=0.42..1.63 rows=1 width=31) (actual time=0.014..0.015 rows=1 loops=19,303)

  • Index Cond: (cac_1.contactleadid = COALESCE(c_1."Id", l_1."Id"))
  • Buffers: shared hit=77146 read=327
Planning time : 38.473 ms
Execution time : 30,999.129 ms