search

fedspendingtransparency / usaspending-api

Server application to serve U.S. federal spending data via a RESTful API
https://www.usaspending.gov
Creative Commons Zero v1.0 Universal
310 stars 113 forks source link

[DEV-11487] Index update_date on award_search [hotfix][staging] #4198

Closed aguest-kc closed 2 months ago

aguest-kc commented 2 months ago

Description: Index the update_date column on the award_search table to improve the performance of the /api/v2/awards/last_updated/ endpoint.

Technical details:

Requirements for PR merge:

  1. [x] Necessary PR reviewers:
    • [x] Backend
  2. [x] Data validation completed
  3. [x] Appropriate Operations ticket(s) created
  4. [x] Jira Ticket DEV-11487:
    • [x] Link to this Pull-Request

Area for explaining above N/A when needed:

1. Unit & integration tests updated
No tests are affected by this change.

2. API documentation updated
No API documentation is affected by this change.

4. Matview impact assessment completed
No matviews are affected by this change.

5. Frontend impact assessment completed
The frontend is not impacted by this change.