# A free page that draws a PostgreSQL EXPLAIN ANALYZE plan as row flow — retained record

> Retained reddit record from reddit:database.

Canonical: https://highsignal.app/data/records/0feb35373ed0c5f4

[← sources](https://highsignal.app/data)


source: [reddit](https://highsignal.app/data/reddit) (reddit:database)  published 2026-11-18 10:22 ingested 2026-11-19 02:39

[original source ↗](https://www.reddit.com/r/Database/comments/1xzbt2k/a_free_page_that_draws_a_postgresql_explain/)

## retained text



```
The part of a Postgres plan that's hard to read by eye is the row counts. They are per loop, and the estimate sits beside the actual with nothing to show how far apart the two are.  
  
So I drew them. Each band is as wide as the rows that crossed it, over every loop. Where the estimate is off by more than 2×, it is drawn on the band: in the screenshot the planner expected 612 rows from \`orders\` and got 206,880, and every join after it inherits that.

Paste \`EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON)\` output or the text format:

[https://seqora.dev/explain/](https://seqora.dev/explain/)

The plan is read in the page and isn't uploaded. It draws one plan at a time, saves nothing, and can't see your database.

I make Seqora, a desktop database client, and this is its plan view. In the app it runs EXPLAIN on your own connection, and that part is paid. The page is free.
```



document fetched 2026-11-19 00:39 · canonical https://reddit.com/r/Database/comments/1xzbt2k/a_free_page_that_draws_a_postgresql_explain
