---
title: "Sharafath Ali (@sharafath) | Hashnode"
description: "Code, Coffee, and Creativity – Full-Stack Developer on a Mission! Read the latest articles by Sharafath Ali on Hashnode."
url: "https://hashnode.com/@sharafath"
---

@sharafath

# Sharafath Ali

@sharafath · india · Joined September 2022

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

[Website](https://sharafath-ali.vercel.app/)

## Comments

[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.](https://hashnode.com/posts/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/6a2da274457244362172f9f5/comment/6a3722c608769ccc8d2b490a#reply-6a37250117713937ee285bfd)

Reply · Article · Jun 20 · [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.](https://hashnode.com/posts/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/6a2da274457244362172f9f5)

[❤️❤️](https://hashnode.com/posts/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/6a2da274457244362172f9f5/comment/6a2ec4d7616dd58b7baba9f3#reply-6a2ec7ff6c630fb5e12f9470)

Reply · Article · Jun 14 · [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.](https://hashnode.com/posts/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/6a2da274457244362172f9f5)