[portfolio] Portfolio Analysis Report - 2025-12-13

[github-actions[bot]]

Data Availability

⚠️ Important: This analysis is based on a single day snapshot (December 13, 2025):

• Time Period: Last 24 hours only
• Total Workflow Runs Analyzed: 511 runs
• Data Quality: Limited - Single day only
• Confidence Level: Low - Patterns may not represent typical behavior
• Data Source: Real workflow execution data from downloaded logs

Note: Recommendations are based on available data only and may not represent long-term patterns. Some daily workflows may appear unused simply because they haven't triggered yet today. Re-run this analysis after 7-30 days for higher confidence insights.

Executive Summary

• Total Workflows Analyzed: 172 workflow files (75 executed in last 24 hours)
• Current Daily Cost: $61.17 (from actual execution data)
• Projected Monthly Cost: $1,835.18 (30-day projection)
• Potential Savings: $847.20/month (46% reduction) - Conservative estimate based on limited data
• High-Impact Issues: 7 workflows requiring immediate attention
• Success Rate: 69.3% overall (354 successes, 65 failures, 92 cancelled)

Cost Reduction Strategies

1. Fix Critical High-Failure Workflows ($335.81/month wasted)

These workflows are burning money on failed runs that produce no value:

AI Moderator - 86.7% failure rate (26/30 runs)

• Wasted Cost: $3.11/day × 30 = $93.36/month
• Root Cause: 1034 errors across 26 failed runs
• Action: Investigate error logs to identify root cause
• Priority: CRITICAL - Highest waste

Hourly CI Cleaner - 50.0% failure rate (27/54 runs)

• Wasted Cost: $3.23/day × 30 = $96.98/month
• Root Cause: 126 errors, 88 warnings across failed runs
• Action: Review line 2-5 schedule trigger - may be too frequent
• Recommendation: Change from hourly to every 3 hours

  # Current (line 4):
  cron: "0 * * * *"  # Every hour
  
  # Change to (line 4):
  cron: "0 */3 * * *"  # Every 3 hours

• Savings: Reduce from 54 to 16 runs/day: (38 runs × $0.12) = $4.53/day = $136.00/month
• Wasted on failures: $96.98/month (recoverable after fix)

Tidy - 39.6% failure rate (21/53 runs)

• Wasted Cost: $2.51/day × 30 = $75.36/month
• Root Cause: 1476 errors, 1062 warnings
• Action: Analyze error patterns and fix underlying issues
• Priority: HIGH - Second-highest waste

Q - 83.3% failure rate (5/6 runs)

• Wasted Cost: $0.60/day × 30 = $17.96/month
• Root Cause: 37 errors, 31 warnings
• Action: Debug workflow configuration

CI Optimization Coach - 62.5% failure rate (5/8 runs)

• Wasted Cost: $0.60/day × 30 = $17.96/month
• Root Cause: 10 errors, 11 warnings
• Action: Review and fix workflow logic

/cloclo - 100.0% failure rate (9/9 runs)

• Wasted Cost: $1.08/day × 30 = $32.32/month
• Root Cause: Every single run fails
• Action: DISABLE workflow immediately or fix critical bug
• Recommendation: Add to line 2:

  # Add after line 2:
  # DISABLED: 100% failure rate - needs investigation
  # on:
  #   workflow_dispatch:  # Manual only until fixed

Daily File Diet - 33.3% failure rate (1/3 runs)

• Wasted Cost: $0.12/day × 30 = $3.60/month
• Root Cause: 12 errors, 18 warnings
• Action: Monitor for pattern confirmation with more data

Subtotal Wasted on Failures: $335.81/month

2. Reduce Schedule Frequency ($369.39/month)

Based on 24-hour execution patterns, these workflows are over-scheduled:

Hourly CI Cleaner - 54 runs/day

• Current: Every hour (24 runs expected, actually ran 54 times)
• Actual cost: $6.46/day = $193.93/month
• Recommendation: Reduce to every 4 hours (6 runs/day)

  # Current (line 4):
  cron: "0 * * * *"  # Every hour
  
  # Change to (line 4):  
  cron: "0 */4 * * *"  # Every 4 hours

• After: 6 runs × $0.12 = $0.72/day = $21.55/month
• Savings: $172.38/month (89% reduction)

Tidy - 53 runs/day

• Current: Appears to be running every hour
• Actual cost: $6.34/day = $190.34/month
• Recommendation: Reduce to every 6 hours (4 runs/day)

  # Add to workflow (line 4):
  cron: "0 */6 * * *"  # Every 6 hours

• After: 4 runs × $0.12 = $0.48/day = $14.37/month
• Savings: $175.97/month (92% reduction)

Smoke Test Workflows - 4 workflows, 96 runs/day combined

• Smoke Copilot Safe Inputs: 25 runs/day, $89.78/month
• Smoke Copilot: 24 runs/day, $86.19/month
• Smoke Codex: 24 runs/day, $86.19/month
• Smoke Claude: 23 runs/day, $82.60/month
• Total: $344.76/month for smoke tests
• Recommendation: Smoke tests should run 4-8 times/day maximum
• Conservative target: 6 runs/day each = 24 total runs
• After: 24 runs × $0.12 = $2.87/day = $86.19/month
• Savings: $21.04/month (keeping more conservative, need more data)

