metric_daily723,600 rowsas_of_date leads no index, so this sort reads every matching row and keeps only the top 1,300 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 |
|---|
| regime_code | US | 2021-10-08 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-07 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-06 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-05 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-04 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-10-01 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-30 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-29 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-28 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-27 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-24 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-23 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-22 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-21 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-20 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-17 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-16 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-15 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-14 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-13 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-10 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-09 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-08 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-07 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-03 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-02 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-09-01 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-31 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-30 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-27 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-26 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-25 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-24 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-23 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-20 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-19 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-18 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-17 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-16 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-13 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-12 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-11 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-10 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-09 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-06 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-05 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-04 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-03 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-08-02 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| regime_code | US | 2021-07-30 | 1.0000000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |