obtain table length in sql code example

Example: check size table

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