I will fix slow sql queries and optimize postgresql database performance
I build SaaS AI agents and Postgres backends
Sobre este Serviço
I fix slow SQL queries and optimize PostgreSQL database performance. That usually means EXPLAIN ANALYZE on the real queries, the right indexes, query rewrites, pagination, and careful migrations. Sometimes the issue is locking, connection pooling, or a hot path in the app, not only the database.
I have shipped Postgres-backed products with this kind of care: TasteOS and Daleeli (including row-level security and, on Daleeli, a transactional outbox), Opero (Drizzle and Postgres), Verdict (Prisma and Postgres), and EAIP (two Postgres databases behind an on-prem platform). I will not invent a speedup number I cannot measure on your system.
Basic is a diagnosis and recommendation for one slow query. Standard is a written audit of up to eight queries. Premium includes the agreed fixes, with before-and-after plans, in a staging environment first. Larger scale work is a custom offer. I do not change production without your approval.
Message me before you order with logs, a staging database, or EXPLAIN output if you have it.
Plataforma:
PostgreSQL
Meu portfólio
Perguntas frequentes
Do I have to give you production database access?
No, and I prefer not to at first. Staging, a sanitized dump, or query plans and logs are enough for Basic. If we change production later, it is with your approval and a rollback plan.
Will you apply migrations on your own?
No. I write the migration and run it on staging first. Production is only after you approve.
What does Basic include, exactly?
A written diagnosis of one slow query: EXPLAIN analysis, why it is slow, and one index or rewrite recommendation. No production changes. A wider audit is Standard. Implementing agreed fixes is Premium.
Can you also change my API or ORM code?
Yes. Slow pages are often N+1 queries, missing pagination, or bad pooling in the app. Standard and Premium include application changes when that is the right fix.
Can you guarantee it will be X times faster?
No. I will measure before and after on your system and show the plans. I will not promise a multiplier I have not measured.
Which Postgres setups do you work with?
Managed and self-hosted Postgres, including Supabase, RDS, Cloud SQL, and ordinary Postgres. Tell me the version and host when you message me.
