Column Lengths vs Current Data.sql

select table_schema, 
       table_name,
       column_name, 
       data_type,
       character_maximum_length,
       (xpath('/row/max/text()',query_to_xml(format('select max(length(%I)) from %I.%I', column_name, table_schema, table_name), true, true, '')))[1]::text::int as max_length
from information_schema.columns
where table_schema = 'ccxp'       
  and data_type = 'character varying'
order by table_schema, table_name, column_name;