(TIL) PSQL: Get The Size Of An Index
Want to get an idea of how much disk space that additional index is taking up?
Recent Posts
(TIL) PSQL: Restore a database
To restore the dump, create a fresh database and then use pg_restore:
(TIL) PSQL: Get The Size Of A Table
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...
(TIL) PSQL: Dump a database
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...
(TIL) PSQL: Get The Size Of A Database
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.