2026-05-08 · 6 min read

Refactoring the Ingest Pipeline

Replace this with the real piece.

Last week I refactored the ingest pipeline. Three things broke on first deploy:

1. Replace this with the first thing that broke.
2. Replace this with the second.
3. Replace this with the third.

EXPLAIN ANALYZE SELECT count(*) FROM events WHERE created_at >= now() - interval '1 day';

The lesson: trust EXPLAIN before trusting your intuition.

← back to the Library