Skip to main content

// advent-of-postgres/day-1

Day 1 of 24BeginnerGROUP BYText cleanup

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.

Opens 1 December 2026, 00:00 UTC

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.

No database yet. You get a real Postgres database on Neon, free, with no account.
One statement at a time. Ctrl+Enter or Cmd+Enter runs 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.