---
title: "Sameer Raj (@scameeer) | Hashnode"
description: "Sameer Raj (@scameeer) writes on Hashnode. Read their latest articles and follow their work."
url: "https://hashnode.com/@scameeer"
---

@scameeer

# Sameer Raj

@scameeer · Joined January 2024

## Comments

[One of the use cases of EXPLAIN is estimating the number of rows in your table. select count() from table1 is costly, alternatively, explain select count(\*) from table1 will give an estimated result much faster.](https://hashnode.com/posts/explaining-and-analysing-postgres-explain-analyse/6537b8184e2e00d9630e6229/comment/65b02e73a40bb508b5393f9b)

Comment · Article · Jan 23, 2024 · [Explaining and Analysing Postgres EXPLAIN ANALYSE](https://hashnode.com/posts/explaining-and-analysing-postgres-explain-analyse/6537b8184e2e00d9630e6229)

[Such an informative and well-written blog! Rooting for more such blogs.](https://hashnode.com/posts/explaining-and-analysing-postgres-explain-analyse/6537b8184e2e00d9630e6229/comment/65b02d55c1958e28fade359a)

Comment · Article · Jan 23, 2024 · [Explaining and Analysing Postgres EXPLAIN ANALYSE](https://hashnode.com/posts/explaining-and-analysing-postgres-explain-analyse/6537b8184e2e00d9630e6229)
