pgsql 查询数据库各个表的数据量

SELECT
 relname AS TABLE_NAME,
 reltuples AS rowCounts,
 cast(obj_description(relfilenode,'pg_class') as varchar) as comment
FROM
 pg_class 
WHERE
 relkind = 'r' 
 AND relnamespace = ( SELECT oid FROM pg_namespace WHERE nspname = 'public' ) 
 AND relname not like '%copy%'
ORDER BY
 rowCounts DESC;