Skip to content

Instantly share code, notes, and snippets.

@rroblak
rroblak / 11_node_type_analysis.json
Created December 11, 2025 19:27
OVH Infrastructure Dashboard - 11 Node Type Analysis (Object with keys: alchemy_imply_network_summary)
{
"alchemy_imply_network_summary": [
{
"alchemy_imply_network": "SOLANA_MAINNET",
"total_annual_cost": 1372750.2,
"server_count": 280,
"total_cores": 5882
},
{
"alchemy_imply_network": "MONAD_MAINNET",
@rroblak
rroblak / 10_solana_dashboard.json
Created December 11, 2025 19:27
OVH Infrastructure Dashboard - 10 Solana Dashboard (Object with 7 keys)
{
"overall_summary": {
"total_servers": 288,
"total_committed": 213,
"total_uncommitted": 75,
"total_annual_cost": 1411281.0,
"avg_cost_per_server": 4900.28,
"committed_percentage": 74.0
},
"by_function": [
@rroblak
rroblak / 09_servers_by_region_environment.json
Created December 11, 2025 19:27
OVH Infrastructure Dashboard - 09 Servers By Region Environment (Array with 13 items)
[
{
"region": "ap-south-mum",
"prod_server_count": 8,
"prod_committed_count": 8,
"prod_uncommitted_count": 0,
"prod_annual_cost": 16656.24,
"stg_server_count": 0,
"stg_committed_count": 0,
"stg_uncommitted_count": 0,
@rroblak
rroblak / 08_geo_commitments.json
Created December 11, 2025 19:27
OVH Infrastructure Dashboard - 08 Geo Commitments (Object with keys: _metadata, periods)
{
"_metadata": {
"description": "12-month rolling commitments by geography",
"periods": 3,
"baseline": "Jan 2025 = month index 1"
},
"periods": [
{
"month": "2026-01",
"total_12_month_commitment": 7632163.24,
@rroblak
rroblak / 07_fetch_hardware.json
Created December 11, 2025 19:27
OVH Infrastructure Dashboard - 07 Fetch Hardware (Object with keys: _metadata, servers)
This file has been truncated, but you can view the full file.
{
"_metadata": {
"description": "Servers with hardware specifications",
"total_services": 9464,
"main_servers": 1906,
"enriched_servers": 1732
},
"servers": [
{
"service_id": "37764215",
@rroblak
rroblak / 06_servers_by_expiration.json
Created December 11, 2025 19:26
OVH Infrastructure Dashboard - 06 Servers By Expiration (Object with keys: _metadata, costs_by_month, counts_by_month)
{
"_metadata": {
"description": "Expiration timeline for committed servers",
"total_committed_servers": 1547,
"service_groups": 18,
"timeline_months": 24
},
"costs_by_month": [
{
"expiration_month": "2025-12",
@rroblak
rroblak / 05_service_group_summary.json
Created December 11, 2025 19:26
OVH Infrastructure Dashboard - 05 Service Group Summary (Object with keys: _metadata, summary)
{
"_metadata": {
"description": "Service group summary with commitment status breakdown",
"total_service_groups": 22
},
"summary": [
{
"service_group": "rpc_node",
"committed_host_count": 491,
"committed_annual_cost": 2817081.84,
@rroblak
rroblak / 04_analyze_commitment.json
Created December 11, 2025 19:26
OVH Infrastructure Dashboard - 04 Analyze Commitment (Object with keys: _metadata, servers)
This file has been truncated, but you can view the full file.
{
"_metadata": {
"description": "Servers with environment and commitment status",
"total_servers": 1905,
"committed_servers": 1547,
"uncommitted_available": 358,
"uncommitted_scheduled": 0,
"uncommitted_returned": 0
},
"servers": [
@rroblak
rroblak / 03_combine_servers.json
Created December 11, 2025 19:26
OVH Infrastructure Dashboard - 03 Combine Servers (Object with keys: _metadata, servers)
This file has been truncated, but you can view the full file.
{
"_metadata": {
"description": "Combined server data with costs and discounts",
"total_servers": 1905,
"servers_with_invoiced_costs": 1831,
"servers_with_catalog_costs": 74,
"average_discount_percent": 3.4,
"input_stages": {
"services": "export_services",
"costs": "export_bill_costs"
@rroblak
rroblak / 02_export_bill_costs.json
Created December 11, 2025 19:26
OVH Infrastructure Dashboard - 02 Export Bill Costs (Object with keys: _metadata, services)
{
"_metadata": {
"description": "OVH service monthly costs from actual invoices",
"currency": "USD",
"cost_type": "monthly",
"calculation": "most recent full-month cost, or scaled prorated cost if full-month unavailable",
"billing_period": "last 12 months",
"from_date": "2024-12-11",
"generated_at": "2025-12-11T10:39:28.314379",
"total_services": 2266,