---
title: "Discussion on \"Explaining and Analysing Postgres EXPLAIN ANALYSE\" | Hashnode"
description: "Discussion on \"Explaining and Analysing Postgres EXPLAIN ANALYSE\". Develop intuition on how SQL queries are being run!"
url: "https://hashnode.com/posts/explaining-and-analysing-postgres-explain-analyse/6537b8184e2e00d9630e6229"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Explaining and Analysing Postgres EXPLAIN ANALYSE](https://blog.akjn.dev/explaining-and-analysing-postgres-explain-analyse?utm_source=hashnode&utm_medium=feed)

Develop intuition on how SQL queries are being run!

Oct 24, 2023 · 16 min read · blog.akjn.dev  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#sql](https://hashnode.com/tag/sql)
-   [#databases](https://hashnode.com/tag/databases)
-   [#software-engineering](https://hashnode.com/tag/software-engineering)
-   [#software-development](https://hashnode.com/tag/software-development)

## Written by

[Akshat Jain](https://hashnode.com/@akjn)

@akjn · India

  
[View profile](https://hashnode.com/@akjn)

Software Engineer at Yugabyte

Backend software engineer from India. Love databases, cloud technologies, and chess.

## Responses 2

Markdown supported · ⌘↵ to post

[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.

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

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

Such an informative and well-written blog! Rooting for more such blogs.
