Skip to main content
  • Send to AI

CloudWatch Metrics Insights Queries

These queries were used to produce the data in traffic_report.md.

Path: CloudWatch > Metrics > Query tab Region: us-east-1 (verify) Period: Dec 1, 2025 - Jan 15, 2026 (46 days = 66,240 minutes)

The 46-day window was chosen to include the K6 load test on Nov 24, 2025 alongside regular production traffic through mid-January.

Reusing these queries: The divisor 66240 = 46 days _ 24h _ 60min. To adjust for a different period: your_days * 24 * 60.

Lambda Functions by Project​

ProjectWebQueueCLI
farfallavapor-farfalla-production-dvapor-farfalla-production-d-queuevapor-farfalla-production-d-cli
farfalla-https-guardvapor-farfalla-https-guard-production-vapor-farfalla-https-guard-production-cli
farfalla-integrationsvapor-farfalla-integrations-production-d-vapor-farfalla-integrations-production-d-cli
medusavapor-medusa-production-dvapor-medusa-production-d-queuevapor-medusa-production-d-cli
conigliovapor-coniglio-production-dvapor-coniglio-production-d-queuevapor-coniglio-production-d-cli
castorovapor-castoro-production-d-vapor-castoro-production-d-cli

Query 1: HTTP Requests (Web Functions)​

Total and average per minute for web endpoints.

SELECT FunctionName,
       SUM(Invocations) AS total,
       SUM(Invocations) / 66240 AS avg_per_min
FROM SCHEMA("AWS/Lambda", FunctionName)
WHERE FunctionName IN (
  'vapor-farfalla-production-d',
  'vapor-farfalla-https-guard-production',
  'vapor-farfalla-integrations-production-d',
  'vapor-medusa-production-d',
  'vapor-coniglio-production-d',
  'vapor-castoro-production-d'
)
GROUP BY FunctionName
ORDER BY SUM(Invocations) DESC

Query 2: Queue Invocations​

SELECT FunctionName,
       SUM(Invocations) AS total,
       SUM(Invocations) / 66240 AS avg_per_min
FROM SCHEMA("AWS/Lambda", FunctionName)
WHERE FunctionName IN (
  'vapor-farfalla-production-d-queue',
  'vapor-medusa-production-d-queue',
  'vapor-coniglio-production-d-queue'
)
GROUP BY FunctionName
ORDER BY SUM(Invocations) DESC

Query 3: CLI Invocations​

SELECT FunctionName,
       SUM(Invocations) AS total,
       SUM(Invocations) / 66240 AS avg_per_min
FROM SCHEMA("AWS/Lambda", FunctionName)
WHERE FunctionName IN (
  'vapor-farfalla-production-d-cli',
  'vapor-farfalla-https-guard-production-cli',
  'vapor-farfalla-integrations-production-d-cli',
  'vapor-medusa-production-d-cli',
  'vapor-coniglio-production-d-cli',
  'vapor-castoro-production-d-cli'
)
GROUP BY FunctionName
ORDER BY SUM(Invocations) DESC

Query 4: Peak HTTP Requests (per hour)​

Run with 1-hour period to find peak hours.

SELECT FunctionName,
       MAX(Invocations) AS peak_per_hour,
       MAX(Invocations) / 60 AS peak_per_min
FROM SCHEMA("AWS/Lambda", FunctionName)
WHERE FunctionName IN (
  'vapor-farfalla-production-d',
  'vapor-farfalla-https-guard-production',
  'vapor-farfalla-integrations-production-d',
  'vapor-medusa-production-d',
  'vapor-coniglio-production-d',
  'vapor-castoro-production-d'
)
GROUP BY FunctionName
ORDER BY MAX(Invocations) DESC

Query 5: All Functions Summary​

SELECT FunctionName,
       SUM(Invocations) AS total,
       SUM(Invocations) / 66240 AS avg_per_min,
       AVG(Duration) AS avg_duration_ms,
       MAX(Duration) AS max_duration_ms
FROM SCHEMA("AWS/Lambda", FunctionName)
WHERE FunctionName IN (
  'vapor-farfalla-production-d',
  'vapor-farfalla-production-d-queue',
  'vapor-farfalla-production-d-cli',
  'vapor-farfalla-https-guard-production',
  'vapor-farfalla-https-guard-production-cli',
  'vapor-farfalla-integrations-production-d',
  'vapor-farfalla-integrations-production-d-cli',
  'vapor-medusa-production-d',
  'vapor-medusa-production-d-queue',
  'vapor-medusa-production-d-cli',
  'vapor-coniglio-production-d',
  'vapor-coniglio-production-d-queue',
  'vapor-coniglio-production-d-cli',
  'vapor-castoro-production-d',
  'vapor-castoro-production-d-cli'
)
GROUP BY FunctionName
ORDER BY SUM(Invocations) DESC

Load Test Query (Nov 24, 2025)​

Same queries but set date range to: Nov 24, 2025 00:00 - Nov 24, 2025 23:59 Change divisor to 1440 (minutes in a day)

X

Graph View