Postgres query tuning in production
Reading EXPLAIN ANALYZE against a live table, and which of its numbers actually predict a slow query.
9 MIN
CASE 01 · HEAVENOFSAILS
Built to measure.
Yacht chartering with real-time availability, per-yacht specification pages and a quote flow that prices extras against selected dates.
STACK
REACT · VITE · TYPESCRIPT
STATUS
Live · operated
DISCIPLINES
6 available
DELIVERED
40+ projects
HOW A PROJECT RUNSEngagement
Engagement
model
Four phases with fixed review gates. No phase starts before the previous one has produced its artefact.
ENGAGEMENT MODEL4 PHASES
01
Discovery1–2 WEEKS
Technical audit, constraints documented, scope agreed
02
Architecture1–2 WEEKS
System design, stack decisions, delivery roadmap
03
Delivery4–12 WEEKS
Sprints against review gates, staging deploys each week
04
OperateONGOING
Monitoring, tuning, incident response, handover on request
CAPABILITIES
→ All servicesSix disciplines
FULL-STACK
Full Stack Development
End-to-end applications. Responsive frontends through to scalable backends, delivered as one system.
BACKENDBackend Development
Server-side systems built for throughput and predictable failure. APIs, auth, real-time processing.
DATADatabase Architecture
Schema design, indexing strategy and migration paths. The right store for the access pattern.
APIAPI Development & Integration
Documented, versioned interfaces. Third-party integration, webhooks, rate limiting and caching.
PERFORMANCEPerformance Optimization
Measured work against real bottlenecks. Bundle splitting, query tuning, caching, monitoring.
CLOUDCloud & DevOps Consulting
Containerised deployment and CI/CD that runs unattended. Environments, scaling, rollback.
INSIGHTS
→ All postsEngineering notes
Choosing Mongo vs Postgres, honestly
The access patterns that genuinely favour a document store, and the far more common ones that do not.
12 MIN
Rate limiting an API gateway
Token bucket against sliding window at the edge, and what each does to a client retrying badly.
7 MIN
Let's scope your next system.
Discovery starts with a technical audit you keep, whether the engagement continues or not.