How to optimize a slow PostgreSQL query
A guide to reading EXPLAIN ANALYZE, reducing processed rows and designing a useful index.
↗BLOG_
Notes for building systems that survive the real world.
Backend analysis, explained decisions and patterns you can apply. I write from practical experience, with data and code.
SQL, Postgresql, count7 min
PostgreSQL COUNT: why it can be slow and how to optimize it
How to diagnose and optimize PostgreSQL COUNT queries using EXPLAIN ANALYZE, indexes, selectivity, the visibility map, and alternatives to exact counts.
Read article →
Cloud Run vs Azure Container Apps: choosing your first backend platform
A practical comparison of cost, cold starts, scaling and developer experience, with a decision guide.
↗Modular monolith: the architecture to try before microservices
Clear boundaries, simple deployment and an extraction path when the domain actually demands it.
↗Connection pools: why more connections can make your API slower
A guide to recognizing saturation and designing a test that can size the pool.
↗Metrics that actually help during a production incident
Latency, errors, saturation and traffic turned into a dashboard that cuts diagnosis time.
↗There are no articles in this category.