SELECT
    TABLE_SCHEMA,
    TABLE_NAME,
    SUM(CHARACTER_OCTET_LENGTH) AS table_octets,
    SUM(CHARACTER_MAXIMUM_LENGTH) AS table_chars
FROM INFORMATION_SCHEMA.COLUMNS
GROUP BY TABLE_SCHEMA, TABLE_NAME
ORDER BY table_octets desc
LIMIT 20