Kategorien durchsuchen
Entdecken
Fiverr Pro
Deutsch
$
USD
I will optimize sql queries, fix slow databases, and design schemas in postgresql
FullStack Developer, Software Engineer
I am a Software Developer and UI/UX enthusiast focused on building secure, scalable, and modern applications. With a background spanning software engineering, cyber security, and user experience desig...
Über diesen Service
Is a slow database crashing your app, spiking your server CPU to 100%, or causing timeouts?
I analyze query execution plans down to the disk I/O and buffer level to diagnose root-cause bottlenecks and speed up your database by 10x to 1,000x.
What I Diagnose & Fix:
- Deep EXPLAIN (ANALYZE, BUFFERS) Analysis: Eliminate costly Sequential Scans and Disk Hash Aggregates.
- Advanced Indexing: Composite B-Tree Indexes, Partial Indexes, and non-blocking CREATE INDEX CONCURRENTLY scripts.
- ORM Tuning: Eliminate the N+1 Query Problem in Prisma, Django, SQLAlchemy, and TypeORM.
Send me your slow query today to get started!
Plattform:
mySQL
•
PostgreSQL
•
SQLite
•
SQL Server
Expertise:
Design
•
SQL
•
Performance
•
Abfragenoptimierung
FAQ
What information do you need to optimize my query?
Please provide the SQL query, the database engine/version, the approximate row count of involved tables, and if possible, the output of EXPLAIN (ANALYZE, BUFFERS) query;
Do you need direct access to my live database server?
No, direct server access is never required. You only need to share the table schema DDL and query execution plan. I provide safe, non-blocking SQL scripts you can run yourself.
Will adding indexes lock my database tables during production hours?
No. I always provide non-blocking migration scripts (e.g. CREATE INDEX CONCURRENTLY in PostgreSQL) that execute safely under live traffic without locking reads or writes.
