Browse categories
Explore
Fiverr Pro
English
$
USD
I will optimize mysql postgresql queries and database
About this Gig
I will analyze and optimize slow MySQL or PostgreSQL queries and database performance.
I can investigate slow SQL queries, analyze EXPLAIN plans, optimize indexes, improve database structure and identify performance bottlenecks.
I work with MySQL, PostgreSQL, Redis and ClickHouse and have experience with high-load web applications and large datasets.
I can help with:
- Slow SQL queries
- EXPLAIN / EXPLAIN ANALYZE
- Index optimization
- Query optimization
- Database performance issues
- Database structure analysis
- Performance bottlenecks
Before starting, I will review your database and confirm the scope of work. Please contact me before ordering if you are not sure which package fits your task.
Platform:
MariaDB
•
MS SQL
•
MySQL
•
PostgreSQL
Expertise:
Data structure
•
SQL
•
NoSQL
•
Query optimization
My Portfolio
FAQ
Can you optimize a slow SQL query?
Yes. I can analyze the query, identify performance bottlenecks and optimize it using query changes, indexes and other appropriate techniques.
Do you work with EXPLAIN and EXPLAIN ANALYZE?
Yes. I can analyze EXPLAIN and EXPLAIN ANALYZE output to identify inefficient execution plans, missing indexes and other performance issues.
Can you optimize database indexes?
Yes. I can review existing indexes and recommend or implement changes to improve query performance and reduce unnecessary database load.
Do you work with both MySQL and PostgreSQL?
Yes. I work with both MySQL and PostgreSQL and can investigate query and database performance issues in existing projects.
Can you analyze a large or high-load database?
Yes. I have experience working with large datasets and high-load web applications. I can investigate slow queries, indexes and database bottlenecks in an existing system.
