PostgreSQLでテーブル件数を取得する

SELECT
    RELNAME
  , N_LIVE_TUP 
FROM
  PG_STAT_USER_TABLES 
WHERE
  SCHEMANAME = 'PUBLIC' 
ORDER BY
  N_LIVE_TUP DESC;