Core offer

PostgreSQL Performance Investigation

A bounded investigation of one production PostgreSQL cluster and its dominant workload—using read-only evidence, human-reviewed findings and a measurable validation plan.

Founding price $450 for the first three suitable engagements · Report within 5 business days of receiving agreed evidence · No production access required

Good fit

When the team knows something is wrong, but not which change is safe.

Latency / CPU

p95/p99 grows, database CPU climbs, or a few statements dominate total workload time.

Regressions

A release, version change, data growth or statistics shift changed plan behavior.

Concurrency

Blocking, lock queues, long transactions, connection storms or pool saturation appear under load.

Process

Bounded and async-first.

Report delivered within 5 business days of receiving the agreed evidence. No 24×7 incident-response promise and no production write access.

01

Scope

Define the production symptom, business impact and evidence boundary.

02

Collect

Client-run read-only evidence: workload, plans, locks, indexes and relevant settings.

03

Investigate

Correlate signals and distinguish the symptom from likely root cause.

04

Prioritize

Rank findings by impact, confidence, risk and implementation effort.

05

Validate

Define rollback and before/after checks so the team knows whether the change worked.

Useful evidence

Client-run, read-only inputs

Most of this comes from one read-only collector script.

  • pg_stat_statements or equivalent workload evidence
  • Representative execution plans
  • Schema and relevant indexes
  • pg_stat_activity / waits / locks where relevant
  • Connection and vacuum/statistics context
  • Relevant non-default settings
  • Application symptom and recent-change timeline
  • On RDS/Aurora: Database Insights, CloudWatch and Enhanced Monitoring exports for the same window (what each answers)

Inspect a PostgreSQL plan with PlanReader ↗

You receive

Ranked, actionable findings

  • Report within 5 business days of receiving evidence
  • Executive summary
  • Top findings ranked by impact/confidence
  • Evidence references
  • Recommendation and trade-offs
  • Risk and rollback consideration
  • Validation plan
  • 60-minute review call
  • Follow-up questions by email after delivery: 14 days (7 days at the founding price)

Questions before you request an investigation

What does the initial scope cover?

One PostgreSQL cluster and its dominant production workload. The fit review identifies the symptom, evidence available and decision your team needs to make. Additional clusters or unrelated workloads need a separate scope.

Do we have to grant database access?

No. Your team runs agreed read-only collection and reviews the evidence before sharing it. Credentials and production dumps should stay in your environment.

What if the evidence does not support one clear fix?

The report separates supported findings from hypotheses, states confidence and missing evidence, and recommends the next useful test. A guaranteed performance gain is not part of the offer.

Who implements the changes?

Your engineering team owns production changes. If implementation help is useful, a bounded remediation sprint can be scoped separately after the findings are reviewed.

Request a fit review

Scope guardrail

What this is not.

No production write access

Your team executes changes. I investigate, prioritize and define validation.

No emergency SLA

This is scheduled specialist work, not a substitute for an on-call DBA/SRE incident function.

No guaranteed percentage

Performance improvement depends on workload, implementation and system constraints.

No generic “AI report”

Candidate analysis may use automation, but client-facing findings remain human-reviewed and evidence-linked.

Founding

First three suitable engagements

$450

Used to build independent proof and refine the delivery system.

Request fit review
Standard

After founding proof

$750+

Final scope depends on cluster/workload complexity and evidence available.

See pricing model
Production evidence

Need an independent PostgreSQL investigation?

Start with the problem and the evidence you already have. You will get a direct answer on whether a scoped investigation is the right next step.

Prefer to talk first? Book a 20-minute triage call.