[Performance] Mailchimp::SyncUserWorker#perform - Slow response time (5150417.63 s)

[IMhide]

Performance Issue: Mailchimp::SyncUserWorker#perform

Incident Number: #1173
AppSignal ID: 675abbc35babaec27cb749df
App ID: 64cb678083eb67f665b627b0

Status: CLOSED
Severity: UNTRIAGED

Description

No description provided

---

Critical Information

Metric	Value
Average Duration	5150417.63 s
Affected Actions	Mailchimp::SyncUserWorker#perform
State	CLOSED
Severity	UNTRIAGED

Performance Metrics

Based on 10 sample(s):

Statistic	Duration
Minimum	679.02 ms
Maximum	10.58 s
Average	2.69 s
Median	1.95 s

Sample Analysis

Analyzed 10 sample(s) from recent occurrences.

Sample 1

• Time: 2025-12-08 16:33:30 UTC
• Duration: 2.02 s
• Action: Mailchimp::SyncUserWorker#perform
• Queue Duration: 32.00 ms

Time Breakdown

Component	Duration	Percentage
net_http	1.04 s	51.5%
active_record	639.75 ms	31.7%
sidekiq	341.04 ms	16.9%

Memory Allocation

Component	Allocation
sidekiq	76.80 KB
active_record	2.15 KB
net_http	872.00 B

---

Sample 2

• Time: 2025-12-08 16:32:23 UTC
• Duration: 1.03 s
• Action: Mailchimp::SyncUserWorker#perform
• Queue Duration: 4.00 ms

Time Breakdown

Component	Duration	Percentage
active_record	784.62 ms	76.0%
sidekiq	248.10 ms	24.0%

Memory Allocation

Component	Allocation
sidekiq	67.85 KB
active_record	2.06 KB

---

Sample 3

• Time: 2025-12-08 16:31:40 UTC
• Duration: 2.63 s
• Action: Mailchimp::SyncUserWorker#perform
• Queue Duration: 14.00 ms

Time Breakdown

Component	Duration	Percentage
net_http	1.64 s	62.5%
active_record	568.11 ms	21.6%
sidekiq	417.37 ms	15.9%

Memory Allocation

Component	Allocation
sidekiq	83.70 KB
active_record	2.37 KB
net_http	872.00 B

---

Sample 4

• Time: 2025-12-08 16:29:56 UTC
• Duration: 1.18 s
• Action: Mailchimp::SyncUserWorker#perform
• Queue Duration: 4.00 ms

Time Breakdown

Component	Duration	Percentage
active_record	924.41 ms	78.5%
sidekiq	252.72 ms	21.5%

Memory Allocation

Component	Allocation
sidekiq	68.84 KB
active_record	2.05 KB

---

Sample 5

• Time: 2025-12-08 16:09:06 UTC
• Duration: 10.58 s
• Action: Mailchimp::SyncUserWorker#perform
• Queue Duration: 6.00 ms

Time Breakdown

Component	Duration	Percentage
net_http	9.27 s	87.6%
active_record	930.84 ms	8.8%
sidekiq	381.26 ms	3.6%

Memory Allocation

Component	Allocation
sidekiq	80.86 KB
active_record	2.14 KB
net_http	872.00 B

---

Sample 6

• Time: 2025-12-08 15:57:11 UTC
• Duration: 1.85 s
• Action: Mailchimp::SyncUserWorker#perform
• Queue Duration: 5.00 ms

Time Breakdown

Component	Duration	Percentage
net_http	1.17 s	63.1%
active_record	410.50 ms	22.2%
sidekiq	272.29 ms	14.7%

Memory Allocation

Component	Allocation
sidekiq	76.22 KB
active_record	2.08 KB
net_http	872.00 B

---

Sample 7

• Time: 2025-12-08 15:54:42 UTC
• Duration: 679.02 ms
• Action: Mailchimp::SyncUserWorker#perform
• Queue Duration: 4.00 ms

Time Breakdown

Component	Duration	Percentage
active_record	440.52 ms	64.9%
sidekiq	238.42 ms	35.1%

Memory Allocation

Component	Allocation
sidekiq	70.54 KB
active_record	2.17 KB

---

Sample 8

• Time: 2025-12-08 15:50:39 UTC
• Duration: 1.88 s
• Action: Mailchimp::SyncUserWorker#perform
• Queue Duration: 4.00 ms

Time Breakdown

Component	Duration	Percentage
net_http	1.23 s	65.4%
active_record	367.39 ms	19.5%
sidekiq	283.41 ms	15.0%

Memory Allocation

Component	Allocation
sidekiq	74.04 KB
active_record	1.94 KB
net_http	872.00 B

---

Sample 9

• Time: 2025-12-08 15:45:05 UTC
• Duration: 2.81 s
• Action: Mailchimp::SyncUserWorker#perform
• Queue Duration: 16.00 ms

Time Breakdown

Component	Duration	Percentage
net_http	1.68 s	59.8%
sidekiq	595.19 ms	21.2%
active_record	532.04 ms	19.0%

Memory Allocation

Component	Allocation
sidekiq	75.13 KB
active_record	2.07 KB
net_http	872.00 B

---

Sample 10

• Time: 2025-12-08 15:41:51 UTC
• Duration: 2.26 s
• Action: Mailchimp::SyncUserWorker#perform
• Queue Duration: 5.00 ms

Time Breakdown

Component	Duration	Percentage
net_http	1.41 s	62.5%
active_record	557.14 ms	24.6%
sidekiq	289.99 ms	12.8%

Memory Allocation

Component	Allocation
sidekiq	76.20 KB
active_record	2.08 KB
net_http	872.00 B

---

N+1 Query Detection

⚠️ N+1 query pattern detected in 10 out of 10 samples!

Affected Samples:

• Sample New dq fallback #1 at 2025-12-08 16:33:30 UTC (2.02 s)
• Sample [Performance] Mailchimp::SyncUserWorker#perform - Slow response time (5150417.63 s) #2 at 2025-12-08 16:32:23 UTC (1.03 s)
• Sample #3 at 2025-12-08 16:31:40 UTC (2.63 s)
• Sample #4 at 2025-12-08 16:29:56 UTC (1.18 s)
• Sample #5 at 2025-12-08 16:09:06 UTC (10.58 s)
• Sample #6 at 2025-12-08 15:57:11 UTC (1.85 s)
• Sample #7 at 2025-12-08 15:54:42 UTC (679.02 ms)
• Sample #8 at 2025-12-08 15:50:39 UTC (1.88 s)
• Sample #9 at 2025-12-08 15:45:05 UTC (2.81 s)
• Sample #10 at 2025-12-08 15:41:51 UTC (2.26 s)

Resource Allocation Analysis

Average memory allocation by category:

Category	Average Allocation	Samples
sidekiq	75.02 KB	10
active_record	2.11 KB	10
net_http	872.00 B	7