Home
Feed

Extend

Hashnode Pro
Hashnode for Agents

Resources

The foreword
Hashnode gql skill

Buildful - AI coding agent that delivers frontier-level results at a fraction of the cost Bug0 - The AI-native e2e QA regression testing Hackathons Changelog Brand @hashnode on X Hashnode on LinkedIn Support - hello+support@hashnode.com Code of Conduct Terms Privacy Sitemap

Search Hashnode

Search posts, tags, users, and pages

Discussion on "My PostgreSQL query went from 57ms to 1.4ms on a 1 million + row table. I didn't change the query. Here's what I did." | Hashnode

Feed/

Discussion

My PostgreSQL query went from 57ms to 1.4ms on a 1 million + row table. I didn't change the query. Here's what I did.

Learn how to use EXPLAIN ANALYZE to find slow PostgreSQL queries, when to add an index, and why over-indexing hurts.

Jun 13·10 min read·sharafath.hashnode.devRead the article

#indexing

#frontend-development

Written by

Sharafath Ali

@sharafath · india

View profile

Code, Coffee, and Creativity – Full-Stack Developer on a Mission!

I'm a Full-Stack Developer with 3+ years of experience building scalable applications and solving real-world engineering challenges. Here, I write about software development, backend systems, DevOps, cloud technologies, system design, and lessons learned from building production-ready software.

Responses4

Markdown supported · ⌘↵ to post

databas

Jun 20

did u check if the planner just cached the plan after an analyze run. its wierd how often that happens untill u realize the statistics were just stale and needed a quick refresh.

Sharafath Ali

Jun 20

nice point. I actually ran "ANALYZE users;" and executed the query multiple times before taking the before/after samples. Initially the timings were a bit higher and varied, but after refreshing statistics and running the query a few times, they stabilized around the numbers I used. The earlier variance may have been due to stale PostgreSQL statistics and cache warming effects.

GameNetic

Jun 14

It's an informative article. Thanks for posting it man

Sharafath Ali

❤️❤️

Jun 14