File size: 4,209 Bytes
2ee6321
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
SERVER PERFORMANCE LOG β€” api.taskflow.io
Period: 2024-03-01 to 2024-03-07
Generated: 2024-03-08 00:00:01 UTC

=== DAILY SUMMARY ===

2024-03-01 (Friday)
  Total requests:      84,291
  Successful (2xx):    81,940  (97.2%)
  Client errors (4xx): 1,847   (2.2%)
  Server errors (5xx): 504     (0.6%)
  Avg response time:   142ms
  P95 response time:   380ms
  P99 response time:   910ms
  Peak hour:           14:00 UTC  (6,203 req/hr)
  Slowest endpoint:    POST /api/automations/trigger  (avg 841ms)

2024-03-02 (Saturday)
  Total requests:      41,058
  Successful (2xx):    40,321  (98.2%)
  Client errors (4xx): 614     (1.5%)
  Server errors (5xx): 123     (0.3%)
  Avg response time:   98ms
  P95 response time:   210ms
  P99 response time:   480ms
  Peak hour:           11:00 UTC  (3,102 req/hr)
  Slowest endpoint:    GET /api/reports/export  (avg 620ms)

2024-03-03 (Sunday)
  Total requests:      38,774
  Successful (2xx):    38,100  (98.3%)
  Client errors (4xx): 571     (1.5%)
  Server errors (5xx): 103     (0.3%)
  Avg response time:   94ms
  P95 response time:   198ms
  P99 response time:   440ms
  Peak hour:           13:00 UTC  (2,890 req/hr)
  Slowest endpoint:    GET /api/reports/export  (avg 598ms)

2024-03-04 (Monday)
  Total requests:      97,512
  Successful (2xx):    91,204  (93.5%)
  Client errors (4xx): 2,311   (2.4%)
  Server errors (5xx): 3,997   (4.1%)  *** ELEVATED ***
  Avg response time:   389ms   *** HIGH ***
  P95 response time:   1,840ms *** HIGH ***
  P99 response time:   4,200ms *** HIGH ***
  Peak hour:           09:00 UTC  (9,841 req/hr)
  Slowest endpoint:    POST /api/integrations/sync  (avg 3,210ms)
  Incident note:       DB connection pool exhaustion 09:12-10:47 UTC.
                       Root cause: Monday morning sync spike + missing index on integrations table.
                       Resolved by adding index and increasing pool size to 150.

2024-03-05 (Tuesday)
  Total requests:      91,804
  Successful (2xx):    89,933  (97.9%)
  Client errors (4xx): 1,688   (1.8%)
  Server errors (5xx): 183     (0.2%)
  Avg response time:   158ms
  P95 response time:   401ms
  P99 response time:   870ms
  Peak hour:           14:00 UTC  (7,120 req/hr)
  Slowest endpoint:    POST /api/automations/trigger  (avg 790ms)

2024-03-06 (Wednesday)
  Total requests:      93,140
  Successful (2xx):    91,178  (97.9%)
  Client errors (4xx): 1,710   (1.8%)
  Server errors (5xx): 252     (0.3%)
  Avg response time:   161ms
  P95 response time:   415ms
  P99 response time:   890ms
  Peak hour:           15:00 UTC  (7,380 req/hr)
  Slowest endpoint:    POST /api/automations/trigger  (avg 812ms)

2024-03-07 (Thursday)
  Total requests:      94,887
  Successful (2xx):    92,800  (97.8%)
  Client errors (4xx): 1,802   (1.9%)
  Server errors (5xx): 285     (0.3%)
  Avg response time:   165ms
  P95 response time:   422ms
  P99 response time:   905ms
  Peak hour:           14:00 UTC  (7,590 req/hr)
  Slowest endpoint:    POST /api/automations/trigger  (avg 820ms)

=== WEEKLY TOTALS ===
  Total requests:      541,466
  Total errors (5xx):  5,447
  Overall error rate:  1.0%
  Weekly avg response: 172ms
  Busiest day:         Monday (97,512 req)
  Quietest day:        Sunday (38,774 req)

=== TOP ENDPOINTS BY VOLUME ===
  1. GET  /api/tasks              β€” 198,420 req  β€” avg 88ms
  2. POST /api/tasks              β€”  74,310 req  β€” avg 134ms
  3. GET  /api/calendar/events    β€”  61,880 req  β€” avg 102ms
  4. GET  /api/notifications      β€”  58,240 req  β€” avg 71ms
  5. POST /api/integrations/sync  β€”  34,910 req  β€” avg 680ms  *** slow ***
  6. POST /api/automations/triggerβ€”  28,440 req  β€” avg 818ms  *** slow ***
  7. GET  /api/reports/export     β€”  19,200 req  β€” avg 612ms  *** slow ***
  8. POST /api/auth/login         β€”  17,880 req  β€” avg 210ms
  9. GET  /api/team/members       β€”  14,330 req  β€” avg 95ms
 10. PUT  /api/tasks/:id          β€”  13,910 req  β€” avg 141ms

=== RECOMMENDATIONS ===
  - Investigate automations/trigger latency (consistently >800ms all week)
  - Monday morning spike requires pre-warming or queue-based sync throttling
  - reports/export should be moved to async job + polling pattern