Subgraph Audit & Stake/Earnings Indexing

What Is The Problem?

The Livepeer subgraph, the data layer that every Explorer view, governance surface, delegator tool, and tokenomics analysis depends on, has not had a structured audit in a long time, so we lack a current baseline of its performance, technical debt, and indexing gaps before building further on top of it. The concrete first gap: the subgraph cannot efficiently compute delegator or orchestrator stake and earnings per round, which holds back income and tax reporting and any time series view.

Why Does It Matter To the Livepeer Ecosystem?

The subgraph is shared infrastructure used by all downstream surfaces, so its performance and correctness affect every consumer. The work is two steps. First, audit the subgraph and add tooling to measure size and indexing performance, giving us a known baseline before adding more to it. Second, ship the per-round stake and earnings feature on that base. BuilderDAO already identified performance improvements while building two earlier features for us, so concrete issues already exist. Auditing first lets this feature and later additions be implemented and measured against a known baseline rather than added to an unmeasured one. Without it, we have no visibility into whether new features are implemented efficiently or are adding technical debt, since we cannot measure their impact.

What Does Success Look Like?

  • Repeatable tooling to measure subgraph size and indexing performance, runnable locally and in CI, with a baseline captured.

  • The audit produces a named, prioritized list of indexing gaps, missing or mis-modelled events, and technical debt, so future work can build on a known foundation.

  • Per-round delegator and orchestrator stake and earnings are indexed, accurate, and queryable, with a linked deployment and sample query.

  • Explorer maintainers confirm the indexed data can power income and earnings views.

Open Questions

  • Does anyone see objections to doing the audit first to unlock quicker feature enablement on the subgraph, for the improvements listed above or others on the roadmap?

  • Is BuilderDAO the right partner to do this work?

  • Do people see value in per-round delegator stake and earnings tracking?

Origin
Foundation Priority

Please authenticate to join the conversation.

Upvoters
Status

Under Review

Board

Suggest Ecosystem Projects

Date

About 8 hours ago

Author

Rick Staa

Subscribe to post

Get notified by email when there are changes.