Live Status Snapshot
sources.{platform}.status:syncing,backfilling,idle, orerrorsources.{platform}.open_events_tracked: Active markets currently monitoredsources.{platform}.backfill_offsets: Progress when replaying historical datatable_counts: Row counts for each physical table
Recent Execution History
- Audit duration spikes (
duration_ms) - Track written rows (
events_written,markets_written) - Inspect
errorpayloads for failed runs - Render Gantt-style timelines with
started_atandcompleted_at
Long-Term Metrics
- First/last successful update timestamps
- Total successful runs per source
- Average duration in seconds
- Recent interval distribution (min/avg/max) for the last 100 runs
- Historical percentile stats (median, p95, p99) to form SLO baselines
Dashboards & Automation Ideas
- Status page: Show
status,last_sync, andactive_backfillsto keep traders informed. - Pager duty: Trigger alerts when
intervals.recent.max_minutesbreaches thresholds. - Capacity planning: Compare
events_writtenvs.markets_writtengrowth week over week.
For schema-level insights, pair these endpoints with Column Statistics and the Sync API reference group.