PSQL: List Connections To A Database
The pg_stat_activity table can be used to determine what connections there currently are to the PostgreSQL server and to a particular database. To see the pr...
Recent Posts
PSQL: Sleeping
Generally you want your SQL statements to run against your database as quickly as possible. For those times when you are doing some sort of debugging or just...
PSQL: Get The Size Of An Index
Want to get an idea of how much disk space that additional index is taking up?
PSQL: Restore a database
To restore the dump, create a fresh database and then use pg_restore:
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...