Laetitia Avrot wants to know how large a column is:
Thanks to my colleague Ozair, who sent me a JIRA ticket saying “I need to drop that huge column, what are the consequences?” My first question was: how huge? That’s when the rabbit hole opened.
It looks simple. It is simple. Just use the administrative function
pg_column_size(). Until you have toasted attributes. Then it gets interesting.
Read on for a demonstration.