fred_ice_oas4,078 rowsfred_tier_a136,251 rowsobservation_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.
| series_idtext | observation_date ↑date | realtime_startdate | realtime_enddate | valuenumeric | value_rawtext | sourcetext | endpointtext | request_params |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| DEXTAUS | 2019-08-08 | 2019-08-12 | 9999-12-31 | 31.340000 | 31.34 | fred_tier_a | /fred/series/observations | {"series_id":"DEXTAUS","full_vintage":true} | 2026-09-28 | 2026-09-28 06:00 | 2026-09-28 06:00 |
| DEXTAUS | 2019-08-29 | 2019-09-03 | 9999-12-31 | 31.340000 | 31.34 | fred_tier_a | /fred/series/observations | {"series_id":"DEXTAUS","full_vintage":true} | 2026-09-28 | 2026-09-28 06:00 | 2026-09-28 06:00 |
| DEXTAUS | 2023-12-01 | 2023-12-04 | 9999-12-31 | 31.340000 | 31.34 | fred_tier_a | /fred/series/observations | {"series_id":"DEXTAUS","full_vintage":true} | 2026-09-28 | 2026-09-28 06:00 | 2026-09-28 06:00 |
| DEXTAUS | 2024-01-23 | 2024-01-29 | 9999-12-31 | 31.340000 | 31.34 | fred_tier_a | /fred/series/observations | {"series_id":"DEXTAUS","full_vintage":true} | 2026-09-28 | 2026-09-28 06:00 | 2026-09-28 06:00 |
| DEXTAUS | 2024-01-24 | 2024-01-29 | 9999-12-31 | 31.340000 | 31.34 | fred_tier_a | /fred/series/observations | {"series_id":"DEXTAUS","full_vintage":true} | 2026-09-28 | 2026-09-28 06:00 | 2026-09-28 06:00 |