I will diagnose and optimize a slow postgresql query

Croatia

I speak English, Bosnian, Croatian, Serbian

Software Engineer for Debugging and Integrations

An API stopped returning the right data? A deployment works locally but fails in production? Send me what you expected, what happened, and what you've tried. I'll help you find where it breaks and exp...
About this Gig

I will review one slow PostgreSQL query and its execution plan to identify where time is spent. You receive an annotated diagnosis, a proposed query rewrite or index change where appropriate, and steps to compare execution time and verify the result rows on representative data. The package includes one revision for the same query. The attainable speedup depends on the data distribution and workload.

Expertise:

Performance monitoring

•

Troubleshooting

Database type:

Relational database