Skip to content

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

@IMhide

Description

@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

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions