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_paramsjsonb |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| IR21320 | 2012-08-01 | 2012-10-11 | 2012-11-08 | 66.700000 | 66.7 | fred_tier_a | /fred/series/observations | {"series_id":"IR21320","full_vintage":true} | 2026-10-01 | 2026-10-01 06:00 | 2026-10-01 06:00 |
| IR21320 | 2012-07-01 | 2012-10-11 | 2012-11-08 | 66.700000 | 66.7 | fred_tier_a | /fred/series/observations | {"series_id":"IR21320","full_vintage":true} | 2026-10-01 | 2026-10-01 06:00 | 2026-10-01 06:00 |
| PCU334112334112 | 2011-11-01 | 2015-04-14 | 9999-12-31 | 66.700000 | 66.7 | fred_tier_a | /fred/series/observations | {"series_id":"PCU334112334112","full_vintage":true} | 2026-10-01 | 2026-10-01 06:00 | 2026-10-01 06:00 |
| PCU3344133344131 | 2004-05-01 | 2015-04-14 | 9999-12-31 | 66.700000 | 66.7 | fred_tier_a | /fred/series/observations | {"series_id":"PCU3344133344131","full_vintage":true} | 2026-10-01 | 2026-10-01 06:00 | 2026-10-01 06:00 |
| PCU3344133344131 | 2004-02-01 | 2015-04-14 | 9999-12-31 | 66.700000 | 66.7 | fred_tier_a | /fred/series/observations | {"series_id":"PCU3344133344131","full_vintage":true} | 2026-10-01 | 2026-10-01 06:00 | 2026-10-01 06:00 |