postgres query size of database code example

Example: postgres check size table

SELECT pg_size_pretty( pg_total_relation_size('tablename') );