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.
At a glance
- Output
- PDF report + ranked fix list
- Duration
- 24–48 hours
- Starts at
- $9.99
Your team senses the database is slow, the dashboards are blinking, and the slow log is a wall of text — but nobody has time to actually read it. Without an audit, every "fix" is a guess.
We treat the slow log + EXPLAIN plans as evidence, not opinion. Within 48 hours you have a ranked list — by expected impact and risk — so you know which three changes to make first and what to ignore.
Everything in scope, named.
Concrete deliverables — no vague promises about "best practices".
Slow-query log + pg_stat_statements / MySQLTuner analysis
EXPLAIN ANALYZE walkthrough on the top N queries
Index health report (dead, missing, duplicate, redundant)
PDF audit summary you can share with stakeholders
A clear runbook, not a black box.
-
01
Receive
You hand us a sanitised slow log, schema dump, and a brief on the workload (read-heavy, write-heavy, mixed?).
-
02
Profile
We aggregate the slow log with pg_stat_statements / pt-query-digest, pull MySQLTuner / pgBadger reports, and identify the top-N queries by total time.
-
03
Plan
EXPLAIN ANALYZE on each, with row estimates vs actuals. Where the optimiser is wrong, we note why.
-
04
Report
PDF summary + raw outputs + a ranked fix list with expected wins.
Battle-tested, not shiny.
The tools we trust on real production workloads — that's what we'll be using on yours.
Best for
- ✓ Teams seeing rising p95 query times with no clear cause
- ✓ Pre-launch performance check before a marketing push
- ✓ Quarterly health-check on a busy production database
Not the right fit when
- ✕ Schema redesigns from scratch — that's the schema review service
- ✕ Live incident response under 1 hour — call us on the contact line for that
Pick a plan that includes this service.
All plans ship with a 30-day money-back guarantee.
Often paired with
Service 02
Index & query optimization
We rebuild your index strategy on a staging copy, rewrite the worst offenders, and verify with before/after benchmarks.
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 performance audit?
Pick a plan that fits, or send us a paragraph about what's slow — we'll come back within an hour.