Recent Posts

PSQL: List Connections To A Database

less than 1 minute read

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...

PSQL: Sleeping

less than 1 minute read

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 A Table

less than 1 minute read

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...