查询pg 数据库的表行数，和 表大小

1 问题

查询pg 数据库的表行数，和 表大小

2 实现

      SELECT
          obj_description(c.oid::regclass, 'pg_class') AS tableColumn,
        c.relname AS tableName,
        pg_size_pretty(pg_total_relation_size(c.oid)) AS  totalSize,
        c.reltuples AS rowCount
    FROM pg_class c
    LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
    LEFT JOIN information_schema.tables t ON n.nspname = t.table_schema AND c.relname = t.table_name
    WHERE n.nspname NOT IN ('pg_catalog', 'information_schema')
        AND c.relkind IN ('r', 'p')
        AND (c.relname ='t_data_detail_ssjc_fbz' OR 't_data_detail_ssjc_fbz' IS NULL)
        AND (t.table_name LIKE '%' || COALESCE('t_data_detail_ssjc_fbz', '') || '%')
    ORDER BY c.reltuples DESC
    LIMIT 20