---
title: "Discussion on \"Reading Postgres EXPLAIN ANALYZE when the planner expects 300 rows and gets 15,000\" | Hashnode"
description: "Discussion on \"Reading Postgres EXPLAIN ANALYZE when the planner expects 300 rows and gets 15,000\". A bad plan starts at the lowest node where expected and actual rows split, and every node above it is built on that wrong number."
url: "https://hashnode.com/posts/reading-postgres-explain-analyze-when-the-planner-expects-300-rows-and-gets-15-000/6afcde9438c911cbefe3ffbe"
---

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

Discussion

# [Reading Postgres EXPLAIN ANALYZE when the planner expects 300 rows and gets 15,000](https://anatoliizhadan.hashnode.dev/reading-postgres-explain-analyze-when-the-planner-expects-300-rows-and-gets-15-000?utm_source=hashnode&utm_medium=feed)

A bad plan starts at the lowest node where expected and actual rows split, and every node above it is built on that wrong number.

7h ago · 15 min read · anatoliizhadan.hashnode.dev  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#explain-analyze](https://hashnode.com/tag/explain-analyze)
-   [#query-optimization](https://hashnode.com/tag/query-optimization)
-   [#database](https://hashnode.com/tag/database)
-   [#sql](https://hashnode.com/tag/sql)

## Written by

[Anatolii Zhadan](https://hashnode.com/@anatoliizhadan)

@anatoliizhadan · Lisbon, Portugal

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

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
