metric_daily723,600 rowsas_of_date leads no index, so this sort reads every matching row and keeps only the top 50 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_at |
|---|
| net_gex | TSM | 2026-10-01 | 372934073.7315860000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| net_gex | TSM | 2026-09-30 | 291459356.1796620000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |