Debugging and logs

{ $.level = "error" }

{ $.message = "*geoencode*" }

{ $.status = 500 }

aws logs tail /ecs/staging/address-api \\
  --follow \\
  --region ap-south-1 \\
  --profile staging

aws logs filter-log-events \\
  --log-group-name /ecs/staging/address-api \\
  --filter-pattern "error" \\
  --start-time $(date -u -d '1 hour ago' +%s)000 \\
  --region ap-south-1

aws logs filter-log-events \\
  --log-group-name /ecs/staging/address-api \\
  --start-time 1734518400000 \\
  --end-time 1734522000000 \\
  --region ap-south-1

{
  "level": "info",
  "time": 1734518400,
  "message": "request completed",
  "method": "POST",
  "path": "/api/v1/geoencode",
  "status": 200,
  "duration_ms": 145,
  "ip": "203.0.113.1"
}

{
  "level": "info",
  "time": 1734518400,
  "message": "geocoding request",
  "address": "94108, CA, US",
  "cached": false,
  "duration_ms": 234
}

{
  "level": "error",
  "time": 1734518400,
  "message": "geocoding failed",
  "address": "invalid address",
  "error": "ZERO_RESULTS",
  "provider": "google"
}

{
  "level": "error",
  "time": 1734518400,
  "message": "database connection failed",
  "error": "connection refused",
  "host": "staging-address-api-postgres.xxxxx.rds.amazonaws.com"
}

{
  "level": "info",
  "time": 1734518400,
  "message": "applying migration",
  "version": "20251217091243",
  "description": "initializing_iso_3166"
}

fields @timestamp, message, error
| filter level = "error"
| stats count() by message
| sort count desc
| limit 10

fields @timestamp, duration_ms
| filter ispresent(duration_ms)
| stats avg(duration_ms), pct(duration_ms, 50), pct(duration_ms, 95), pct(duration_ms, 99)

fields @timestamp, path, status
| filter ispresent(path)
| stats count() by path, status
| sort count desc

fields @timestamp, level
| stats count() as total, sum(level = "error") as errors by bin(5m)
| fields @timestamp, (errors / total * 100) as error_rate

aws ecs list-tasks \\
  --cluster staging-ecs-cluster \\
  --service-name address-api \\
  --region ap-south-1

aws ecs execute-command \\
  --cluster staging-ecs-cluster \\
  --task <task-id> \\
  --container address-api \\
  --interactive \\
  --command "/bin/sh"

# Check environment variables
env | grep RDS

# Test database connection
psql $DATABASE_URL -c "SELECT 1"

# Check disk usage
df -h

# View running processes
ps aux