EXPLAIN: widths


oscon=>  explain select oid from pg_proc;
                        QUERY PLAN                         
-----------------------------------------------------------
 Seq Scan on pg_proc  (cost=0.00..72.92 rows=1492 width=4)

Shows the estimated bytes in the input set at that level
Not terribly important

Widths of common datatypes within EXPLAIN plans
Data Type	Width
`smallint`	2
`integer`	4
`bigint`	8
`double precision (float)`	8
`boolean`	1
`char`	5
`char(x)`	x+4
`varchar(x)`	x+4
`varchar`	32
`text`	32
`timestamp`	8
`timestamptz`	8
`interval`	16
`oid`	4
`ctid`	6
`bytea`	32
`inet`	32
`cidr`	32

Previous: EXPLAIN explained [Table of Contents] Next: EXPLAIN: rows