department-of-veterans-affairs / va.gov-team

Public resources for building on and in support of VA.gov. Visit complete Knowledge Hub:
https://depo-platform-documentation.scrollhelp.site/index.html
284 stars 206 forks source link

[DRAFT] Postgres Query Duration Spikes #97848

Open AshleyGuerrant opened 5 hours ago

AshleyGuerrant commented 5 hours ago

Status

Update each sprint until completed Date Status Launch Date Notes
11/22/2024 In-progress TBD Specific slow queries have been identified and the relevant VFS teams have been notified about the issues with their queries. Additionally, these slow queries were surfaced in the OCTO Watch Officer Alerts.

Problem Statement

TBD

High Level User Story

As the owners of the RDS, Postgres DB, we need to ensure the Postgres Query average remains below the defined threshold (0.09), so that the database can perform efficiently, and avoid performance degradation for Veterans.

Hypothesis or Bet

If we make this change then we expect this to happen. TBD

OKR

Which Objective / Key Result does this epic push forward? TBD

Definition of done

What must be true in order for you to consider this epic complete?

TBD

Take into consideration Accessibility/QA needs as well as Product, Technical, and Design requirements.

Related Docs

TBD