// advent-of-postgres/day-1
The Failed Deploys
The change freeze starts soon. Find the riskiest service to deploy from two weeks of deploy logs written by four different tools.
The North Pole platform team is getting ready for the busiest night of the year. Alabaster, who runs the team, wants to start the change freeze with the riskiest service. "Show me which service breaks most often when we ship it," she says, and points you at the deploy log.
The log is in the deploys table:
| Column | Type | Notes |
|---|---|---|
id |
int |
Primary key |
service |
text |
One of eight services |
deployed_at |
timestamptz |
When the deploy finished |
status |
text |
What the deploy tool reported |
author |
text |
The elf who pressed the button |
The log covers 24 November to 7 December. Not every service is deployed with the same tool, and the tools do not agree on how to write things down.
Your task
Which service had the most failed deploys from 1 December to 7 December 2026, both days included, in UTC?
Submit the service name.
Stuck? Show a hint
Look at every distinct value in the status column before you filter on it.
Download today's data as SQL to solve it on your own Postgres (14 or later).
Solved this puzzle? Share it.
Tag @thedevopsdaily and share it with the community.
We earn commissions when you shop through the links below.
Bitrise
Managed runners for GitHub Actions
Bitrise Build Hub runs your GitHub Actions jobs on M4 Macs and AMD Linux machines. Change runs-on and keep your workflows, secrets and logs on GitHub.
Atomsized
AWS platform engineering and GitOps
Design and automation for reliable AWS and Kubernetes platforms, safer delivery workflows, and preview and UAT environments your engineers can understand and own.
DigitalOcean
Cloud infrastructure for developers
Simple, reliable cloud computing designed for developers
DevDojo
Developer community & tools
Join a community of developers sharing knowledge and tools
SMTPfast
Developer-first email API
Send transactional and marketing email through a clean REST API. Detailed logs, webhooks, and embeddable signup forms in one dashboard.
QuizAPI
Developer-first quiz platform
Build, generate, and embed quizzes with a powerful REST API. AI-powered question generation and live multiplayer.
Want to support DevOps Daily and reach thousands of developers?
Become a Sponsor