Query the recommended column order for PostgreSQL tables

README.md

Optimize PostgreSQL Data Storage

Simply ordering your table's columnns for more efficient datatype storage can save up to 30% of disk utilization.

https://blog.2ndquadrant.com/on-rocks-and-sand/

column_order.sql

SELECT
	pg_attribute.attname,
	pg_type.typname,
	pg_type.typalign,
	pg_type.typlen
FROM
	pg_class
JOIN pg_attribute ON pg_attribute.attrelid = pg_class.oid
JOIN pg_type ON pg_type.oid = pg_attribute.atttypid
WHERE
	pg_class.relname = 'YOUR_TABLE_NAME'
AND pg_attribute.attnum >= 0
ORDER BY
	pg_type.typlen DESC, pg_attribute.attname;