SELECT relname, relpages
FROM pg_class
WHERE relname = 'users'
;
-- users table occupies 1729 pages
-[ RECORD 1 ]-----
relname | users
relpages | 1729
SELECT relname, relpages
FROM pg_class
WHERE relname = 'users'
;
-- users table occupies 1729 pages
-[ RECORD 1 ]-----
relname | users
relpages | 1729