Alert on slow Postgres Queries

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

281 stars 197 forks source link

Alert on slow Postgres Queries #75010

Closed LindseySaari closed 6 months ago

LindseySaari commented 7 months ago

Description

We have a Datadog metric/query specifically for pinpointing slow PostgreSQL queries. Proactively setting up alerts for these slow queries could enable us to detect and address bottlenecks promptly, potentially preventing widespread latency issues across the site.

Tasks

[x] DD Monitor - [Vets-API][PROD][POSTGRES][HIGH QUERY DURATION]
[x] Alert to Slack
[x] Alert to PagerDuty
[x] Add to Terraform

RachalCassity commented 6 months ago

@jennb33 Closing this ticket!