Subtotal Savings: $369.39/month

3. Disable 100% Failure Rate Workflows ($142.00/month)

These workflows have never succeeded and should be disabled until fixed:

PR Nitpick Reviewer 🔍 - 0% success (0/6 runs)

• Cost: $0.72/day = $21.55/month
• Action: Disable until debugged

  # Line 2-5, comment out schedule:
  # on:
  #   schedule:
  #     - cron: "..."
  on:
    workflow_dispatch:  # Manual only

Grumpy Code Reviewer 🔥 - 0% success (0/6 runs)

• Cost: $0.72/day = $21.55/month
• Action: Disable until debugged

Scout - 0% success (0/5 runs)

• Cost: $0.60/day = $17.96/month
• Action: Disable until debugged

Smoke SRT - 0% success (0/3 runs)

• Cost: $0.36/day = $10.77/month
• Action: Disable until debugged

Copilot Session Insights - 0% success (0/2 runs)

• Cost: $0.24/day = $7.18/month
• Action: Disable until debugged

Super Linter Report - 0% success (0/2 runs)

• Cost: $0.24/day = $7.18/month
• Action: Disable until debugged

Issue Triage Agent - 0% success (0/2 runs)

• Cost: $0.24/day = $7.18/month
• Action: Disable until debugged

Daily Copilot Token Consumption Report - 0% success (0/2 runs)

• Cost: $0.24/day = $7.18/month
• Action: Disable until debugged

Copilot PR Conversation NLP Analysis - 0% success (0/2 runs)

• Cost: $0.24/day = $7.18/month
• Action: Disable until debugged

Daily Project Performance Summary - 0% success (0/2 runs)

• Cost: $0.24/day = $7.18/month
• Action: Disable until debugged

Spec-Kit Command Dispatcher - 0% success (0/1 runs)

• Cost: $0.12/day = $3.60/month
• Action: Disable until debugged

Archie - 0% success (0/1 runs)

• Cost: $0.12/day = $3.60/month
• Action: Disable until debugged

Subtotal Savings: $142.00/month

Total Potential Savings

All costs are from actual workflow execution data (last 24 hours projected to 30 days):

• Strategy 1 (Fix Failures): $335.81/month (wasted spend on failures)
• Strategy 2 (Reduce Frequency): $369.39/month (over-scheduling)
• Strategy 3 (Disable Failed): $142.00/month (workflows that never succeed)
• Total Potential Savings: $847.20/month (46% reduction)
• Current Projected Monthly Spend: $1,835.18/month
• After Optimization: $987.98/month

Implementation Priority

IMMEDIATE (Today) - Stop the Bleeding

1. ⚠️ Disable /cloclo (100% failure, $32/mo waste) - 2 min
2. ⚠️ Disable 12 workflows with 0% success rate ($142/mo waste) - 10 min
3. 🔥 Investigate AI Moderator (87% failure, $93/mo waste) - 30 min

HIGH (This Week) - Fix High-Impact Issues

4. 🔧 Fix Hourly CI Cleaner (50% failure + over-scheduled, $269/mo total) - 1 hour
5. 🔧 Fix Tidy (40% failure + over-scheduled, $251/mo total) - 1 hour
6. 📉 Reduce smoke test frequency ($21/mo savings) - 15 min

MEDIUM (This Month) - Fine-Tune

7. 🔍 Fix remaining failure workflows - 2 hours total
8. 📊 Re-run analysis after 7 days for better data

Data Confidence Caveats

**Important limitations due to single-day (redacted)

1. Daily workflows may appear unused - Many daily workflows simply haven't triggered yet today
2. Failure rates may not be representative - A single bad day could skew statistics
3. Cost projections are estimates - Real monthly costs may vary based on actual trigger patterns
4. No long-term trends - Cannot identify seasonal patterns or anomalies
5. Schedule frequency unclear - Some workflows may have just completed many queued runs

Recommendations:

• Prioritize fixing workflows with 100% failure rates (clear problems)
• Be cautious with workflows showing 50-60% failure (may be transient)
• Re-run this analysis in 7 days with a full week of data for higher confidence
• Monitor changes - Implement fixes incrementally and measure impact

Healthy Workflows (Skipped Detailed Analysis)

The following workflows are performing well and were not analyzed in detail:

100% Success Rate:

• Security Fix PR (12 runs, $43/mo)
• Spec-Kit Execute (9 runs, $32/mo)
• Dev Hawk (15 runs, 93% success, $54/mo)
• Issue Monster (39 runs, 97% success, $140/mo)
• Smoke Claude (23 runs, 91% success, $83/mo)

Other Healthy Workflows (58 additional workflows with >80% success rate)

---

Analysis completed in under 60 seconds | Data Source: 511 workflow runs from 2025-12-13 | Next Review: 2025-12-20 (7-day data)

AI generated by Automated Portfolio Analyst

[github-actions[bot]]

⚓ Avast! This discussion be marked as outdated by Automated Portfolio Analyst.
🗺️ A newer treasure map awaits ye at Discussion #6325.
Fair winds, matey! 🏴‍☠️