pg_relation_size() function, we can get the size of a given table.
For instance, if we’d like to see the size of the
we can by executing the following query:
> select pg_relation_size('reservations'); pg_relation_size ------------------ 1531904
This gives us the size of the
reservations table in bytes. As you might
expect, the referenced table needs to be part of the connected database and
on the search path.
See the Postgres docs for more details.