get tables sizes mysql code example

Example: check size table

SELECT pg_size_pretty( pg_total_relation_size('tablename') );
(postgres)