I will optimize slow sql queries for postgresql, sql server and oracle
PostgreSQL and Database Engineer
About this Gig
Slow queries make an app feel broken and cost money on servers. I find out why a query is slow and fix it.
I have worked with databases for 10 years in banking and the public sector, mostly Oracle PL/SQL, Microsoft SQL Server and PostgreSQL. Tuning slow reports and procedures is a big part of my daily job.
What I do:
- read the execution plan and find the real bottleneck
- rewrite the query, add or fix indexes, split heavy procedures
- check that the results stay exactly the same after the change
- explain each change in plain English so your team can keep it fast
What I need from you:
- the slow query or procedure, and roughly how long it takes now
- table structures (DDL) and approximate row counts
- access to a test copy, or an export of the execution plan
I don't need access to your production data. I can work on a test or anonymized copy.
Not sure which package fits? Send me the query first and I'll tell you honestly what it needs.
Database type:
Relational database
Platform:
Oracle
•
PL/SQL
•
PostgreSQL
•
SQL Server
Expertise:
Data warehouse
•
SQL
•
Performance
•
Query optimization
Other Databases Services I Offer
FAQ
Do you need access to my production database?
No. A copy or a staging database is best. If that is not possible, send me the slow queries, their execution plans and table sizes, and I can start from that.
What if a query cannot be made faster?
I will tell you early and explain why. Sometimes the real fix is a schema or design change, and I will describe it in the report so you can decide.
Which databases do you work with?
PostgreSQL, Microsoft SQL Server and Oracle. Supabase projects too, since they run on PostgreSQL.
