Browse categories
Explore
Fiverr Pro
English
$
USD
I will optimize your slow postgresql queries and database indexes
Senior Backend and Web Scraping Engineer, Data Extraction, ETL, PostgreSQL
Senior backend and ETL engineer. I build data systems that run in production, not just demos.
I run a microservices platform (Java 21, Spring Boot, RabbitMQ, PostgreSQL) that scrapes real estate acro...
About this Gig
Is a query taking seconds when it should take milliseconds? I optimize PostgreSQL so your app stops waiting on the database. I tune a production database every day and have cut report queries from minutes to seconds.
What I do:
- Read your slow query and its EXPLAIN ANALYZE plan
- - Find the real cause: missing or wrong indexes, bad joins, type mismatches, N+1, planner issues
- - Add the right indexes and rewrite the query
- - Show before and after timings so you see the gain
- - Short written notes so your team can keep the pattern
Send me the query, the table sizes and an EXPLAIN ANALYZE if you have one. I will tell you what is possible before you order. Works for PostgreSQL on any host (RDS, Supabase, self-hosted).
Database type:
Relational database
Platform:
PostgreSQL
Expertise:
SQL
•
Performance
•
Query optimization
FAQ
What do you need from me?
The query, approximate table sizes, and an EXPLAIN ANALYZE output if you can run one.
Can you work without direct database access?
Yes. Plans and schema are usually enough. Direct access is optional.
What results can I expect?
It depends on the query, but missing-index and rewrite fixes often turn seconds into milliseconds.
Do you cover other databases?
This gig is PostgreSQL only, which is where I go deepest.
