I will optimize slow postgresql and mysql queries and speed up your database

Poland

I speak Ukrainian, Russian, English

1 order completed

Senior Full Stack Developer: Laravel, Go, SaaS

Senior full-stack developer with 8+ years of commercial experience. I build and run SaaS products end to end: Laravel and Symfony or Go on the backend, Vue and Nuxt on the front, PostgreSQL, Docker an...
Vetted by Fiverr Pro

Yurii M was selected by the Fiverr Pro team for their expertise.

Vetted for

  • Software Development

About this Gig

Pages load slowly, reports time out, or your database CPU is always at 100%?

In most cases the problem is a few bad queries or missing indexes, not your server. I find them, fix them, and show you the numbers before and after.

PostgreSQL and MySQL / MariaDB:

  • Find the slowest queries with pg_stat_statements or the MySQL slow query log
  • EXPLAIN ANALYZE, rewrite queries, add the right indexes
  • Fix N+1 queries in Laravel Eloquent, Doctrine and other ORMs
  • Schema review: data types, foreign keys, partitioning for big tables
  • Server config tuning: memory, connections, autovacuum, buffer pool
  • Connection pooling with PgBouncer
  • Monitoring so you see problems before users do

You get: a short report with every change and real timings, for example 4.2 s down to 80 ms.

Why me: backend developer with 10 years of experience, working daily with PostgreSQL, Laravel, Symfony and Go in production.

Message me before ordering with your database type, size and the slow page or query. I will tell you which package fits.

Database type:

Relational database

Platform:

MariaDB

•

MySQL

•

PostgreSQL

Expertise:

SQL

•

Performance

•

Query optimization

My Portfolio