26
votes

For example, from the EXPLAIN documentation:

EXPLAIN SELECT * FROM tenk1;

                         QUERY PLAN
-------------------------------------------------------------
 Seq Scan on tenk1  (cost=0.00..458.00 rows=10000 width=244)

What does width=244 mean?

1
Person who downvoted: what's up? A little constructive criticism would be appreciated. - David Wolever

1 Answers

29
votes

This is the "Estimated average width (in bytes) of rows output by this plan node"

Basically each row returned will be 244 bytes.

See Explain for more details.