Derived metrics

core.metric_daily

Derived from the tables above via the registry in app/core/metrics.py. Export is decided per METRIC here, not per source - see core.metric_registry.

730,628 rows

Sources in this table

metric_daily730,628 rows

active:entity_id = SMH×

as_of_date leads no index, so this sort reads every matching row and keeps only the top 1,400 in a heap (the page LIMIT), under a 5s statement timeout.

metric_idtext	entity_idtext	as_of_date ↓date	valuenumeric	sourcetext	endpointtext	request_paramsjsonb	vintage_tstimestamp with time zone	retrieved_attimestamp with time zone