Get The Size Of A Table
Last updated
Was this helpful?
Last updated
Was this helpful?
In , I showed a PostgreSQL administrative function, pg_database_size()
, that gets the size of a given database. With the 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 reservations
table, we can executing the following query:
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 for more details.