Service 02
Index & query optimization
We rebuild your index strategy on a staging copy, rewrite the worst offenders, and verify with before/after benchmarks.
At a glance
- Output
- Apply + rollback SQL, benchmarks
- Duration
- 2–3 business days
- Starts at
- $13.00
Indexes accumulate over years — added "just in case", duplicated by accident, or made wide enough to be useless. Meanwhile the queries that actually matter scan more pages than they need to.
Every index we propose is benchmarked on a staging copy with production-shaped traffic. Every change ships with a tested rollback. You see the win in milliseconds, not vibes.
Everything in scope, named.
Concrete deliverables — no vague promises about "best practices".
Composite + covering indexes, B-tree vs GIN/GiST trade-offs
Query rewrites (subquery → JOIN, CTEs, window functions)
Dead-index removal with replication-safe rollout
Before / after benchmark report on production-shaped data
A clear runbook, not a black box.
-
01
Audit
Dead, missing, duplicate, and redundant indexes are mapped. Composite vs covering trade-offs are listed per query.
-
02
Stage
New indexes go onto a staging copy. We replay traffic and measure p50/p95/p99 deltas.
-
03
Rewrite
For queries the optimiser misreads, we rewrite the SQL — usually subquery → JOIN, or a CTE pulled out of a hot path.
-
04
Apply
Replication-safe rollout in production. Idempotent apply scripts + verified rollback included.
Battle-tested, not shiny.
The tools we trust on real production workloads — that's what we'll be using on yours.
Best for
- ✓ Hot tables that grew faster than the index strategy
- ✓ Workloads where one or two queries dominate p95
- ✓ Fixing the things the audit ranked at the top
Not the right fit when
- ✕ Schema modelling problems — those need a schema review
- ✕ Cross-engine migrations — those go through the migration service
Pick a plan that includes this service.
All plans ship with a 30-day money-back guarantee.
Often paired with
Service 01
Performance audit
A focused read of your slow-query log, EXPLAIN plans, and missing indexes — turned into a punch list of the highest-impact fixes.
Read more
Service 03
Database migration
Single-engine upgrades or full cross-engine migrations using pgloader, AWS DMS, or custom ETL pipelines — with a verified cutover.
Read more
Service 04
Schema review & normalization
A senior pair-of-eyes on your schema — flagging accidental N+1 designs, denormalisation that hurt you, and modelling that won't scale.
Read moreReady to start your index & query optimization?
Pick a plan that fits, or send us a paragraph about what's slow — we'll come back within an hour.