Skip to content

What we've learned building software.

Write-ups on problems we've run into on real projects, with the fix and the reasoning behind it. Databases, backend systems, AI, and whatever else breaks.

Database engineering

Why your PostgreSQL index isn't making your query faster

You added an index and the query is still slow. Here's why that happens, and how to read EXPLAIN ANALYZE to find out which reason applies to you.

Read article