OceanBase
-- DATA_MB 数据大小MB、rows 数据条数
SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_COMMENT,concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') DATA_MB,
sum(table_rows) rows,
update_time
FROM information_schema.tables
WHERE table_schema= 'XXXX'
GROUP BY TABLE_NAME ORDER BY DATA_MB desc;