PostgreSQL consulting.
PostgreSQL consulting for the moment queries slow down or the cloud bill jumps. I find the queries and tables behind it and tell you what to change, on the Limited plan for $1,995 a month.
By Badii Boutar · Updated
Illustration: a chess knight.
- Partitioning and indexes
- Query plans read, not guessed
PostgreSQL consulting
What PostgreSQL consulting covers.
- 01
The expensive queries
Which queries cost the most, from your metrics and query plans. The suspect everyone names in the meeting gets checked like the rest.
- 02
Big tables
Old logs and history tables that every query still scans, and whether partitioning fits how you read them.
- 03
Indexes and caching
Missing indexes, unused ones that slow down every write for nothing, and reads that should not reach the database at all.
- 04
Schema and migrations
How your ORM shapes the schema, and migrations that lock tables in production. An ORM will happily write a query no person would.
Process
How it works.
- 01
Day 0
Symptoms
What got slow or expensive, and read-only access to metrics.
- 02
Days 1 to 3
Diagnosis
Query plans, table sizes and the access patterns behind them.
- 03
Call or doc
Plan
Changes ranked by effect, and the order to make them safely.
Proof
From my work.
At one client the team saw a spike in the AWS bill. CloudWatch showed PostgreSQL queries hitting an old logs table of more than 24 GB. Most of those queries asked for a specific time range, so I partitioned the table by quarter. I also found EC2 instances nobody used any more and deleted them.
On the same product, server timeouts led us to add caching and optimize the PostgreSQL and Neo4j queries.
When not to hire me for this
- You need a DBA on call for replication and failover. That is a different job, with a pager.
- Your database is Oracle or SQL Server. I work on PostgreSQL.
Price · USD
Price.
- 01
14-day Trial
I audit one app, codebase, site, store or cloud account, then fix what can be fixed in the 14 days.
Fee credited to your first month if you start a monthly plan within 14 days of the Trial ending.
- Findings ranked by risk, in the first 5 business days
- Fixes for what fits in the 14 days, at the Limited pace
- A written plan for the rest, and 1 walkthrough call
$995
14 days, one time
Start · $995Secure checkout via Stripe · Refund policy
- 02
Limited plan
The same developer and the same quality, in the slower lane.
- 1 task at a time, unlimited queue
- A day of work delivered within 2 to 3 working days
- Messages answered the same working day
- Calls by appointment, booked after Full plan clients
- 4 seats: 4 clients at a time
$1,995 / month
Monthly, pause or cancel anytime
Start · $1,995/moSecure checkout via Stripe · Refund policy
- Monthly plans are billed from the day you start. Pause or cancel anytime before the next billing date.
- One task is a piece of work that fits in 1 to 5 working days. I size tasks and split bigger ones.
- Your queue is unlimited and you set the order. I work through it one task at a time.
- Messages are answered the same working day, Monday to Friday. All code and accounts stay yours.
- Not included: 24/7 emergency support, and your own tool bills (hosting, APIs, payment fees).
- The 14-day Trial is paid upfront and runs at the Limited pace. Fee credited to your first month if you start a monthly plan within 14 days of the Trial ending.
- The Trial does not renew. If you do not start a plan, it ends on day 14 and nothing else is charged.
- Prices exclude VAT. EU businesses with a valid VAT number pay no VAT on the invoice (reverse charge). Invoices come from Pan African Center for Entrepreneurship in the Netherlands.
- Founding rate: the first 3 clients get 20% off, in return for a named testimonial and a case study. On a monthly plan, the 20% applies to the first month.
- All three prices, and what each plan covers
Market
Where my price sits.
What PostgreSQL help costs, November 2026.
- PostgreSQL: contract median £513 a day from 657 rates. 10th percentile £359, 90th £712. Source: ITJobsWatch (UK contract ads), six months to 16 Nov 2026
- UK fractional CTO advisory: £150 to £350 an hour (compiled from other surveys, second-hand). Source: fractional.quest, Sep 2026
- Code audit $1,500 to $2,500 over 3 weeks. Source: SoftKraft (Poland), seen 17 Nov 2026
The Limited plan is $1,995 a month: one task at a time, a day of work delivered within 2 to 3 working days, messages answered the same working day, calls by appointment. The UK advisory band above, £150 to £350 an hour, is billed by time. The 14-day Trial is $995, one time, under the SoftKraft range: I audit one codebase, send findings ranked by risk in the first 5 business days, then fix what can be fixed in the 14 days. I sell this, so read it with that in mind.
FAQ
Questions.
Illustration: a statue of a seated man, deep in thought.
01 When does partitioning help?
When a table is large and most queries filter on the same column, often a date. Then PostgreSQL can skip the partitions a query does not need. If queries filter on something else, an index is usually the better fix, and partitioning only gives you more tables to scan.
02 Do you work with Prisma and Supabase?
Yes. The Merchant Engine runs on Prisma and PostgreSQL, and I have shipped PostgreSQL migrations on Supabase.
Related
Read next
Start
Tell me where the product is stuck.
In 30 minutes we look at where things stand, what you need from a CTO right now, and which option fits. Either way, you leave with a clear next step.
Or email badii@badii.studio
How the call goes
- 01You tell me about the product, the team and the next 6 months.
- 02I ask about the code, the stack and what keeps breaking.
- 03We pick the option that fits, or agree that none does.
09:00 to 20:00 CET
Founding rate: the first 3 clients get 20% off, in return for a named testimonial and a case study. On a monthly plan, the 20% applies to the first month.