(TIL) PSQL: Get The Size Of An Index
Want to get an idea of how much disk space that additional index is taking up?
Want to get an idea of how much disk space that additional index is taking up?
To restore the dump, create a fresh database and then use pg_restore:
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 by e...
Using the pg_dump with the -Fc flag will create a dump of the given database in a custom format. The output of this command can be redirected into a file (th...
If you have connect access to a PostgreSQL database, you can use the pg_database_size() function to get the size of a database in bytes.