---
title: "Comment by Sameer Raj on \"Explaining and Analysing Postgres EXPLAIN ANALYSE\" | Hashnode"
description: "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(*) fro"
url: "https://hashnode.com/posts/explaining-and-analysing-postgres-explain-analyse/6537b8184e2e00d9630e6229/comment/65b02e73a40bb508b5393f9b"
---

[Discussion](https://hashnode.com/posts/explaining-and-analysing-postgres-explain-analyse/6537b8184e2e00d9630e6229)

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

[Sameer Raj](https://hashnode.com/@scameeer)

[Jan 23, 2024](https://hashnode.com/posts/explaining-and-analysing-postgres-explain-analyse/6537b8184e2e00d9630e6229/comment/65b02e73a40bb508b5393f9b)

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.
