pg_class

How many pages does a table occupy?

SELECT relname, relpages
FROM pg_class
WHERE relname = 'users'
;

-- users table occupies 1729 pages
-[ RECORD 1 ]-----
relname  | users
relpages | 1729