Skip to content
GreenKube

Historical Analysis

GreenKube stores all collected metrics over time, enabling powerful historical analysis for trend detection, compliance reporting, and capacity planning.

Time-Series Storage

Section titled “Time-Series Storage”

Every collection cycle captures a complete snapshot of your cluster:

  • Per-pod resource usage
  • Per-node power estimation
  • Carbon intensity at collection time
  • Cost data from OpenCost

These snapshots are stored in your chosen backend (PostgreSQL, SQLite, or Elasticsearch) and are available for querying at any time.

Flexible Time Ranges

Section titled “Flexible Time Ranges”

Query any time period through the API, CLI, or dashboard:

Terminal window
# Last 24 hours
greenkube report --period=24h


# Last 7 days
greenkube report --period=7d


# Custom range
greenkube report --from=2024-01-01 --to=2024-01-31


# Last quarter
greenkube report --period=90d

Grouping & Aggregation

Section titled “Grouping & Aggregation”

Metrics can be grouped at different granularities:

GroupingUse Case
HourlyDetailed analysis, peak detection
DailyWeekly trends, daily reports
WeeklyMonth-over-month comparison
MonthlyQuarterly/annual CSRD reports
YearlyLong-term trend analysis
Terminal window
# Daily carbon emissions for January
greenkube report --from=2024-01-01 --to=2024-01-31 --group-by=daily

Export Formats

Section titled “Export Formats”

CSV

Section titled “CSV”

Standard CSV output compatible with Excel, Google Sheets, and BI tools:

Terminal window
greenkube report --format=csv --output=report.csv

JSON

Section titled “JSON”

Structured JSON for programmatic consumption:

Terminal window
greenkube report --format=json --output=report.json

API

Section titled “API”

Full access via REST API for integration with dashboards and pipelines:

Terminal window
GET /api/v1/timeseries?from=2024-01-01&to=2024-01-31&group_by=daily

Use Cases

Section titled “Use Cases”

CSRD Compliance Reporting

Section titled “CSRD Compliance Reporting”

Generate monthly and quarterly emission reports with:

  • Total kgCO₂e per namespace/workload
  • Comparison with previous period
  • Breakdown by Scope (2 and 3)

Capacity Planning

Section titled “Capacity Planning”

Analyze historical trends to:

  • Predict future resource needs
  • Identify growth patterns
  • Plan infrastructure scaling

Cost Allocation

Section titled “Cost Allocation”

Break down cloud spending by:

  • Team / namespace
  • Application / service
  • Time period
  • Provider / region

Optimization Tracking

Section titled “Optimization Tracking”

Measure the impact of optimization actions:

  • Before/after comparison
  • Savings tracking over time
  • ROI calculation on green initiatives

Dashboard Integration

Section titled “Dashboard Integration”

The dashboard includes interactive time-series charts with:

  • Drag-to-zoom on time ranges
  • Overlay comparison (this week vs. last week)
  • Stacked area/bar views for namespace breakdown
  • Real-time updates as new data arrives
Section titled “Related”