Pagerduty2Postgres imports data from the PagerDuty API into a Postgres database for easy querying and analysis.
This is an almost identical copy of Stripe's amazing pd2pg solution. Unfortunately, they wrote it in Ruby (yikes) and thus it's undeployable as AWS Lambda (yet?). Also Go is amazing.
This app is designed to be run as AWS Lambda, is written in Go and deployed as a single binary. CloudFormation deployment code is included.
- Collect summary statistics about on-call activity.
- Calculate per-user, per-service, per-escalation-policy on-call metrics.
- Determine the frequency of on-hours vs. off-hours pages.
- Produce custom on-call reports with incident-level detail.
- Back-test proposed on-call changes.
- Perform one-off queries against historical pager data.